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.

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

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 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.

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

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.

• 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

• 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

• 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 or 866-290-HCUP (4287).