| Field | Description |
|---|---|
| pvid | Animal Number |
| Queue | Queue the appointment was made for (as a number) |
| Apptdate | Date and Time of the Appointment |
| Appttime | Time of Appointment |
| ApptLength | Length |
| QueueName | Name of the Queue the appointment was made for. |
| Reason | Sort reason for visit |
| WithWhom | Who is the appointment for? |
| MadeBy | Who made it. |
| MadeWhen | When was it made |
| ChangedBy | Who changed it |
| ChangedWhen | When was it changed |
| Status | Status |
| Arrived | Time Arrived |
| LongReason | Box entries |
| Field | Description |
|---|---|
| DiaryNo | The diary number (1-50) |
| DiaryName | Name of diary |
| DiaryDate | Date |
| SlotHour | The Hour of the day (untimed slots appear under hour '0') |
| TotalSlots | Total number of slots avalable |
| BlockBooked | Number in the hour unavailable due to Block Bookings |
| FreeSlot | Number in the hour free (Un-Booked) |
| BookedSlot | Number in the hour booked out. |