Active Patient Report
Active Patient Report
How do I generate a list of ACTIVE patients. I am trying to do a practice analysis with Schein and they want a report of how many ACTIVE patients for the last 2 years. I have only been open 1 1/2 years so that part is easy. I know I have a small number of patients that have been archived since we know they won't be coming back, but I need to know how many active patients I have. Any help would be appreciated
Re: Active Patient Report
Try this query: Active patients by date range. Just change the dates and place it in the USER Query window.
This will show the patients who have had a procedure completed "active" during the date range.
SET @pos=0;
SELECT @pos:=@pos+1 as numberofpatients, patient.lname, patient.fname, patient.address, patient.address2, patient.city, patient.state, patient.zip from patient, procedurelog
WHERE procedurelog.patnum = patient.patnum
AND patient.patstatus = '0'
AND procedurelog.procdate > '2006-10-01'
AND procedurelog.procdate < '2007-12-31'
GROUP BY patient.patnum
ORDER BY patient.lname
This will show the patients who have had a procedure completed "active" during the date range.
SET @pos=0;
SELECT @pos:=@pos+1 as numberofpatients, patient.lname, patient.fname, patient.address, patient.address2, patient.city, patient.state, patient.zip from patient, procedurelog
WHERE procedurelog.patnum = patient.patnum
AND patient.patstatus = '0'
AND procedurelog.procdate > '2006-10-01'
AND procedurelog.procdate < '2007-12-31'
GROUP BY patient.patnum
ORDER BY patient.lname
____________
Cheers,
Dave Wolf
Cheers,
Dave Wolf