The Procedure Summary Report allows users to analyze the utilization of procedure information at the specialty and/or physician level. Users can run reports at the department, specialty and individual physician-level by family, range, or individual CPT code. The tool reports the frequency, Total RVUs, Work RVUs and/or total billings down to the CPT code.
The Procedure Summary Report has numerous drilling options, which offer flexibility as you drill into the procedure detail for your physicians. The report opens showing the data by specialty and rolled-up to the CPT Family level. If you have specific information that you are looking for, you may choose to drill to the CPT Range and Code levels first, or you may choose to drill to the physician level before drilling further into the CPT information. You can also view productivity detail by CPT code, payer class category, site of service, or unique location.
Below is an example of the Procedure Summary report for several Electrophysiologists within the Department of Medicine. The report summarizes the Units, Total RVUs, Work RVUs, and Billings by CPT family for all physicians within each specialty.
Physician 248338 had over $498,580 in billings during Q1 2009. This physician billed 789 units and produced approximately 2,005 WRVUs and 3,201 TRVUs. We can then identify where physician 248338’s work came from: more than 72% of his work came from the Medicine family and the rest from E&M, Surgery, and Radiology work.
One way this report can be used is to compare physician RVU production by CPT code. This is helpful following a review of the Productivity Summary report where variances in RVU generation were identified among physicians who were expected (Reported CFTE) to be similar.
Comparing RVU Production by CPT Code
Starting with the Department of Medicine illustrated on the previous page, this example will focus on a group of Noninvasive Cardiologists in Q1 2009.
1. To update the report view from looking at the Department of Medicine to focusing only on Noninvasive Cardiology, drill down to the specialty level by clicking on the Cardiology: Noninvasive link.
2. Click on the Work RVUs link in the column header to drill down on the WRVU column. After Drilling Down
Click on the link to drill down to the specialty level. The demonstration data set pulls 2 columns of ID numbers in to blind the data, instead of 1 column with
3. The next step is to move the Physician IDs (or names if you choose) to the top of the report so that each physician will have his/her own column. This is a necessary step and the number of rows will increase substantially when we drill down to the CPT code range and again to the individual CPT code.
Move the mouse over the thin line above the Physician ID column so that it becomes light gray-blue in color. Note: 1 of the ID columns was deleted in the creation of this view. Left click on the mouse and drag this field over the Work RVU column header so that the box color changes to a light gray-blue. Release your mouse button and the report will refresh with each physician across the top of the report.
Notice the variance in RVU production, as well as the difference in service mix. Physician 226985’s RVUs came almost
exclusively from the E&M family, where as 73249 and 73251 generated
the majority of their work in the Medicine family.
Left click on the mouse when the thin blue-gray bar appears and drag the Physician ID field over the Work RVUs
4. Lastly, this report allows the user to drill down from CPT family to CPT range and individual CPT code in order to compare productivity at a more granular level and compare physician service mix within the group.
To drill down on to CPT range and then individual CPT code, right click on the think blue- gray bar above the CPT family names. From the menu that appears, choose Down A Level. The report will refresh with CPT code ranges where the CPT families used to be. If you choose to drill down further, repeat the same step of right clicking in the thin blue-gray bar and choosing Down A Level from the menu. The report will again refresh with the CPT code range field replaced with individual CPT codes.
Notice the lighter color of the column heading box when the new field is
placed over it.
Release the mouse button and the report will refresh with each physician across the top in his/her own column. The far right column represents group total RVUs by CPT family. Notice that the WRVU measure is now to the left of the CPT families. The data in the report did
After drilling down on the All CPT Ranges/Codes field, CPT families are
replaced with CPT code ranges.
Drill down on the All CPT Ranges/Codes field again to get to the
From this view, any number of report manipulations can be done to look at the data in multiple ways. If you wanted to look at the top CPT codes by RVUs generated for group in Q1 2009, use the sort feature on the far right column and choose Descending. The report will now show the top CPT codes by RVUs, and proportionate production levels for each code by physician.
The data could also be sorted based on the physician who generated the most RVUs in order to measure what procedures he/she is billing for compared with others in the group.
Pulling All Locations into the Report
The options in the All Locations field are specific to each member institution and represent the various locations at which physicians provide service. This field allows users to measure productivity at the CPT code level by location in WRVUs, TRVUs, billings, or units.
The All Locations dimension is especially useful for divisions that have physicians who practice in multiple locations, such as inpatient hospital and outpatient clinic settings, where the discovery of operational or procedural differences may lead to revenue opportunities.
Physician 73251 generated a substantial proportion of the WRVUs associated
with reading EKG reports, where as Physician 246465 performed all of the
Doppler EKGs.
Where as the best way to pull many of the other dimensions into the report from the Dimension Bar is to open up the drop down menu and choose the desired time period or physician, it is best to pull the All Locations field into the report without selecting specific locations. The report will automatically only pull in those locations associated with the department, specialty, or physician that is being viewed.
For example, to compare the Q1 2009 productivity of the physicians in the Gastroenterology group, first drill down and create a report view for Q1 2009 and GI.
To pull in the All Locations dimension:
1. Use the drag and drop feature in the reports to pull the All Locations dimension into the report view. The placement of the field is important as it will determine what information is shown when the report refreshes. If you want to simply view where each physician practices and get a sense of his/her productivity at each location, drag the All Locations dimension over the CPT family field within the report.
Notice the Dimension Bar reflects Q1 2009 in the Time Period and Gastroenterology for
2. To view where each physician practices but keep the CPT code detail in the report, drag the All Locations dimension to the left CPT family field until a thin blue-gray line appears to expand the report. The report now shows which CPT codes are being billed at each facility. As with the CPT field in other reports, you can drill down from the CPT family to CPT range and individual CPT code.
The report will refresh with the CPT family column replaced with the locations where each
physician practices. Notice productivity is now reported by
location, based on Units, WRVUs, TRVUs, and Billings.