Knowledgebase

ResDAC has developed over 100 articles that cover topics ranging from the CMS data request process through using the data for a study. CMS has developed additional resources, including TAF data quality briefs and TAF data quality state snapshots, examining the quality of the Medicaid data.
Introductory
Articles
CMS offers files from aggregate data to individual person level data. This article describes the differences between the aggregate, public use files, the limited data sets,…
This article describes the Federal Regulations that govern the release of CMS data for research.
The purpose of this article is to identify 1) common strengths of Medicare and Medicaid administrative data and 2)  broad limitations for researchers to consider when…
Researchers and data users who are working with CMS files may need to map zip code information to CMS carriers and localities. This article describes where to find current and historical versions of the file.
This article provides instructions on how to open the Medicare Physician/Supplier Procedure Summary Master (PSPS) file in Microsoft Access or SAS.
Claims for ambulance services are found in both the Carrier and the Outpatient claims data. This article describes how to identify ambulance services.
With the exception of PY 2014, CMS research files do not include beneficiary risk adjustment scores.  However, CMS does provide the programming code and instructions to calculate the three risk adjustments that CMS uses as the basis for managed care payment. 
When importing Medicare cost reports into Microsoft Access, data users should use the “link specifications” option to ensure that each variable imports with the correct data type.
CMS updated several Medicare cost report forms. As a result, during the year of the transition and up to one year after, the facility will have two separate data downloads, one that includes all the data collected under the old form and another one under the new form. 
Hospitals may submit multiple claims for some hospitalizations. This article provides guidance for counting distinct inpatient hospitalizations and for sequencing claims for each distinct hospitalization found in the Inpatient Research Identifiable File (RIF) and Limited Data Set (LDS) files. This guidance is not applicable to the MedPAR because each record in that file is already a distinct hospitalization.
This article provides guidance on how to identify hospital emergency room claims from the Medicare files.
Provide the steps to identify the drug name from the RxNorm database for the NDCs in the BSA PDE PUF. 
This article explains possible discrepancies when using the outpatient file to calculate payment amounts at the claim level and revenue center level.