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.
Excel Pivot Profiles
Three Easy Steps to Use Pivot Profiles
- Download 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.
Files formatted for earlier versions of Excel may be obtained by request to HIRC.