HCUP Tools and Software Healthcare Cost and Utilization Project

1 hcup tools , software

1.1 hcupnet
1.2 hcup fast stats
1.3 quality indicators (qis)
1.4 clinical classifications software (ccs)
1.5 chronic condition indicator
1.6 elixhauser comorbidity software
1.7 procedure classes
1.8 utilization flags
1.9 surgery flags

hcup tools , software

to enhance capabilities of hcup databases, hcup provides number of tools , software programs can applied hcup , other similar administrative databases. many available download hcup-us website. others may ordered through hcup central distributor. of hcup’s tools , software products free-of-charge.

hcupnet

hcupnet free, online, interactive query system based on hcup data. hcupnet provides statistics hcup national databases (the nis, neds, kid, , nrd) , state databases (the sid, sasd, , sedd) states have agreed participate.

hcupnet can used identifying, tracking, analyzing, , comparing statistics on hospitals, emergency care, ambulatory surgery obtaining measures of quality based on ahrq quality indicators. select statistics available @ national- , county-level. hcupnet can used trend analysis health care data available 1993 forward.

hcupnet includes feature called hospital readmissions provides users statistics on hospital readmissions within 30 days of hospital discharge. information on calculating readmissions hcupnet available in hcup methods series report.

hcup fast stats

hcup fast stats web-based tool provides easy access latest hcup-based statistics health information topics. hcup fast stats uses visual statistical displays in stand-alone graphs, trend figures, or simple tables convey complex information @ glance. first topic in hcup fast stats— effect of health insurance expansion on hospital use (formerly called effect of medicaid expansion on hospital use)—launched in july 2015, data updates released quarterly starting october 2015. topic includes statistics 42 states on number of hospital discharges payer group (medicare, medicaid, private insurance, , uninsured) categories of conditions (surgical, mental health, injury, maternal, , medical). users can run state-by-state comparisons , analyze effects of medicaid expansion on hospital utilization levels , payment sources.

the second topic—national hospital utilization , costs—was released in december 2015. topic focuses on national statistics on inpatient stays: trends, common diagnoses, , common operations.

in july 2016, ahrq updated hcup fast stats include state-level emergency department (ed) visit trends payer— effect of health insurance expansion on emergency department visits. these ed statistics supplement existing state-level inpatient stay trends payer part of effect of health insurance expansion on hospital use topic. quarterly ed visit counts presented 2006-2014 27 states in given year, including 26 states 2014 data.

hcup fast stats continue updated regularly (quarterly or annually, newer data become available) timely, topic-specific national , state-level statistics.

quality indicators (qis)

the ahrq quality indicators (qis) measures of health care quality make use of readily-available hospital inpatient administrative data. ahrq qis can used highlight potential quality concerns, identify areas need further study , investigation, , track changes on time.

the ahrq qis consist of 4 modules measuring various aspects of quality:

prevention qis identify hospital admissions evidence suggests have been avoided, @ least in part, through high-quality outpatient care.
inpatient qis reflect quality of care inside hospitals including inpatient mortality medical conditions , surgical procedures.
patient safety indicators reflect quality of care inside hospitals, focus on potentially avoidable complications , iatrogenic events.
pediatric qis both reflect quality of care inside hospitals , identify potentially avoidable hospitalizations among children.

clinical classifications software (ccs)

the clinical classifications software (ccs) provides method classifying diagnoses or procedures clinically meaningful categories, can used aggregate statistical reporting of variety of topics, such identifying populations disease- or procedure-specific studies, or developing statistical reports providing information (i.e., charges , length of stay) relatively specific conditions.

there 4 versions of ccs software: ccs icd-10-cm/pcs, ccs icd-9-cm, ccs reporting mortality, , ccs services , procedures.

clinical classifications software (ccs) icd-10-cm/pcs based on international classification of diseases, 10th revision, clinical modification (icd-10-cm), uniform , standardized coding system. ccs icd-10-cm/pcs provides method classifying icd-10-cm/pcs diagnoses or procedures clinically meaningful categories, can used aggregate statistical reporting of variety of topics , employed in many types of projects analyzing data on diagnoses , procedures. based on ccs icd-9-cm , attempts map icd-10-cm/pcs codes same categories.

the icd-10-cm/pcs s multitude of codes—currently on 69,800 diagnosis codes , 71,900 procedure codes—are collapsed smaller number of clinically meaningful categories. current ccs icd-10-cm/pcs version has 285 mutually exclusive categories diagnoses , 231 procedures. research interests, smaller number can more useful presenting descriptive statistics individual icd-10-cm/pcs codes. every effort made translate ccs system icd-10-cm/pcs without making changes ccs assignments diagnoses , procedures, because of new structure , expanded code availability not possible. because of increased specificity of icd-10-cm/pcs , changes in 2 code set structure, not possible translate multilevel categories icd-10-cm/pcs within current structure – exception of first- , second-level multilevel categories.

the ccs icd-10-cm/pcs updated annually starting october 1, 2015.

clinical classifications software (ccs) icd-9-cm based on international classification of diseases, 9th revision, clinical modification (icd-9-cm), uniform , standardized coding system. ccs icd-9-cm provides method classifying icd-9-cm diagnoses or procedures clinically meaningful categories, can used aggregate statistical reporting of variety of topics , employed in many types of projects analyzing data on diagnoses , procedures.

