Hello, I am trying to see if Open Dental will work for one of our offices.
I am looking for a way to run a report that will tell me the total patient encounters for a specific time period. Example :
How many Patients were seen between June 1, 2009 - and June 1, 2010?
Thank you in advance for your answer
Danielle
Total Patient Encounters - By date report Help
-
- Posts: 1
- Joined: Sat Jun 12, 2010 3:43 pm
Re: Total Patient Encounters - By date report Help
Your post seems to imply two different questions. The first being patient "visits" (appointments), the second being unique patients. Below are two different queries I use:
1) Visits
SELECT count(distinct appointment.AptNum) as Visits FROM appointment
WHERE appointment.AptStatus=2
AND appointment.AptDateTime >='2009-06-01'
AND appointment.AptDateTime <'2010-06-01'
2) Patients
SELECT COUNT(DISTINCT PatNum) FROM procedurelog
WHERE ProcStatus=2 AND
ProcDate>='2009-06-01' AND
ProcDate<'2010-06-01'
1) Visits
SELECT count(distinct appointment.AptNum) as Visits FROM appointment
WHERE appointment.AptStatus=2
AND appointment.AptDateTime >='2009-06-01'
AND appointment.AptDateTime <'2010-06-01'
2) Patients
SELECT COUNT(DISTINCT PatNum) FROM procedurelog
WHERE ProcStatus=2 AND
ProcDate>='2009-06-01' AND
ProcDate<'2010-06-01'