FY 2018 Final Rule and Correction Notice Data Files
Type of File
Impact File and Supporting Data Files
FY 18 Final Rule Impact File (Final Rule and Correction Notice): This file contains data elements by provider that were used in calculating the FY 2018 rates and impacts for the FY 2018 final rule and correction notice.
AOR/BOR File (Final Rule and Correction Notice): This zip file contains 2 zip files, one for the FY 2018 Final Rule and one for the one for the FY 2018 Correction Notice. Each zip file contains one excel spreadsheet with multiple tabs: one for the After Outliers Removed (AOR) and one for the Before Outliers Removed (BOR). There are also two tabs 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.
Case Mix Index File: This file contains the non-transfer adjusted case mix index (CMI) based on the MS-DRGs billed on the claim in the year the claim was incurred (that is, during FY 2016, using the V33 Grouper).
FY 2018 Final Rule: HCRIS Data File: CMS uses hospital cost report data from the Medicare Cost Report, Hospital Form 2552-10, to calculate the Cost-to-Charge Ratios (CCRs) used in the cost based MS-DRG relative weight methodology. The database for the Medicare cost reports is the Healthcare Cost Report Information System (HCRIS). The CCRs used in the calculation of the MS DRG relative weights for the FY 2018 IPPS Final Rule are derived from the March 31, 2017, quarterly update of the FY 2015 HCRIS. (HCRIS is updated on a quarterly basis). Note: this file is found in the Related Links section below.
Standardizing File (Final Rule and Correction Notice): This file contains two tabs, one for the FY 2018 Final Rule and one for the one for the FY 2018 Correction Notice. These files were used to standardize charges for the rate building process.
County to CBSA Crosswalk File and Urban CBSAs and Constituent Counties for Acute Care Hospitals File: This file contains two tabs: A crosswalk of county codes to CBSAs and a list of Urban CBSAs and Constituent Counties for Acute Care Hospitals Files (formerly Table 4E).
FY 2018 Final Rule Wage Index Public Use Files (Final Rule and Correction Notice): The Attached zip file contains 2 zip files, one for the FY 2018 Final Rule and one for the one for the FY 2018 Correction Notice. Each zip file contains a PDF with a description of each zip file. Each zip file contains 6 zip files:
FY 2018 Final Rule Wage Index PUFs; S3 Part II and Occ Mix Data
FY 2018 Final Rule Average Hourly Wage by Provider and CBSA Public Use File
FY 2018 Final Rule Occupational Mix Adjusted and Unadjusted Average Hourly Wages and Occupational Mix Factor by Provider
FY 2018 Final Rule Occupational Mix Adjusted and Unadjusted Average Hourly Wages and Pre-Reclass Wage Indexes by CBSA
FY 2018 Final Rule AHW by Provider Area Listing
FY 2018 IPPS Final Rule: Hospital Readmissions Reduction Program Supplemental Data File: This file contains the FY 2018 payment adjustment factors under the Hospital Readmissions Reduction Program and the number of cases and excess readmissions ratios for the five conditions (heart failure, pneumonia, acute myocardial infarction, chronic obstructive pulmonary disease, total hip/total knee arthroplasty, and coronary artery bypass grafting) used to calculate the payment adjustment factors. In addition, it contains information on the number of cases for each of the applicable conditions excluded in the calculation of the readmission payment adjustment factors, and it contains MS DRG case-mix information to estimate the payment adjustment factors.
FY 2018 IPPS Final Rule: Medicare DSH Supplemental Data File (Final Rule and Correction Notice): This spreadsheet has 6 tabs which contains the following (Text files for each tab are included for Section 508 compliance):
Tab 1: A File Layout for the spreadsheet.
Tab 2: The final rule FY 2018 Factor 3 and data used to calculate Factor 3 to implement Section 3133 of the ACA, Improvements to Medicare DSH Payments.
Tab 3: A list of hospitals used in the final rule that have undergone a merger so that the data of the merged hospitals have been combined to calculate the surviving hospital’s Factor 3 for FY 2018.
Tab 4: The correction notice FY 2018 Factor 3 and data used to calculate Factor 3 to implement Section 3133 of the ACA, Improvements to Medicare DSH Payments.
Tab 5: A list of hospitals used in the correction notice that have undergone a merger so that the data of the merged hospitals have been combined to calculate the surviving hospital’s Factor 3 for FY 2018.
Tab 6 Data used for Medicare DSH estimates to support the calculation of Factor 1.
Factor 3 in the second tab is the proportion of the uncompensated care amount that a DSH hospital will receive under the implementation of Section 3133 of the Affordable Care Act. For FY 2018, Factor 3 is the average of three individual Factor 3s. The individual Factor 3s for the first two years of the three year time period are based on the estimated number of Medicaid days and Medicare SSI days (or, for Puerto Rico a proxy of 14% of Medicaid days) relative to all DSH hospitals' estimated Medicaid days and Medicare SSI days. The individual Factor 3 for the third year of the three year time period is based on the hospital’s estimated uncompensated care costs relative to all DSH hospitals' estimated uncompensated care costs (or, for Puerto Rico, All Inclusive Rate Providers, and IHS/Tribal hospitals, the Factor 3 from the second year of the three year time period). For this purpose, DSH hospitals are identified as those hospitals that are projected to receive DSH payments for FY 2018.
Monthly Summary of Charges for Charge Inflation Factor: Excel spreadsheet contains two tabs. One has monthly charges by provider from April 2015 through March 2015. One has monthly charges by provider from April 2016 through March 2017.
Definition of Medicare Code Edits v35: The ICD-10 Definitions of Medicare Code Edits file contains the following: A description of each coding edit with the corresponding code lists as well as all the edits and the code lists effective for FY 2018. Zip file contains a PDF and text file that is 508 compliant.
ICD-10 MS-DRG Definitions Manual Files v35 (Updated September 11, 2017): A zip file with the ICD-10 MS DRG Definitions Manual (Text Version) contains the complete documentation of the ICD-10 MS-DRG Grouper logic. Note: For an explanation of updates, click on the Errata in the related links section.
ICD-10-CM/PCS MS-DRG v35 Definitions Manual Table of Contents - Full Titles - HTML Versions (Updated September 11, 2017): Click on the link in the "Related Links" section below to access the HTML Version of the Definitions Manual. Note: For an explanation of updates, click on the Errata in the related links section.