Procedure report

For users or potential users.
Post Reply
just4kidds
Posts: 1
Joined: Wed Mar 21, 2018 2:01 pm

Procedure report

Post by just4kidds » Wed Mar 21, 2018 2:06 pm

I need to run a report that shows the codes for our top dollar volume dental procedures. I also need a report that shows the amount insurance providers will pay for that procedure. Does anyone know if these reports actually exist? And if so, how do I run them? Thank you.

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

Re: Procedure report

Post by Tom Zaccaria » Wed Mar 21, 2018 2:57 pm

You can start with this: Reports/Released user Queries

Copy and paste below..

/*54*/ SET @FromDate='2007-01-01' , @ToDate='2007-01-15';
SELECT CONCAT(LName, ', ',FName, ' ', MiddleI) As Patient, pc.ProcCode, pl.ProcDate, pl.ProcFee, ps.SplitAmt
FROM patient
INNER JOIN procedurelog pl ON patient.PatNum=pl.PatNum
AND pl.ProcStatus != 6
INNER JOIN procedurecode pc ON pl.CodeNum= pc.CodeNum
LEFT JOIN paysplit ps ON pl.ProcNum=ps.ProcNum
WHERE pl.ProcDate >= @FromDate
AND pl.ProcDate <=@ToDate
ORDER BY patient.LName, patient.FName ASC;

Then try #264

drtmz

Post Reply