About the Tools | Past Workshop Agendas and Materials | Upcoming Technical Assistance


Healthcare Cost and Utilization Project (HCUP)
Healthcare Data and Tools. And an Overview of HCUPnet
Anne Elixhauser, Ph.D.
State Healthcare Quality Improvement Workshop
December 7, 2007- Philadelphia, PA

On the top of the slide are the logos for the Department of Health & Human Services and the AHRQ logo. The Department of Health & Human Services logo is an artistic image of an eagle with the outlined profile of faces. The AHRQ logo reads, "AHRQ - Agency for Healthcare Research and Quality: Advancing Excellence in Health Care, www.ahrq.gov".

Slide 1

The HCUP Partnership: A Voluntary Federal-State-Private Sector Collaboration

This presentation uses a template with a blue background and a header with the AHRQ and Department of Health & Human Services logos on the left and the HCUP logo on the right. The header and body of the slide are separated by two horizontal lines, one light blue line and one dark blue.

The body of the slide shows a map of the United States. States are color coded according their HCUP partnership status.

•  Hawaii, Washington, Oregon, California, Nevada, Utah, Arizona, Colorado, Texas, Oklahoma, Kansas, Nebraska, South Dakota, Minnesota, Iowa, Missouri, Arkansas, Tennessee, Kentucky, Indiana, Illinois, Wisconsin, Ohio, Michigan, West Virginia, Florida, Georgia, South Carolina, North Carolina, Virginia, Maryland, Delaware, New Jersey, New York, Connecticut, Rhode Island, Massachusetts, New Hampshire, and Vermont are HCUP Partners

•  New Mexico is not an HCUP partner due to a legal barrier

•  Alabama, Mississippi, Idaho, Montana, and Wyoming do not collect inpatient data

•  Alaska, Louisiana, Pennsylvania, North Dakota, Maine, and the District of Columbia are not HCUP partners

The box below the map contains the following text: 38 states in partnership and 90% of all discharges.

Slide 2

The Foundation of HCUP is Billing Data

On the left is a graphic of a UB-92 (UB-04) Billing Form

To the right of form is a bracket with the following text:

Patient demographics (age, sex)

Diagnoses & procedures

(ICD-9-CM, DRG)

Expected payer

Length of stay

Patient disposition

Admission source & type

Admission month

Charges

Slide 3

The Making of HCUP Data

A white arrow starting in the upper left quadrant of the slide circles the slide and ends in the lower left quadrant. The arrows follow pictures and graphics of Patient enters hospital, Billing record created, Hospital sends billing data and any additional data elements to data organizations, and ends with States store data in varying formats. The arrow points to the HCUP logo with "AHRQ standardizes data to create uniform HCUP databases" underneath.

Slide 4

What is HCUP? And what is not?

There are two columns in the table.

The left column entitled "What it is" lists: Claims (bills)for health care encounters; All payer; including the uninsured, Hospital; ambulatory surgery; emergency department data; All claims; Accessible multiple ways: raw data, regular reports, on-line

The right column entitled "What it is not" lists: A survey; Specific to a single payer, e.g. Medicare; Outpatient visits, pharmacy, laboratory; A sample; Just another database

Slide 5

HCUP is a Family of Databases, Tools, Products

From the HCUP logo in the upper left quadrant, arrows point to graphics of HCUP Databases, Software Tools, HCUPnet, Research Publications, and User Support.

Slide 6

Types of HCUP Databases

Superimposed on top of a map of the United States are three boxes with an identical graphic of a disk underneath the text. From right to left, the boxes are labeled: State Emergency Department Databases (SEDD), State Ambulatory Surgery Databases (SASD), and State Inpatient Databases (SID). Two red arrows from the State Inpatient Databases box point to two more disks underneath the box which are labeled Nationwide Inpatient Sample (NIS) and Kids' Inpatient Database (KID).

Slide 7

HCUP Supports High Impact Health Services, Policy, and Clinical Research

The following logos appear on this slide: HSR, American Journal of Public Health, The New England Journal of Medicine, Cancer, Health Affairs, JAMA, Annals of Surgery, Journal of General Internal Medicine, Pediatrics, Health Economics, The National Academies, PharmacoEconomics, Newsweek, The Lancet, International Journal of Health Care Finance & Economics, The Journal of Rural Health, Inquiry, Morbidity and Mortality Weekly Report, National Healthcare Disparities Report, and Obstetrics & Gynecology.

Slide 8

HCUP Supports Federal and Non-Federal Initiatives

The following logos appear on this slide: U.S. Office of Management and Budget, FDA, The Commonwealth Fund, Allies Against Asthma, HSRA, NIAID, Utah Department of Health, CDC, Injury Control Research Center, NASA, SAMHSA, National Institutes of Health, National Oceanic and Atmospheric Administration, U.S. Government Accountability Office, Suicide Prevention Resource Center, American Urological Association, Medpac, CMS, March of Dimes, and Institute of Medicine.

Slide 9

Supports Policy Deliberations and Legislation

HCUP was used to determine national and state burden of hospital care following motorcycle injuries

Analyses used in West Virginia 's hearings to remove their motorcycle-helmet law

To the right of the text are graphics of a motorcycle and a helmet.

Slide 10

AHRQ Quality Indicators

•  Most widely used HCUP tool

•  Used for reporting hospital quality of care