since fiscal year 2008, ccs icd-9-cm includes categories mental health , substance abuse clinical classifications software (ccs-mhsa). these categories replace original ccs categories mental health , substance abuse. specifically, ccs single-level software includes ccs-mhsa general categories, , ccs multi-level software includes ccs-mhsa specific categories.

the ccs icd-9-cm updated annually starting january 1980 through september 30, 2015. icd-9-cm codes frozen in preparation icd-10-cm implementation , regular maintenance of codes has been suspended.

clinical classifications software (ccs) mortality reporting based on international classification of diseases, 10th revision (icd-10), uniform , standardized coding system has been used in u.s. mortality reporting since 1999. fiscal year 2006 version of ccs mortality reporting valid through september 2009.
clinical classifications software (ccs) services , procedures provides users method of classifying current procedural terminology (cpt®) codes , healthcare common procedure coding system (hcpcs) codes 244 clinically meaningful procedure categories. more 9,000 cpt/hcpcs codes , 6,000 hcpcs codes accounted for.

the ccs versions , user guides available download hcup-us website.

chronic condition indicator

the chronic condition indicator provides researchers way facilitate health services research on diagnoses using administrative data. there 2 versions of cci software, cci icd-9-cm , cci icd-10-cm. cci tool provides users easy way categorize icd-9-cm/icd-10-cm diagnoses codes 2 categories: chronic or not chronic. currently, there approximately 14,000 diagnosis codes in version icd-9-cm , 68,000 diagnosis codes in version icd-10-cm. chronic condition defined condition lasts 12 months or longer , meets 1 or both of following tests: (a) places limitations on self-care, independent living, , social interactions; , (b) results in need ongoing intervention medical products, services, , special equipment. identification of chronic conditions based on 5-digit icd-9-cm or 7-digit icd-10-cm codes. e codes, or external cause of injury codes, not classified, because injuries assumed acute.

the tool assigns diagnosis codes 1 of 18 body system categories, allowing users create indicators listing specific body systems affected chronic condition. body system indicator based on chapters of icd-9-cm/icd-10-cm codebooks. indicator may useful means of counting number of body systems affected chronic conditions. alternatively, clinical classification software (ccs) may used in conjunction chronic condition indicator in order obtain count of number of relatively discrete chronic conditions.

the icd-9-cm chronic condition indicator updated annually , valid codes january 1, 1980 through september 20, 2015. icd-9-cm codes frozen in preparation icd-10-cm implementation , regular maintenance of codes has been suspended. icd-10-cm chronic condition indicator updated annually , valid codes october 1, 2015 forward. indicators may downloaded hcup central distributor.

elixhauser comorbidity software

elixhauser comorbidity software assigns variables identify coexisting conditions on hospital discharge records may contribute patient’s death using icd-9-cm diagnosis coding.

the elixhauser comorbidity software consists of 2 computer programs. first, creation of format library elixhauser comorbidity groups, generates format library maps diagnosis codes comorbidity indicators. additional formats created exclude conditions may complications or may related principal diagnosis. second program, creation of elixhauser comorbidity variables, applies these formats data set containing administrative data.

the elixhauser comorbidity software updated annually , available download on hcup-us website.

procedure classes

procedure classes facilitate research on hospital services using administrative data identifying whether icd-9-cm procedure (a) diagnostic or therapeutic, , (b) minor or major in terms of invasiveness and/or resource use. there 2 types of procedure classes tools, procedure classes icd-9-cm , procedure classes icd-10-cm.

the procedure classes provide users easy way categorize procedure codes 1 of 4 broad categories: minor diagnostic, minor therapeutic, major diagnostic, , major therapeutic.

minor diagnostic: non-operating room procedures diagnostic (e.g., 87.03: ct scan of head)
minor therapeutic: non-operating room procedures therapeutic (e.g., 02.41: irrigate ventricular shunt)
major diagnostic: procedures considered valid operating room procedures diagnosis related group (drg) grouper , performed diagnostic reasons (e.g., 01.14: open brain biopsy)
major therapeutic: procedures considered valid operating room procedures diagnosis related group (drg) grouper , performed therapeutic reasons (e.g., 39.24: aorta-renal bypass).

the procedure classes icd-9-cm updated annually january 1, 1980 through september 30, 2015. icd-9-cm codes frozen in preparation icd-10 implementation , regular maintenance of codes has been suspended. procedure classes icd-10-cm updated annually , valid codes october 1, 2015 forward. procedure classes available download hcup-us website.

utilization flags

utilization flags reveal additional information use of health care services combining information ub-92 revenue codes , icd-9-cm procedure codes create flags—or indicators—of utilization more complete picture of services rendered in hospitals, emergency departments, , ambulatory surgery centers.

the utilization flags can employed study issues such use of intensive care units, reliably examine utilization of diagnostic , therapeutic services—beyond information can gleaned icd-9-cm procedure codes alone.

the utilization flags updated annually , available download hcup-us website.

surgery flags

surgery flags identify surgical procedures , encounters in icd-9-cm or cpt-based inpatient , ambulatory surgery data. 2 types of surgical categories identified: narrow surgery based on narrow, targeted, , restrictive definition , includes invasive surgical procedures. broad surgery includes procedures fall under narrow category adds less invasive therapeutic , diagnostic procedures may performed in surgical settings. users must agree license use surgery flags before accessing software. (updated codes valid through 2015.)