Production by Procedure Code

asanders · Post by **asanders** » Tue Dec 18, 2007 8:53 am

How do I print production by procedure code? Thanks.

KimberlyBlunschi · Post by **KimberlyBlunschi** » Tue Dec 18, 2007 11:04 am

This is definitely a report that we would love to have in our office.

drtech · Post by **drtech** » Tue Dec 18, 2007 11:55 am

I think this is the one that used to give me that info. I can't test it right now though because it is broken with the new database setup since the ADA code deal changed..I don't have the time today, but if someone knows how to fix this to work with the new Code Tables then it should be a good report.

SELECT definition.ItemName,
procedurelog.ADACode,
procedurecode.Descript,
Count(*),
AVG(procedurelog.ProcFee) AS $AvgFee,
SUM(procedurelog.ProcFee) AS $TotProcFee,
CAST((SUM(procedurelog.ProcFee)/(SELECT SUM(procedurelog.ProcFee) FROM procedurelog WHERE procedurelog.ProcStatus = '2' AND procedurelog.ProcDate>='2006-01-01' AND procedurelog.ProcDate<='2007-01-01')*100) AS DECIMAL(6,2)) AS Percentage

FROM procedurelog,procedurecode,definition

WHERE procedurelog.ProcStatus = '2'
AND procedurelog.ADACode=procedurecode.ADACode
AND definition.DefNum=procedurecode.ProcCat
AND procedurelog.ProcDate>='2007-01-01' AND procedurelog.ProcDate<='2008-01-01'

GROUP BY procedurelog.ADACode
ORDER BY definition.ItemOrder,procedurelog.ADACode

kapricorn · Post by **kapricorn** » Tue Dec 18, 2007 12:43 pm

I'm not sure if I am missing something or not.

Go to reports
go to proceedures
enter the date range
choose grouped by proceedure code

It should give what you are asking for.

drtech · Post by **drtech** » Tue Dec 18, 2007 12:57 pm

ha, yeah...that is similar to the report I was trying to do the hard way :p