Title

FY 2012 Final Rule Data File

Type of File

Impact File, Data Files

Below are the data files and impact file for the FY 2012 Final Rule. The tables for the FY 2012 final rule are located on a separate list.

1. Impact File: This file contains data elements by provider that were used in calculating the FY 2012 rates and impacts.

2. AOR/BOR File: This zip file contains two excel spreadsheets, one for the After Outliers Removed (AOR) and one for the Before Outliers Removed (BOR). There are also two files containing the variable descriptions. The variables in these files are used in the calculations of the relative weights as well as other calculations for the inpatient PPS. All text files in the zip file are for 508 compliance.

3. Case Mix Index File: This file contains FY 2012 hospitals' case mix indexes (CMI) for discharges. A hospital's CMI represents the average diagnosis-related group (DRG) relative weight for that hospital. It is calculated by summing the DRG weights for all Medicare discharges and dividing by the number of discharges.

4. Standardizing File: This file is used to standardize charges for the rate building process. 

5. Historical Weight File: DRG weights and other data since the inception of Inpatient PPS (See imbedded header for each year for layout).

6. Definition of Medicare Code Edits: This file contains a description of each coding edit with corresponding ICD-9-CM code lists. There are two chapters in this file. The first chapter contains all the edits and the code lists for FY 2012. The second chapter summarizes, by edit, the changes in the edit code list from the last release of the MCE. This document is 508 compliant.

7. County to CBSA Crosswalk File: This file lists the CBSA, SSA county code and FIPS county code for all counties. Any changes to the CBSAs through March 2011 have been incorporated. It also contains the old MSA (based on 1990 census data) and old MSA name to which each county was assigned prior to the implementation of CBSAs in FY 2005.

8. Wage Index Public Use Files: Open Attached Zip file. Attached is a PDF with a description of each zip file. Main zip file contains 7 zip files:

1. FY 2012 Final Rule Wage Index PUFs

2. FY 2012 Final Rule Average Hourly Wage by Provider and CBSA Public Use File

3. FY 2012 Final Occupational Mix Adjusted and Unadjusted Average Hourly Wages by Provider

4. FY 2012 Final Occupational Mix Adjusted and Unadjusted Average Hourly Wages and Pre-Reclass Wage Indexes by CBSA

5. FY 2012 Final Occupational Mix Factor by Provider PUF

6. FY 2012 Final Rule AHW by Provider Area Listing

7. Three Year MGCRB Reclassification Data for FY 2013 Applications

9. Section 1109 Files: Contains one excel file with the following files/tables: List of All Counties; Section 1109 Eligible Counties; Final Section 1109 Qualifying Hospitals for FY 2011; Final Section 1109 Qualifying Hospitals for FY 2012; Final Section 1109 Compilation of Payments for FY 2011; Final Section 1109 Compilation of Payments for FY 2012;