Top 35 most utilized codes by revenue (Report)

For users or potential users.
Post Reply
josiedds
Posts: 41
Joined: Tue Sep 18, 2007 11:59 am
Location: Southern California
Contact:

Top 35 most utilized codes by revenue (Report)

Post by josiedds » Tue Jun 14, 2016 2:48 pm

Has anyone done this type of report?
I pulled my procedures report for one year but I'd like to see if I can streamline the report.
I tried the query examples but wasn't able to find one close to this concept.
Can you point me in a direction?

rhaber123
Posts: 415
Joined: Fri Dec 11, 2009 12:09 pm

Re: Top 35 most utilized codes by revenue (Report)

Post by rhaber123 » Tue Jun 14, 2016 6:53 pm

TRY this QUERY
OD support can assist too, but all depends on how the payments were entered in OD
this one sort it by production $$ and not by revenue $$
it is hard to find, specially if you post your payments "as a TOTAL" instead of "BY PROCEDURE"

top 100 procedures monthly or yearly:

SET @FromDate='2016-01-01' , @ToDate='2016-12-31';
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)
GROUP BY pc.ProcCode
ORDER BY Count(*)DESC Limit 100

Once the report is available, export it as an excel document, and to sort it by production, click on sort the result "Tot Prod" from largest to smallest in excel

josiedds
Posts: 41
Joined: Tue Sep 18, 2007 11:59 am
Location: Southern California
Contact:

Re: Top 35 most utilized codes by revenue (Report)

Post by josiedds » Tue Jun 14, 2016 7:16 pm

Thank you so much! I think this will work perfectly! Have an amazing evening!

Post Reply