Procedure report
-
just4kidds
- Posts: 1
- Joined: Wed Mar 21, 2018 2:01 pm
Procedure report
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: 361
- Joined: Mon Feb 25, 2008 3:09 am
Re: Procedure report
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
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