List of Emergency patients who never had cleaning done

For users or potential users.
Post Reply
SMathew
Posts: 6
Joined: Mon Jul 09, 2012 10:36 am

List of Emergency patients who never had cleaning done

Post by SMathew » Fri May 04, 2018 1:24 pm

Is there a report or query available for those emergency new patients in a date range who never had cleaning done?

Tom Zaccaria
Posts: 353
Joined: Mon Feb 25, 2008 3:09 am

Re: List of Emergency patients who never had cleaning done

Post by Tom Zaccaria » Sat May 05, 2018 2:53 am

Try this

/*217 Patients who need followup-Patients with a procedure in a given list completed in date range but no other procedures on another date,
apts are counted by procedures summed by date, so it works even if you so not use appointments*/
SET @FromDate='2016-1-01' , @ToDate='2016-12-31';
SELECT patient.PatNum, DATE_FORMAT(MAX(ProcDate),'%m/%d/%Y') AS 'LastVisit', COUNT(DISTINCT procedurelog.ProcDate) AS '#Apts'
FROM patient,procedurelog
WHERE patient.PatNum IN
(SELECT DISTINCT p.PatNum FROM patient p
INNER JOIN procedurelog pl ON p.PatNum=pl.PatNum
INNER JOIN procedurecode pc ON pl.CodeNum=pc.CodeNum AND pc.ProcCode IN('D0140')
WHERE pl.ProcStatus='2')
AND procedurelog.PatNum=patient.PatNum AND procedurelog.ProcStatus=2 AND patient.PatStatus=0
GROUP BY procedurelog.PatNum
HAVING (MIN(ProcDate) BETWEEN @FromDate AND @ToDate) AND COUNT(DISTINCT procedurelog.ProcDate)=1
ORDER BY patient.LName, patient.FName;

drtmz

Post Reply