Lab 2.2 – HCUPnet Exercises
Use HCUPnet (https://hcupnet.ahrq.gov) to answer the following questions:
- Use the KID database to find out what proportion of discharges 2009 with a principal diagnosis of asthma is covered under Medicaid?
- Should you use ICD-9-CM diagnosis codes, Clinical Classification Software (CCS) category or DRG to identify asthma? Hint: How many ICD-9-CM diagnosis codes are needed to select all asthma discharges? Is there an asthma-specific DRG? What is the CCS?
- Why?
- Proportion:
- Use the NIS database to determine the most common discharge destination for Medicare patients undergoing a hip replacement (DRG 470) in 2011.
- Is there a different pattern of discharge destination for uninsured patients?
- Why?
- What is the top DRG for patients that are dually eligible (Medicare and Medicaid) in Texas for 2011?
- Is the same for all payers?
- What do you notice about the top 10 DRGs for dually eligible patients vs. the top 10 for all patients?
[Hint: If you ask for the Top 10 DRGs by number of discharges for dually eligible patients, the system will return a table for all payers and one for dually eligible.]
- Use the KID database to determine the trend in discharges for asthma. Include the proportion admitted through the ED.
- What is the trend in the number of discharges?
- What is the trend in the proportion admitted through the ED?
[Hint: Select the ‘percent admitted from the emergency department’ and ‘number of discharges’ after selecting the CCS for asthma.]
- Use the NIS database to compare the median cost and length of stay for patients discharged from teaching hospitals to that of patients admitted to nonteaching hospitals for 2012.
- Are they different?
- Why or why not?
[Hint: Be sure to select the number of discharges, length of stay (median) and hospital charges (median) when on screen used for selecting variables to be displayed.]