The Health Data Store

Contact: DataMeister@healthdatastore.com
512/371-8000 x5

Data Holdings Library
Custom Mapping
Medicare Cost Reports
Medicare Payment Data
Medicare Discharge Data

RPC is pleased to offer The Health Data Store (HDS), a new
sophisticated and comprehensive compilation of health data
sources. HDS combines RPC’s healthcare consulting expertise
with our extensive library of healthcare data and services,
along with our technically knowledgeable and talented staff.
Our data is based on more than 6,000 hospitals and other
healthcare services. The HDS services are highlighted below.
Just a few examples of the kind of data available from our
library and available for your facility’s use are:

Inpatient volumes at the DRG level by hospital
Outpatient volumes at the procedure level by hospital
Financial data at the departmental level by hospital
Statistics at the departmental level by hospital
Hospital-specific quality measurement indicators
Descriptive profile at the hospital level

Data is continually updated as new data becomes available. Custom reports are available upon request. Contact us for a consultation on your data needs at 512/371-8000 x 5.

Data Holdings Library

Data Set	Source
Texas Inpatient Data	Texas Health Care Information Council
Texas Annual Hospital Survey	Texas Health Care Information Council
Texas Worker’s Compensation Data
Florida Inpatient Data	Florida Agency for Healthcare Administration
Florida Outpatient Data	Florida Agency for Healthcare Administration
Florida ER Data	Florida Agency for Healthcare Administration
Florida Financial Survey	Florida Agency for Healthcare Administration
Florida Hospice Need Projection	Florida Agency for Healthcare Administration
California Ambulatory Surgery Data	California Office of Statewide Health Planning and Development
California Inpatient Discharge Data	California Office of Statewide Health Planning and Development
CMS MedPAR (Medicare Provider and Review) Inpatient File	Centers for Medicare & Medicaid Services
CMS Inpatient SAF (Standard Analytical File)	Centers for Medicare & Medicaid Services
CMS Outpatient SAF (Standard Analytical File)	Centers for Medicare & Medicaid Services
CMS Hospice SAF (Standard Analytical File)	Centers for Medicare & Medicaid Services
CMS Denominator File	Centers for Medicare & Medicaid Services
CMS HCRIS File (Hospital Cost Report Data)	Centers for Medicare & Medicaid Services
CMS HHA (Home Health Agency) Cost Report Data	Centers for Medicare & Medicaid Services
CMS SNF (Skilled Nursing Facility) Cost Report Data	Centers for Medicare & Medicaid Services
CMS Hospice Cost Report Data	Centers for Medicare & Medicaid Services
CMS Hospital Service Area File	Centers for Medicare & Medicaid Services
CMS Medicare POS (Provider of Service) File	Centers for Medicare & Medicaid Services
CMS Payment Impact File	Centers for Medicare & Medicaid Services
CMS NPI (National Provider Identifier) File	Centers for Medicare & Medicaid Services
NCHS/CDC Compressed Mortality File	National Center for Health Statistics/Centers for Disease Control

Custom Mapping

RPC has more than 30 years of experience with creating professional, high quality maps. We produce thematic maps, as well as maps showing major highways and landmarks, including your facility, competitor facilities and proposed new locations. Click here for an example of a map RPC created for a Certificate of Need project in Florida.

Examples of Use of Data in the Data Holdings Library

Medicare Cost Reports

Medicare cost reports are required to be filed annually by health care institutions (hospitals, skilled nursing facilities, home health agencies, renal dialysis facilities and hospices) participating in the Medicare program. HCRIS, the Healthcare Cost Reporting Information System, collects information from the filed cost reports. Medicare cost report information is useful for benchmarking and performance comparisons. As examples, it includes data for profitability, return on equity, liquidity, debt and age of plant, balance sheets and income statements. These reports also contain facility specific information at the departmental level: costs, charges, square footage, and certain facility wide FTE data by selected position.

Medicare Payment Data:

Inpatient SAF: The Inpatient SAF contains final action claims data submitted by inpatient hospital providers for reimbursement of facility costs. Some of the information contained in this file includes diagnosis, (ICD-9 diagnosis), procedure (ICD-9 procedure code), Diagnosis Related Group (DRG), dates of service, reimbursement amount, hospital provider, and beneficiary demographic information. Each observation in this file is at the claim level.

Skilled Nursing Facility SAF: The Skilled Nursing Facility (SNF) SAF contains final action claims data submitted by SNF providers. Some of the information contained in this file includes diagnosis and procedure (ICD-9 diagnosis and ICD-9 procedure code), dates of service, reimbursement amount, SNF provider number, and beneficiary demographic information. Each observation in this file is at the claim level.

