The following measures belong to the group that falls into AHRQ's Prevention Quality Indicator category. This includes observed, risk-adjusted, and observed to expected measures.
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
.
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.
| measure_id | author_measure_id | name_friendly |
|---|---|---|
| 10701 | PQI 02 | Perforated Appendix |
| 10702 | PQI 07 | Hypertension Admissions |
| 10704 | PQI 14 | Uncontrolled Diabetes Admissions |
| 10705 | PQI 15 | Adult Asthma Admissions (LEGACY) |
| 10706 | PQI 10 | Dehydration Admissions |
| 10707 | PQI 11 | Bacterial Pneumonia Admissions |
| 10708 | PQI 12 | Urinary Tract Infection Admissions |
| 10709 | PQI 13 | Angina Admissions |
| 10710 | PQI 16 | Lower Extremity Amputations |
| 10711 | PQI 01 | Diabetes Short-term Complications Admissions |
| 10712 | PQI 08 | Congestive Heart Failure Admissions |
| 10713 | PQI 03 | Diabetes Long-term Complications Admissions |
| 10714 | PQI 05 | Chronic Obstructive Pulmonary Disease Admissions (LEGACY) |
| 10731 | PQI 90 | Overall Preventive Care |
| 10732 | PQI 91 | Overall Acute Preventive Care |
| 10733 | PQI 92 | Overall Chronic Preventive Care |
| 10734 | PQI 93 | Overall Diabetes Preventive Care |
| 10735 | PQI 94 | Overall Circulatory Preventive Care |
| 10736 | PQI 95 | Overall Respiratory Preventive Care |
| 10737 | PQI 02 | Observed Perforated Appendix |
| 10738 | PQI 07 | Observed Hypertension Admissions |
| 10739 | PQI 09 | Observed Low Birth Weight |
| 10740 | PQI 14 | Observed Uncontrolled Diabetes Admissions |
| 10741 | PQI 15 | Observed Adult Asthma Admissions |
| 10742 | PQI 10 | Observed Dehydration Admissions |
| 10743 | PQI 11 | Observed Bacterial Pneumonia Admissions |
| 10744 | PQI 12 | Observed Urinary Tract Infection Admissions |
| 10745 | PQI 13 | Observed Angina Admissions |
| 10746 | PQI 16 | Observed Lower Extremity Amputations |
| 10747 | PQI 01 | Observed Diabetes Short-term Complications Admissions |
| 10748 | PQI 08 | Observed Congestive Heart Failure Admissions |
| 10749 | PQI 03 | Observed Diabetes Long-term Complications Admissions |
| 10750 | PQI 05 | Observed Chronic Obstructive Pulmonary Disease Admissions |
| 10751 | PQI 90 | Observed Overall Preventative Care |
| 10752 | PQI 91 | Observed Overall Acute Preventative Care |
| 10753 | PQI 92 | Observed Overall Chronic Preventative Care |
| 10754 | PQI 93 | Observed Overall Diabetes Preventative Care |
| 10755 | PQI 94 | Observed Overall Circulatory Preventative Care |
| 10756 | PQI 95 | Observed Overall Respiratory Preventative Care |
| 10779 | PQI 90 ADM | Hospital admissions for ambulatory care sensitive conditions per 100,000 |
| 10992 | PQI 09 | Risk Adjusted Low Birth Weight |
| 12120 | IOM_PQI_8_CMS | CMS Prevention Quality Indicator (PQI) 8: Hospital admissions for congestive heart failure (CHF) in Medicare beneficiaries ages 65-74 per 100,000 beneficiaries |
| 12121 | IOM_PQI_15_CMS | CMS Prevention Quality Indicator (PQI) 15: Hospital admissions for adult asthma for Medicare beneficiaries ages 65-74 per 100,000 beneficiaries |
| 12196 | OE:PQI 02 | Observed to Expected Ratio: Perforated Appendix |
| 12197 | OE:PQI 07 | Observed to Expected Ratio: Hypertension Admissions |
| 12198 | OE:PQI 14 | Observed to Expected Ratio: Uncontrolled Diabetes Admissions |
| 12199 | OE:PQI 15 | Observed to Expected Ratio: Adult Asthma Admissions |
| 12200 | OE:PQI 10 | Observed to Expected Ratio: Dehydration Admissions |
| 12201 | OE:PQI 11 | Observed to Expected Ratio: Bacterial Pneumonia Admissions |
| 12202 | OE:PQI 12 | Observed to Expected Ratio: Urinary Tract Infection Admissions |
| 12203 | OE:PQI 13 | Observed to Expected Ratio: Angina Admissions |
| 12204 | OE:PQI 16 | Observed to Expected Ratio: Lower Extremity Amputations |
| 12205 | OE:PQI 01 | Observed to Expected Ratio: Diabetes Short-term Complications Admissions |
| 12206 | OE:PQI 08 | Observed to Expected Ratio: Congestive Heart Failure Admissions |
| 12207 | OE:PQI 03 | Observed to Expected Ratio: Diabetes Long-term Complications Admissions |
| 12208 | OE:PQI 05 | Observed to Expected Ratio: Chronic Obstructive Pulmonary Disease Admissions |
| 12249 | PQI 15 | Asthma in Younger Adults Admissions |
| 12250 | PQI 05 | COPD or Asthma in Older Adults |
| 12367 | MCO_PQI15 | PQI #15 Asthma in Younger Adults Admission Rate |
| 12368 | MCO_PQI15 | PQI #01 Diabetes Short-Term Copmplications Admissions rate |
| 16855 | oPQI 05 | Observed COPD or Asthma in Older Adults |
| 16856 | oePQI 05 | Observed to Expected COPD or Asthma in Older Adults |
| 16857 | oePQI 09 | Observed to Expected Low Birth Weight |
| 16858 | oPQI 15 | Observed Asthma in Younger Adults Admissions |
| 16859 | oePQI 15 | Observed to Expected Asthma in Younger Adults Admissions |
| 16860 | oePQI 90 | Observed to Expected Overall Preventive Care |
| 16861 | oePQI 91 | Observed to Expected Overall Acute Preventive Care |
| 16862 | oePQI 92 | Observed to Expected Overall Chronic Preventive Care |