CMS Inpatient Standard Analytical File

RPC knows that data collection and working with large data sets can be a challenge, and has created the Health Data Store to serve as a continuously updated repository of health care data. The Health Data Store can provide you with customizable data, ranging from large nation-wide data sets to smaller and more pointed reports or health care snapshots. Our experience working with CMS Standard Analytical File (SAF) allows us to query and package the data with confidence. We can also incorporate information from several different data sets to create in-depth, longitudinal analysis of the health care markets you are interested in. Please do not hesitate to contact us to discuss how the Health Data Store can help you with your information needs.

The Centers for Medicare and Medicaid Services (CMS) collects data from all hospitals who provide services to Medicare beneficiaries on an ongoing basis through its fiscal intermediaries, and compiles the data for each calendar year.  One of the resulting datasets, the Standard Analytical File, has data organized at the claim level and includes basic information about the beneficiary and services performed for the beneficiary’s claim. The Health Data Store has created a Data Dictionary which lists all of the file’s data elements. CMS updates this file annually, and the Health Data Store has the most recent update and historical data.

Some useful data elements include:

• Beneficiary’s state of residence
• Hospital where service was provided
• Beneficiary’s race
• Beneficiary’s sex
• ICD-9-CM principle diagnosis code
• Claim diagnosis by DRG code
• Claim payment amount
• Charge amounts by component
• Patient’s discharge status
• Admission date
• Disproportionate share payment amounts

RPC has access to Inpatient SAF data from 2005 to the most recently released year.

Reporting Hospitals
All hospitals seeking Medicare reimbursement for inpatient claims must submit SAF data to CMS. In 2009, there were over 6,000 reporting hospitals.

Data Applicationss
We can provide custom reports, graphs and maps using this data file and combining it with other health care utilization files.

The tabulations and analysis RPC offers based on CMS SAF data has many potential uses for healthcare planners, financial analysts, and hospital executives. RPC offers custom reports using the CMS SAF data, and our consultants are happy to talk to you about how we can use the file to best meet your needs. A sample of the kinds of healthcare and financial data that can be gathered from the file are included below.

• Analysis of the Medicare populations’ demographic characteristics
• Provider or geographic area demographic analysis
• Historical case mix analysis by demographic characteristics
• Comparative analysis of charges by providers and procedural codes
• Historical analysis of charges by providers or geographies
• Comparison of Medicare payment amounts by diagnosis codes, procedure codes or inpatient provider
• Historical analysis of an inpatient provider’s disproportionate share payments

Data Use Restrictions
CMS does not allow any data to be distributed that may make it possible for an individual beneficiary to be identified. To that end, no tabulations using the SAF data that include fewer than 11 beneficiaries may be produced from the data.