Outpatient SAF: The Outpatient SAF contains final action claims data submitted by institutional outpatient providers. Examples of institutional outpatient providers include hospital outpatient departments, rural health clinics, renal dialysis facilities, outpatient rehabilitation facilities, comprehensive outpatient rehabilitation facilities, community mental health centers, and ambulatory surgical centers. Some of the information contained in this file includes diagnosis and procedure (ICD-9 diagnosis, ICD-9 procedure code, CMS Common Procedure Coding System (HCPCS) codes), dates of service, reimbursement amount, outpatient provider number, revenue center codes and beneficiary demographic information. Each observation in this file is at the claim level.

Home Health Agency SAF: The Home Health Agency (HHA) SAF contains final action claims data submitted by HHA providers. Some of the information contained in this file includes the number of visits, type of visit (skilled-nursing care, home health aides, physical therapy, speech therapy, occupational therapy, and medical social services), diagnosis (ICD-9 diagnosis), the dates of visits, reimbursement amount, HHA provider number, and beneficiary demographic information. Each observation in this file is at the claim level.

Carrier SAF: The Carrier SAF (old file name Physician/Supplier Part B) contains final action claims data submitted by non-institutional providers. Examples of non-institutional providers include physicians, physician assistants, clinical social workers, nurse practitioners, independent clinical laboratories, ambulance providers, and stand-alone ambulatory surgical centers. Some of the information contained in this file includes diagnosis and procedure (ICD-9 diagnosis, CMS Common Procedure Coding System (HCPCS) codes), dates of service, reimbursement amount, non-institutional provider numbers (e.g., UPIN, PIN), and beneficiary demographic information. Each observation in this file is at the claim level.

Hospice SAF: The Hospice SAF contains final action claims data submitted by Hospice providers. Some of the information contained in this file includes the level of hospice care received (e.g., routine home care, inpatient respite care), terminal diagnosis (ICD-9 diagnosis), the dates of service, reimbursement amount, Hospice provider number, and beneficiary demographic information. Each observation in this file is at the claim level.

Durable Medical Equipment: The Durable Medical Equipment (DME) contains final action claims data submitted by Durable Medical Equipment suppliers. Some of the information contained in this file includes diagnosis, (ICD-9 diagnosis), services provided (CMS Common Procedure Coding System (HCPCS) codes), dates of service, reimbursement amount, DME provider number, and beneficiary demographic information. Each observation in this file is at the claim level.

Hospital Outpatient PPS: The HOPPS file contains select claim level data from the Hospital Outpatient PPS claims. The file contains claims for services paid under the OPPS. This File is often used to evaluate outpatient service payment rates and ambulatory payment classification (APC) rates.

Hospital Outpatient PPS - Partial Hospitalization Program: The HOPPS PHP file contains select claim level data and is derived from partial hospitalization program (PHP) services. Partial Hospitalization programs include services for treatment of mental illness and substance abuse disorders. This file includes records for PHP services furnished by hospitals and community mental health centers (CMHCs) that were paid under the OPPS.

Medicare Physician Identification and Eligibility Registry (MPIER) File: The Medicare Physician Identification and Eligibility Registry (MPIER) file is one of CMS's "Provider of Services" files. CMS receives the information for this file quarterly from Transamerica Occidental Life Insurance Company, the company that maintains the national registry of physicians. The original source of information for this file is the data provided by physicians and other health care practitioners on CMS Forms 855I, 855B and 855R when they apply to become Medicare providers. The information is updated by the Medicare carriers.

The MPIER file contains one record for each practice setting for a physician. Some of the information contained in this file includes UPIN number, name, birth date, death date, medical school and year of graduation, sanction information if any, total number of practice settings for this, the PIN number for this practice setting, state license number, credentials, primary and secondary specialties, billing zipcode, business zipcode, and whether this practice setting is a group or solo practice. An updated version of this file contains physician business address.

Case Mix Index (CMI) File: The CMI file contains 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. CMIs are calculated using both transfer-adjusted cases and unadjusted cases.

Medicare Discharge Data

MEDPAR (Medicare Provider Analysis and Review Files)

The MEDPAR File allows researchers to track inpatient history and patterns/outcomes of care over time. Data of death information is appended up to three years after data of discharge. It is useful for research into chronic disease prevalent in the elderly populations such as cancer, heart disease, and diabetes and for mortality studies. MEDPAR files contain patient origin information by zip code of residence for Medicare patients and DRG specific patient volume, charge and cost information.

MedPAR File: The MedPAR File contains inpatient hospital and skilled nursing facility (SNF) final action stay records. Each MedPAR record represents a stay in an inpatient hospital or SNF. An inpatient "stay" record summarizes all services rendered to a beneficiary from the time of admission to a facility through discharge. Each MedPAR record may represent one claim or multiple claims, depending on the length of a beneficiary's stay and the amount of inpatient services used throughout the stay. The record unit of MedPAR file is the hospital or SNF stay. Annual MedPAR files are available for fiscal years and calendar years 1991 forward. MedPAR Files are finalized 3 years following the close of the calendar year.