•  AHRQ provides benchmarks against which to compare your numbers

To the left of the text are images of AHRQ Guide to Prevention Quality Indicators, AHRQ Guide to Patient Safety Indicators, AHRQ Guide to Inpatient Quality Indicators, and a Pediatric Quality Indicators Fact Sheet.

Slide 11

HCUP Fact Books

This slide shows cover images of HCUP Fact Book 5, HCUP Fact book 8, and HCUP fact book 10.

Slide 12

HCUP Statistical Briefs

The image on the left is of HCUP Statistical Brief #36. The image on the right is a bar graph labeled Figure 1. Trends of total hospital stays for potentially preventable conditions, 1997-2004.

Slide 13

Other Statistical Briefs Include:

•  Hospital stays related to depression

•  Trends in risk-adjusted mortality

•  Trends in preventable hospitalizations

•  Infections with MRSA in U.S. hospitals

•  Childbirth-related stays in U.S. hospitals

•  Adverse drug events

•  Admissions for traumatic brain injury

•  Bariatric surgery utilization and outcomes

•  The national hospital bill

•  .

Slide 14

Facts and Figures

The image on the left is a bar graph entitled Discharge Prevalence for All-listed Diabetes by Median Income of Patients' Zip Code, 2005. The image on the right is the cover of HCUP Facts and Figures: Statistics on Hospital-Based Care in the United States, 2005.

Slide 15

HCUPnet: Quick, Free Access to HCUP Data

•  Free, interactive online query system

•  Users generate tables of outcomes by diagnoses and procedures

•  Data can be cross-classified by patient and hospital characteristics

http://hcupnet.ahrq.gov

Slide 16

Welcome to HCUPnet

This slide is a screen shot of the HCUPnet home page: http://hcupnet.ahrq.gov/.

Superimposed on the screenshot are two yellow boxes. The upper right box contains the following text: HCUPnet is a powerful online query tool that gives you free, instant access to healthcare statistics. The other dialogue box points to the National Statistics on All Stays section of the screenshot and says: HCUPnet provides national information on hospital stays based on the Nationwide Inpatient Sample.

Slide 17

Select State and Year:

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box on the lower right has the following text: .and it gives access to data from participating states from HCUP's State Inpatient Databases.

Slide 18

Select the type of query you want:

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box in the lower right reads: HCUPnet takes you through a step-by-step process to select the information you want.

Slide 19

Do you want information on:

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box in the lower right has the following text: You select the level of diagnosis and procedure information: ICD codes, Clinical Classifications, DRGS.

Slide 20

Select outcomes and measures for which you want statistics

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box in the lower right has the following text:

HCUPnet provides information on:

•  numbers of discharges

•  hospital LOS and charges

•  discharge status

•  how patients were admitted

Slide 21

Select patient and hospital characteristics

This slide is a screen shot of the HCUPnet online database. The text in the yellow dialogue box in the middle on the right says: Are you interested in particular patient groups? Specific hospital characteristics?

Slide 22

State statistics - 2005 New York - principal procedure only

This slide is a data table that contains data for principal procedure performed in New York State in 2005.

The yellow dialogue box in the lower right hand has the following text: You get your results instantly. HCUPnet is based on aggregated statistics to speed data transfer and protect patient confidentiality.

Slide 23

State Statistics - New York - all-listed

This slide is a line graph entitled Total number of discharges CCS all-listed procedure category 158, Spinal Fusion. The x-axis is labeled with consecutive years from 1997 until 2005. The y-axis is labeled with the total number of discharges in 2,000 increments from zero until 18,000. The points along the line from left to right are: 8,701 in 1997, 10,306 in 1998, 10,827 in 1999, 12,000 in 2000, 12,968 in 2001, 13,793 in 2002, 15,342 in 2003, 16,195 in 2004, and 16,808 in 2005. The bottom of the page has a table with corresponding values of the points on the graph.

Superimposed on the line graph is a yellow dialogue box pointing to the line graph with the following text: You can request information on trends for the nation and for any participating state.

Slide 24

Repeat this query on another database

This slide is a screen shot of the HCUPnet online database. The text in the yellow dialogue box says: You can repeat your query instantly on another database.

Slide 25

Results

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box contains the following text: HCUPnet also provides information on ED visits for some states.

Slide 26

Indicator Selection

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box on the lower right contains the following text: . and on national-level information on quality of care, based on the AHRQ Quality Indicators.

Slide 27

Welcome to HCUPnet

This slide is a screen shot of the HCUPnet online database. The yellow dialogue box points to Welcome to HCUPnet and contains the following text: Visit HCUPnet at: http://hcupnet.ahrq.gov

Slide 28

What types of questions can HCUPnet answer?

•  What are the most common conditions treated in hospitals in my state?

•  What are the most expensive conditions? procedures?

•  How many CABGs were performed in 2003?

•  What percentage of hospitalizations are uninsured ?

•  For what conditions are uninsured patients hospitalized? patients covered by Medicaid ?

•  What is the trend in hospitalizations for MRSA?

•  What is the cost of C-section versus vaginal deliveries?

•  What types of hospitals treat what kinds of patients?

•  What types of patients are seen in the emergency department and then admitted to the hospital?

Slide 29

For more information

•  General Technical Assistance-HCUP User Support

  • Phone: 1-866-290-HCUP (4287)

•  Anne Elixhauser-

Back to Top