When you use ODBC (or want to write your own SQL) you will need to know what data is available. This document lists all the tables and fields that you can use and report on.
| Tables_in_premvet | |
|---|---|
| analysis | Analysis Codes and descriptions. |
| agroup | Groups the analysis codes are in. |
| animal | Animal details |
| client | Client details |
| clinana | Clinical breakdown by analysis code. |
| clinical | Clinical records |
| created | Date the snapshot was created. |
| diary | Appointment Details. |
| notes | Warning and Notes Usage |
| lab | Lab results (from screen 1). |
| recall | Recall details |
| users | Users Named and Groups |
| stkhist | Stock History File |
| medication | Repeat Prescription Records |
| sheets | Client and Animal Sheets |
| dates | Various Date related details. |
| conlog | Consultation Times |
| waitlog | Waiting Room Statistics |
| address | Address Book |
| history | Condensed History |
| diary | Diary Usage |
| attachments | Attachments / Letters |
| autoprice | Automatic Pricing |
| stockprice | Stock |