Prevention Quality Indicators

Owned by Joseph Gulotta
Last updated: Jul 28, 2015
The following measures belong to the group that falls into AHRQ's Prevention Quality Indicator category. The Prevention Quality Indicators (PQIs) are a set of measures that can be used with hospital inpatient discharge data to identify quality of care for "ambulatory care sensitive conditions." These are conditions for which good outpatient care can potentially prevent the need for hospitalization or for which early intervention can prevent complications or more severe disease. The PQIs are population based and adjusted for covariates.
.

Even though these indicators are based on hospital inpatient data, they provide insight into the community health care system or services outside the hospital setting. For example, patients with diabetes may be hospitalized for diabetic complications if their conditions are not adequately monitored or if they do not receive the patient education needed for appropriate self-management.

The PQIs can be used as a "screening tool" to help flag potential health care quality problem areas that need further investigation; provide a quick check on primary care access or outpatient services in a community by using patient data found in a typical hospital discharge abstract; and, help public health agencies, State data organizations, health care systems, and others interested in improving health care quality in their communities.

 

SQL to acquire these measures is as follows:
.

Acquiring data on All PQI 

select a.measure_id, a.author_measure_id, a.name_friendly
from measures as a, measure_groups_measures as b
where a.measure_id = b.measure_id 
and b.measure_group_id = 23
.
This includes observed, risk-adjusted, and observed to expected measures.
measure_idauthor_measure_idname_friendly
10701PQI 02Perforated Appendix
10702PQI 07Hypertension Admissions
10704PQI 14Uncontrolled Diabetes Admissions
10706PQI 10Dehydration Admissions
10707PQI 11Bacterial Pneumonia Admissions
10708PQI 12Urinary Tract Infection Admissions
10709PQI 13Angina Admissions
10710PQI 16Lower Extremity Amputations
10711PQI 01Diabetes Short-term Complications Admissions
10712PQI 08Congestive Heart Failure Admissions
10713PQI 03Diabetes Long-term Complications Admissions
10731PQI 90Overall Preventive Care
10732PQI 91Overall Acute Preventive Care
10733PQI 92Overall Chronic Preventive Care
10734PQI 93Overall Diabetes Preventive Care
10735PQI 94Overall Circulatory Preventive Care
10736PQI 95Overall Respiratory Preventive Care
10737oPQI 02Observed Perforated Appendix
10738oPQI 07Observed Hypertension Admissions
10739oPQI 09Observed Low Birth Weight
10740oPQI 14Observed Uncontrolled Diabetes Admissions
10741oPQI 15Observed Adult Asthma Admissions
10742oPQI 10Observed Dehydration Admissions
10743oPQI 11Observed Bacterial Pneumonia Admissions
10744oPQI 12Observed Urinary Tract Infection Admissions
10745oPQI 13Observed Angina Admissions
10746oPQI 16Observed Lower Extremity Amputations
10747oPQI 01Observed Diabetes Short-term Complications Admissions
10748oPQI 08Observed Congestive Heart Failure Admissions
10749oPQI 03Observed Diabetes Long-term Complications Admissions
10750oPQI 05Observed Chronic Obstructive Pulmonary Disease Admissions
10751oPQI 90Observed Overall Preventative Care
10752oPQI 91Observed Overall Acute Preventative Care
10753oPQI 92Observed Overall Chronic Preventative Care
10754oPQI 93Observed Overall Diabetes Preventative Care
10755oPQI 94Observed Overall Circulatory Preventative Care
10756oPQI 95Observed Overall Respiratory Preventative Care
10779PQI 90 ADMHospital admissions for ambulatory care sensitive conditions per 100,000
10992raPQI 09Risk Adjusted Low Birth Weight
12162prev_hosp_asth_wAsthma in Younger Adults - White
12163prev_hosp_asth_bAsthma in Younger Adults - Black
12164prev_hosp_asth_hAsthma in Younger Adults - Hispanic
12165prev_hosp_asth_oPreventable Hospitalizations for Asthma in Younger Adults: Other
12166prev_hosp_uncdia_wUncontrolled Diabetes - White
12167prev_hosp_uncdia_bUncontrolled Diabetes - Black
12168prev_hosp_uncdia_hUncontrolled Diabetes - Hispanic
12169prev_hosp_uncdia_oPreventable Hospitalizations for Uncontrolled Diabetes: Other
12170prev_hosp_stdia_wShort Term Complications of Diabetes - White
12171prev_hosp_stdia_bShort Term Complications of Diabetes - Black
12172prev_hosp_stdia_hShort Term Complications of Diabetes - Hispanic
12173prev_hosp_stdia_oPreventable Hospitalizations for Short Term (ST) Complications of Diabetes: Other
12174prev_hosp_ledia_wLower Extremity Amputations - White
12175prev_hosp_ledia_bLower Extremity Amputations - Black
12176prev_hosp_ledia_hLower Extremity Amputations - Hispanic
12177prev_hosp_ledia_oPreventable Hospitalizations for Diabetes (DM) Lower Extremity (LE) Amputations: Other
12178prev_hosp_ltdia_wLong Term Complications of Diabetes - White
12179prev_hosp_ltdia_bLong Term Complications of Diabetes - Black
12180prev_hosp_ltdia_hLong Term Complications of Diabetes - Hispanic
12181prev_hosp_ltdia_oPreventable Hospitalizations for Long Term (LT) Complications of Diabetes: Other
12196OE:PQI 02Observed to Expected Ratio: Perforated Appendix
12197OE:PQI 07Observed to Expected Ratio: Hypertension Admissions
12198OE:PQI 14Observed to Expected Ratio: Uncontrolled Diabetes Admissions
12199OE:PQI 15Observed to Expected Ratio: Adult Asthma Admissions
12200OE:PQI 10Observed to Expected Ratio: Dehydration Admissions
12201OE:PQI 11Observed to Expected Ratio: Bacterial Pneumonia Admissions
12202OE:PQI 12Observed to Expected Ratio: Urinary Tract Infection Admissions
12203OE:PQI 13Observed to Expected Ratio: Angina Admissions
12204OE:PQI 16Observed to Expected Ratio: Lower Extremity Amputations
12205OE:PQI 01Observed to Expected Ratio: Diabetes Short-term Complications Admissions
12206OE:PQI 08Observed to Expected Ratio: Congestive Heart Failure Admissions
12207OE:PQI 03Observed to Expected Ratio: Diabetes Long-term Complications Admissions
12208OE:PQI 05Observed to Expected Ratio: Chronic Obstructive Pulmonary Disease Admissions
12239prev_hosp_COPD_wCOPD or Asthma in Older Adults - White
12240prev_hosp_COPD_bCOPD or Asthma in Older Adults - Black
12241prev_hosp_COPD_hCOPD or Asthma in Older Adults - Hispanic
12242prev_hosp_COPD_oPreventable Hospitalizations for Chronic Obstructive Pulmonary Disease or Asthma in Older Adults: Other
12249PQI 15Asthma in Younger Adults Admissions
12250PQI 05COPD or Asthma in Older Adults
16855oPQI 05Observed COPD or Asthma in Older Adults
16856oePQI 05Observed to Expected COPD or Asthma in Older Adults
16857oePQI 09Observed to Expected Low Birth Weight
16858oPQI 15Observed Asthma in Younger Adults Admissions
16859oePQI 15Observed to Expected Asthma in Younger Adults Admissions
16860oePQI 90Observed to Expected Overall Preventive Care
16861oePQI 91Observed to Expected Overall Acute Preventive Care
16862oePQI 92Observed to Expected Overall Chronic Preventive Care
17132oprev_hosp_asth_wObserved Asthma in Younger Adults - White
17133oprev_hosp_asth_bObserved Asthma in Younger Adults - Black
17134oprev_hosp_asth_hObserved Asthma in Younger Adults - Hispanic
17135oprev_hosp_uncdia_wObserved Uncontrolled Diabetes - White
17136oprev_hosp_uncdia_bObserved Uncontrolled Diabetes - Black
17137oprev_hosp_uncdia_hObserved Uncontrolled Diabetes - Hispanic
17138oprev_hosp_stdia_wObserved Short Term Complications of Diabetes - White
17139oprev_hosp_stdia_bObserved Short Term Complications of Diabetes - Black
17140oprev_hosp_stdia_hObserved Short Term Complications of Diabetes - Hispanic
17141oprev_hosp_ledia_wObserved Lower Extremity Amputations - White
17142oprev_hosp_ledia_bObserved Lower Extremity Amputations - Black
17143oprev_hosp_ledia_hObserved Lower Extremity Amputations - Hispanic
17144oprev_hosp_ltdia_wObserved Long Term Complications of Diabetes - White
17145oprev_hosp_ltdia_bObserved Long Term Complications of Diabetes - Black
17146oprev_hosp_ltdia_hObserved Long Term Complications of Diabetes - Hispanic
17147oprev_hosp_COPD_wObserved COPD or Asthma in Older Adults - White
17148oprev_hosp_COPD_bObserved COPD or Asthma in Older Adults - Black
17149oprev_hosp_COPD_hObserved COPD or Asthma in Older Adults - Hispanic

Statistical significance is calculated using a 95% confidence interval on a standard z-test for state-wide values and populated in the sig_var_state field of pellucid2.entity_values.