Hygiene production

For users or potential users.
Post Reply
PedoDentist
Posts: 13
Joined: Thu Dec 17, 2015 10:10 am

Hygiene production

Post by PedoDentist » Thu Jun 02, 2016 10:12 am

How can I look for hygiene production (not by provider) buyt by what is picked as hygiene procedure?

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

Re: Hygiene production

Post by Tom Zaccaria » Fri Jun 03, 2016 2:58 am

Would this work?

/*126*/ SET @FromDate='2016-01-01' , @ToDate='2016-06-30';
SELECT Count(*),pv.Abbr, pc.ProcCode, pc.AbbrDesc, AVG(pl.ProcFee) as '$Ave. Fee' , SUM(pl.ProcFee) AS '$Tot. Prod' FROM patient
INNER JOIN procedurelog pl ON patient.PatNum=pl.PatNum
INNER JOIN procedurecode pc ON pl.CodeNum= pc.CodeNum
INNER JOIN provider pv ON pl.ProvNum=pv.ProvNum
WHERE pl.ProcStatus = '2' AND (pl.ProcDate >=@FromDate
AND pl.ProcDate <= @ToDate) AND pc.IsHygiene=1
GROUP BY pc.ProcCode
ORDER BY ProcCode;

drtmz

PedoDentist
Posts: 13
Joined: Thu Dec 17, 2015 10:10 am

Re: Hygiene production

Post by PedoDentist » Fri Jun 03, 2016 5:29 am

Almost...when I run the report though, my total for the month is over $80,000 which I know is not correct....what am i doing wrong?

Post Reply