Versions Compared

Version Old Version 3 New Version 4
Changes made by

Alex Laird (Unlicensed)

Alex Laird (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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_idauthor_measure_idname_friendly
10701PQI 02Perforated Appendix
10702PQI 07Hypertension Admissions
10704PQI 14Uncontrolled Diabetes Admissions10705PQI 15Adult Asthma Admissions (LEGACY)
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
10714PQI 05Chronic Obstructive Pulmonary Disease Admissions (LEGACY)
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
10737PQI oPQI 02Observed Perforated Appendix
10738PQI oPQI 07Observed Hypertension Admissions
10739PQI oPQI 09Observed Low Birth Weight
10740PQI oPQI 14Observed Uncontrolled Diabetes Admissions
10741PQI oPQI 15Observed Adult Asthma Admissions
10742PQI oPQI 10Observed Dehydration Admissions
10743PQI oPQI 11Observed Bacterial Pneumonia Admissions
10744PQI oPQI 12Observed Urinary Tract Infection Admissions
10745PQI oPQI 13Observed Angina Admissions
10746PQI oPQI 16Observed Lower Extremity Amputations
10747PQI oPQI 01Observed Diabetes Short-term Complications Admissions
10748PQI oPQI 08Observed Congestive Heart Failure Admissions
10749PQI oPQI 03Observed Diabetes Long-term Complications Admissions
10750PQI oPQI 05Observed Chronic Obstructive Pulmonary Disease Admissions
10751PQI oPQI 90Observed Overall Preventative Care
10752PQI oPQI 91Observed Overall Acute Preventative Care
10753PQI oPQI 92Observed Overall Chronic Preventative Care
10754PQI oPQI 93Observed Overall Diabetes Preventative Care
10755PQI oPQI 94Observed Overall Circulatory Preventative Care
10756PQI oPQI 95Observed Overall Respiratory Preventative Care
10779PQI 90 ADMHospital admissions for ambulatory care sensitive conditions per 100,000
10992PQI raPQI 09Risk Adjusted Low Birth Weight
12120IOM_PQI_8_CMSCMS Prevention Quality Indicator (PQI) 8: Hospital admissions for congestive heart failure (CHF) in Medicare beneficiaries ages 65-74 per 100,000 beneficiaries
12121IOM_PQI_15_CMSCMS Prevention Quality Indicator (PQI) 15: Hospital admissions for adult asthma for Medicare beneficiaries ages 65-74 per 100,000 beneficiaries
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
12249PQI 15Asthma in Younger Adults Admissions
12250PQI 0512239prev_hosp_COPD_wCOPD or Asthma in Older Adults - White
12240prev_hosp_COPD_bCOPD or Asthma in Older Adults - Black
12367MCO_PQI15PQI #15 Asthma in Younger Adults Admission Rate
12368MCO_PQI15PQI #01 Diabetes Short-Term Copmplications Admissions rate12241prev_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