Research Tools

Software Tools

HCUP software tools can be applied to HCUP and other administrative databases to systematically create new data elements from existing data, thereby enhancing a researcher's ability to conduct analyses.

Tools for ICD-10-CM/PCS

Designed for use with International Classification of Diseases, 10th Revision, Clinical Modification/Procedure Coding System (ICD-10-CM/PCS) codes

Clinical Classifications Software Refined (CCSR)
- CCSR for ICD-10-CM Diagnoses
  Groups diagnosis codes into over 530 clinical categories
- CCSR for ICD-10-PCS Procedures
  Groups procedure codes into over 320 clinical categories

Elixhauser Comorbidity Software Refined for ICD-10-CM
Identifies secondary diagnoses as comorbidities

Chronic Condition Indicator Refined (CCIR) for ICD-10-CM
Identifies diagnoses as chronic conditions

Procedure Classes Refined for ICD-10-PCS
Identifies procedures as diagnostic or therapeutic and whether they would be expected to be performed in an operating room

Tools for CPT and HCPCS Level II

Designed for use with Healthcare Common Procedure Coding System (HCPCS) Level I (Current Procedural Terminology (CPT®)) and HCPCS Level II codes

Clinical Classifications Software (CCS) for Services and Procedures
Groups codes into over 240 clinical categories

Surgery Flags for Services and Procedures
Identifies codes as narrowly defined therapeutic invasive surgeries or more broadly defined surgeries that include diagnostic invasive procedures

AHRQ Quality Indicators (QIs)

AHRQ Quality Indicators are standardized, evidence-based measures of healthcare quality that can be used with readily available hospital inpatient administrative data to measure and track clinical performance and outcomes.

Tools for ICD-9-CM

Designed for use with International Classification of Diseases, 9th Revision, Clinical Modification (ICD-9-CM) codes

Clinical Classifications Software (CCS) for ICD-9-CM
Groups diagnosis and procedure codes into clinically meaningful categories

Chronic Condition Indicator (CCI) for ICD-9-CM
Identifies diagnoses as chronic conditions

Elixhauser Comorbidity Software for ICD-9-CM
Identifies secondary diagnoses as comorbidities

Utilization Flags for Revenue Center Codes and ICD-9-CM
Identifies specific hospital services based on procedures and revenue center codes

Procedure Classes for ICD-9-CM
Identifies major, minor, diagnostic and therapeutic procedures

Surgery Flags for ICD-9-CM
Identifies codes as narrowly defined therapeutic invasive surgeries or more broadly defined surgeries that include diagnostic invasive procedures

HCUP Supplemental Files

The HCUP Supplemental Files are available for use with the HCUP databases to enhance a researcher's ability to conduct analyses. These files are not applicable to other administrative databases.

For Use with HCUP Nationwide Databases

NIS-Trend Weights Files**
Needed for NIS longitudinal analyses that cross from 1993-2011 to 2012 or later

NIS Hospital Ownership Files**
Facilitate longitudinal analysis by ownership categories for NIS 1998-2007

NIS 1993-2002 Discharge-Level Supplemental Files*
Facilitate longitudinal analyses that use the NIS 1993-2002

KID-Trend File**
Needed for KID longitudinal analyses that cross from 1997 to later years

For Use with Nationwide and State Databases

Cost-to-Charge Ratio (CCR) Files*
Facilitate estimating resource costs of inpatient care for NIS, KID, NRD, and SID starting in 2001 and emergency department care for NEDS and SEDD starting in 2012

Hospital Market Structure (HMS) Files*
Contain various measures of hospital market competition for NIS, KID, and SID for 1997, 2000, 2003, 2006, and 2009

For Use with HCUP State Databases

Supplemental Variables for Revisit Analyses***
Facilitate analyses that need to track patients within a state and across time and hospital settings in SID, SASD, and SEDD starting in 2003

American Hospital Association (AHA) Linkage Files**
Provide information to link AHA data to SID, SASD, and SEDD starting in 1990 (varies by State and year)

* Available through the online HCUP Central Distributor.
** Available for download using the link provided for the supplemental file details.
*** Recent years included in core database files with purchase; older years (2003-2008) available by contacting the HCUP Central Distributor at HCUP@ahrq.gov.

User Support

Research Tools