Waiting Room Statistics

Whenever anyone is removed from the Waiting Room List a note is made of how long they have been sitting in the waiting room. This is updated automatically by the system.

Normally you will use either:

Datamajor
Statistics Option

to generate the appropriate reports.

If you want to drill down and look at the figures in more details, find out who retrieved a client, generate different statistics you can do.

The system keeps a CSV (Comma Separated Value) file with all the details, this can be loaded into a spread sheet e.g. Excel, Numbers etc. and manipulated. There is a separate file for each month, they are located in the text folder and be called waitMMYYYY.csv e.g.
for Jan 2001 it will be wait012001.csv for May 2001 it will be wait052001.csv etc.

Use the CSV -> Scan, option on the text utilities menu to access them.

Once you have it loaded we suggest you save a copy to your PC and use that rather than risk overwritting the live version.

It contains the following information:

Column Name	Details
APT_DATE ^*	Date of Appointment (from MR)
APT_TIME ^*	Time of Appointment
DIARY ^*	Which diary the appointment was made in
ARV_DATE	Date of arrival
ARV_TIME	Time of arrival
FOR	Who was the client 'booked' to see
ROOM	Numerical representation of FOR. If this is 257 then it's an action e.g. Drugs, Appointment, Pay etc. 256 is an Emergency Case.
DA_TIME	Time (in mins) between appointment time and arrival time
SEEN_DATE	Date the animal was taken off the list
SEEN_TIME	Time the animal was taken off the list
BY	User who took the animal off the list
WS_TIME	Time (in mins) between arrival time and seen time.
ANIMAL	Premvet 5 record number
NOTES	Text relating to the entry

^* The Appointment details are taken from the diary details on the management record card - if you don't use the diary the APT_DATE and APT_TIME entries will be invalid however the waiting room times will be correct. You should also make sure your diary times use the 24 hours clock.

If it is an Open Surgery, Walk-In or an Emergency then the Appointment details will be blank. If you are using Diary Plus you should make sure you are running version 03.02.01 or later.

If the time difference is out-with the range, 2 hrs early or 1 day late then they will be reset to zero.