Patient List Report
Submitted by Guest on Wed, 06/11/2013 - 12:43
Hi everyone,
I'd just like some clarification on how to interpret the results of the patient list report with regards to the start and end dates.
I presume these are date ranges for the birth date of the animal, but what I want clarified is if one does a search (for example) for all canines born in 2010, do the results come up with EVERY dog born in 2010 that is on our system or every dog born in 2010 that was also ADDED to our system ONLY in 2010?
I hope this makes sense. The question came up when we were looking at seeing how many new pets were added in a certain time frame compared to euthanased animals (ie to see if owners were replacing euthanased pets).
thanks
Sarah
Re: Patient List Report
In your example, it will return all dogs born in 2010.
Note that this report will exclude patients that don't have records for:
If you have migrated from another PMS, some of these values may not be present, so you might have patients with a Birth Date of 2010 that don't show up in the report.
Regards,
Tim
Re: Patient List Report
Tim A - can I beg to differ. The SQL code is as follows:
I would agree with you as regards species and breed, but the DOB uses a left join, and so will include patients with a null DOB - and you can see in the 2nd last line it selects those with a DOB between the specified dates or no DOB set. Note that 'date between X and Y' means date >= X and <= Y.
Regards, Tim G
Re: Patient List Report
You're correct, although it depends on the version of the report the OP is using.
If its the version from the 1.5 or 1.6 release, then it should work as you state.
If its a version from http://www.openvpms.org/customisation/patient-list-report then it will work as I outlined.