Healthcare Information Division
Benchmark DRGs
Statewide Benchmark Top 25 DRGs
The following pdf tables meet the requirements established by AB 1045 and were developed using the patient discharge data file aggregated at the hospital level. Using the statewide Top 25 Diagnosis Related Groups (DRGs) as benchmarks, the table displays the total number of discharges, average charge per stay for the selected hospital and average charge per stay statewide. Note that any particular hospital may not have discharges in all 25 of the Diagnosis Related Groups (e.g., specialty hospitals such as maternity hospitals will not have DRGs for cardiac surgery).
On October 1, 2007 the Centers for Medicare & Medicaid Services (CMS) replaced the current 538 diagnosis-related groups (DRGs) with 745 Medicare-severity DRGs (MSDRGs). OSHPD implemented these changes with the release of its 2008 Patient Discharge Data. The grouper software is updated by CMS at the beginning of each federal fiscal year (October 1st). Version 25.0 of the grouper was applied to discharges from January 1, 2008 through September 30. 2008. MS-DRG Grouper version 26.0 was applied to the discharges from October 1 2008 through September 30, 2009.
Three Easy Steps to Use Pivot Profiles
- Download and unzip Pivot Profile, preferably to your desktop.
- From Pivot worksheet, select variables using drop-down boxes.
- Go to Profile worksheet to view results.
If you need technical assistance, please call HIRC at (916) 326-3802.
MS-DRGs:- Oct. 1, 2009 - Sept. 30, 2010 v2003 WinZip.exe 1.01 MB | WinZip.zip 897.2 KB
Oct. 1, 2009 - Sept. 30, 2010 v2007 WinZip.exe 1.33 MB | WinZip.zip 1.2 MB
* If you are using Microsoft Excel versions 97-2003, please be sure to download the v2003 zip files. If you are using Microsoft Excel 2007, please download v2007 files. - Oct. 1, 2008 - Sept. 30, 2009 v2003 WinZip.exe 982.42 KB | WinZip.zip 914.32 KB
Oct. 1, 2008 - Sept. 30, 2009 v2007 WinZip.exe 1.25 MB | WinZip.zip 1.19 MB
* If you are using Microsoft Excel versions 97-2003, please be sure to download the v2003 zip files. If you are using Microsoft Excel 2007, please download v2007 files. - 2008 WinZip.exe 907.41 KB | WinZip.zip 839.31 KB | pdf 1.94 MB
Los Angeles detail, by Service Planning Area (SPA) WinZip.exe 552 KB| WinZip.zip 490.62 KB | pdf 539.72 KB
DRGs:
- 2007 WinZip.exe 849.55 KB | WinZip.zip 781.47 KB | pdf 1.95 MB
- 2006 WinZip.exe 920.51 KB | WinZip.zip 852.43 KB | pdf 5.16 MB
- 2005 WinZip.exe 872.69 KB | WinZip.zip 804.6 KB | pdf 1.94 MB
Top 25 DRGs:
These pivot profiles and pdf tables display each individual hospital's top 25 DRGs by three categories: number of discharges, average length of stay, and average charge per stay. These were also developed from the patient discharge data file, aggregated at the hospital level but do NOT include statewide benchmarks.
Attention Data Users: Please exercise caution when interpreting OSHPD data. The use of improper assumptions and analytical methods may result in erroneous or misleading conclusions. Conclusions drawn from OSHPD data are the sole responsibility of the user. Users should be aware that financial and utilization data products are based on a dynamic database that is constantly being updated. As a result, the same data item for a facility may change over time or be different between products.
If you are unable to download ZIP or EXE files, please e-mail the OSHPDWebmaster.
Extracted files can be e-mailed to users at no charge.