Top 25 MS-DRGs Pivot Profiles

Three Easy Steps to Use Pivot Profiles
  1. Download Pivot Profile, preferably to your desktop.
  2. From Pivot worksheet, select variables using drop-down boxes.
  3. Go to Profile worksheet to view results.
  • If you need technical assistance, please call HIRC at (916) 326-3802.
  • Files formatted for earlier versions of Excel may be obtained by request to HIRC.

Statewide Benchmark Top 25 MS-DRGs

The following Excel Pivot Profiles 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 Medicare Severity Diagnosis Related Groups (MS-DRGs) as benchmarks, the table displays the total number of discharges, average charge per stay for the selected hospital, average charge per stay statewide, and compares the hospital and statewide charges. 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 MS-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 MS-DRGs. 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); the top Benchmark MS-DRG reports are based on discharges from October 1st of one year through September 30th of the following year.

Data Download

MS-DRGs
  • Oct. 1, 2014 – Sept. 30, 2015 (MS-DRG Version 32) MS Excel 4.6 MB
  • Oct. 1, 2013 - Sept. 30, 2014 (MS-DRG Version 31) MS Excel 4.57 MB
  • Oct. 1, 2012 - Sept. 30, 2013 (MS-DRG Version 30) MS Excel 5.68 MB
  • Oct. 1, 2011 - Sept. 30, 2012 (MS-DRG Version 29) MS Excel 5.66 MB
  • Oct. 1, 2010 - Sept. 30, 2011 (MS-DRG Version 28) MS Excel 5.68 MB
  • Archive
    • Oct. 1, 2009 - Sept. 30, 2010 (MS-DRG Version 27) MS Excel 5.7 MB
    • Oct. 1, 2008 - Sept. 30, 2009 (MS-DRG Version 26) MS Excel 5.75 MB
    • 2008 (MS-DRG Version 25) MS Excel 6.92 MB
    DRGs

Individual Hospital Top 25 MS-DRGs

The following Excel Pivot Profiles were developed using the patient discharge data file aggregated at the hospital level. The files display the total number of discharges, average charge per stay, average charge per day and average length of stay for the top 25 Medicare-Severity Diagnosis Related Groups (MS-DRGs) for each hospital and for the state as a whole.

On October 1, 2007 the Centers for Medicare & Medicaid Services (CMS) replaced the current 538 Diagnosis Related Groups (DRGs) with 745 MS-DRGs. The grouper software is updated by CMS at the beginning of each federal fiscal year (October 1st); because of this change the Top 25 MS-DRG reports are based on discharges from October 1st of one year through September 30th of the following year.

Data Download

MS-DRGs
  • Oct. 1, 2014 - Sept. 30, 2015 (MS-DRG Version 32) MS Excel 5.45 MB
  • Oct. 1, 2013 - Sept. 30, 2014 (MS-DRG Version 31) MS Excel 5.43 MB
  • Oct. 1, 2012 - Sept. 30, 2013 (MS-DRG Version 30) MS Excel 5.47 MB
  • Oct. 1, 2011 - Sept. 30, 2012 (MS-DRG Version 29) MS Excel 5.46 MB
  • Oct. 1, 2010 - Sept. 30, 2011 (MS-DRG Version 28) MS Excel 5.31 MB
  • Archive
    • Oct. 1, 2009 - Sept. 30, 2010 (MS-DRG Version 27) MS Excel 5.23 MB
    • Oct. 1, 2008 - Sept. 30, 2009 (MS-DRG Version 26) MS Excel 5.3 MB
    • Jan 1 2008 - Sept 30 2008 (MS-DRG Version 25) MS Excel 5.29 MB
    DRGs

Reports on Healthcare Atlas


This page was last updated on Thursday, August 25, 2016.

Search HID Data