Skip Navigation

Cost-to-Charge Ratio Files
The HCUP Cost-to-Charge Ratio Files are hospital-level files designed to supplement the data elements in the NIS and SID databases. These files are created by AHRQ through a Federal-State-Industry partnership.
 
 
Cost-to-Charge Ratio Files

The HCUP Cost-to-Charge Ratio Files are hospital-level files designed to supplement the data elements in the NIS, KID, and SID databases. They are part of a family of databases and software tools developed as part of the Healthcare Cost and Utilization Project (HCUP), a Federal-State-Industry partnership sponsored by the Agency for Healthcare Research and Quality. HCUP databases, tools, and software inform decision making at the national, State, and community levels.

Contents:
Return to Contents
 

The HCUP NIS, SID, and KID contain data on total charges for each hospital in the databases. This charge information represents the amount that hospitals billed for services, but does not reflect how much hospital services actually cost or the specific amounts that hospitals received in payment. In some cases, users may be interested in seeing how hospital charges translate into actual costs.

The HCUP Cost-to-Charge Ratio Files enable this conversion. Each file contains hospital-specific cost-to-charge ratios based on all-payer inpatient cost for nearly every hospital in the corresponding NIS, SID, or KID databases. Cost information was obtained from the hospital accounting reports collected by the Centers for Medicare and Medicaid Services (CMS). Some imputations for missing values were necessary.

Users can merge the data elements on the appropriate file to the corresponding NIS, SID, or KID databases by the data element hospital identification number (HOSPID). Using the merged data elements from the cost-to-charge ratio files and the total charges reported in the NIS, SID, or KID databases, users may convert the hospital total charge data to cost estimates by simply multiplying total charges with the appropriate cost-to-charge ratio.

HCUP Cost-to-Charge Ratio Files are designed to be used exclusively with the HCUP NIS, SID, or KID. These files are unique by year.
 
Return to Contents
 

The HCUP Cost-to-Charge Ratio Files are used to estimate the resource cost of inpatient care and its variation across hospitals and conditions.
 
Return to Contents
 

The following HCUP Cost-to-Charge Ratio Files are currently available:
  • NIS
    • 2011
    • 2010 - revised August 2013
    • 2009
    • 2008
    • 2007
    • 2006
    • 2005
    • 2004
    • 2003
    • 2002
    • 2001
  • SID for most States available through the HCUP Central Distributor
    • 2011
    • 2010 - revised August 2013
    • 2009
    • 2008
    • 2007
    • 2006
    • 2005
    • 2004
    • 2003
    • 2002
    • 2001
  • KID
    • 2009
    • 2006
    • 2003
 
Return to Contents
 

Two versions of the 2010 CCR files were released. The version 2 files (August 2013) are the most recent. An earlier version was released in August 2012.

Cost estimates using earlier versions may differ somewhat from estimates generated with the new CCRs. The initial version contained usable accounting reports for about 61% of HCUP hospitals. The revised 2010 CCR files contain usable 2010 accounting reports for 89% of HCUP hospitals. For hospitals with no usable report in each version, the CCR was imputed from a weighted average for a peer group within the state (GAPICC). For hospitals that were missing accounting reports in the initial files, the APICC was calculated from the updated reports. In addition, several HCUP states had a particularly high proportion of hospitals with missing reports in the initial version, which results in a smaller number of hospitals used for imputation. GAPICC was recalculated using the updated weighted average for a peer group within the state. Additional information is provided in the CCR User Guides for the 2010 NIS and SID.
 
Return to Contents
 

The HCUP Cost-to-Charge Ratio Files can be run on desktop computers with a CD-ROM reader, and are available in ASCII format. The files on the CD require a statistical software package such as SAS or SPSS to use for analytic purposes.
 
Return to Contents
 

The User Guides for the HCUP Cost-to-Charge Ratio Files contain:
  • A more detailed description
  • Instructions for linking the files to the NIS or SID
  • State participation
  • A description of internal validation methods
  • Descriptions of key variables.
Downloading Information

Web Browser Download: Your browser may support loading the User Guides from this Web page. To download the User Guides from this Web page, click on the following links with the right mouse button and select "Save Link As" (Netscape) or "Save Target As" (Internet Explorer). After saving a file, find it by using Windows® Explorer (Windows® 98/95/NT) or File Manager (Windows® 3.x), and then open the file by double-clicking on it.

NIS Guides Central Distributor SID Guides KID Guides
 
Return to Contents
 

HCUP Cost-to-Charge Ratio Files are available from the HCUP Central Distributor. These files are free of charge. Contact the HCUP Central Distributor to obtain your own copy of these files.
 
Return to Contents
 

Internet Citation: Cost-to-Charge Ratio Files. Healthcare Cost and Utilization Project (HCUP). September 2014. Agency for Healthcare Research and Quality, Rockville, MD. www.hcup-us.ahrq.gov/db/state/costtocharge.jsp.
Are you having problems viewing or printing pages on this Website?
If you have comments, suggestions, and/or questions, please contact hcup@ahrq.gov.
Privacy Notice, Viewers & Players
Last modified 9/24/14