Inpatient Quality Indicators

Owned by Joseph Gulotta
Last updated: Dec 19, 2014 by Alex Laird (Unlicensed)
The following measures belong to the group that falls into AHRQ's Inpatient Quality Indicator category. The Inpatient Quality Indicators (IQIs) are a set of measures that provide a perspective on hospital quality of care using hospital administrative data. These indicators reflect quality of care inside hospitals and include inpatient mortality for certain procedures and medical conditions; utilization of procedures for which there are questions of overuse, underuse, and misuse; and volume of procedures for which there is some evidence that a higher volume of procedures is associated with lower mortality.
.

The IQIs can be used to help hospitals identify potential problem areas that might need further study; provide the opportunity to assess quality of care inside the hospital using administrative data found in the typical discharge record; include mortality indicators for conditions or procedures for which mortality can vary from hospital to hospital; include utilization indicators for procedures for which utilization varies across hospitals or geographic areas; and, include volume indicators for procedures for which outcomes may be related to the volume of those procedures performed.

 

SQL to acquire these measures is as follows:
.

Acquiring data on All IQI 

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 = 21
.
This includes observed, risk-adjusted, and observed to expected measures.
measure_idauthor_measure_idname_friendly
10060IQI 16Risk-adjusted Mortality Rate: Congestive heart failure
10061IQI 17Risk-adjusted Mortality Rate: Stroke
10062IQI 19Risk-adjusted Mortality Rate: Hip Fracture
10063IQI 20Risk-adjusted Mortality Rate: Pneumonia
10064IQI 08Mortality Rate: Esophageal resection
10065IQI 09Mortality Rate: Pancreatic Resection
10066IQI 11Mortality Rate: Abdominal Aortic Aneurysm Repair
10067IQI 24Incidental Appendectomy in the Elderly
10068IQI 25Bi-Lateral Cardiac Catheterization
10069IQI 01Volume of Procedures: Esophageal Resection
10070IQI 02Volume of Procedures: Pancreatic Resection
10071IQI 04Volume of Procedures: Abdominal Aortic Aneurysm Repair
10187IQI 05Bypass Surgery Volume
10188IQI 06Angioplasty Volume
10189IQI 07Carotid endarterectomy volume
10190IQI 12Inpatient bypass graft deaths
10191IQI 13Inpatient craniotomy deaths
10192IQI 15Risk-adjusted Mortality Rate: Inpatient Heart Attack Deaths
10193IQI 21Cesarean Section Delivery
10194IQI 22Uncomplicated Vaginal Births After Cesarean
10195IQI 23Laparoscopic Cholecystectomy (minimally-invasive gallbladder removal)
10196IQI 32Mortality Rate: Heart Attack Deaths, Not Including Transfers
10197IQI 34Total Vaginal Births After Cesarean
10209IQI 18Risk-adjusted Mortality Rate: Gastrointestinal Hemorrhage
10210IQI 30PTCA Mortality Rate
10211IQI 33Primary Cesarean Delivery Rate
10214IQI 31CEA Mortality Rate
10217IQI 14Mortality Rate: Hip Replacement
10757IQI 16Observed Mortality Rate: Congestive heart failure
10758IQI 17Observed Mortality Rate: Stroke
10759IQI 19Observed Mortality Rate: Hip Fracture
10760IQI 20Observed Mortality Rate: Pneumonia
10763IQI 15Observed Mortality Rate: Inpatient Heart Attack Deaths
10842IQI 26Coronary artery disease: coronary artery bypass graft (CABG) area rate
10843IQI 27Coronary artery disease: percutaneous transluminal coronary angioplasty area rate
10844IQI 28Hysterectomy: hysterectomy area rate
10845IQI 29Laminectomy or spinal fusion: laminectomy or spinal fusion area rate
10857IQI 90Mortality for Selected Procedures Composite
10858IQI 91Mortality for Selected Conditions Composite
16755oIQI 02AVolume of Procedures: Pancreatic Resection Stratum A
16756oIQI 02BVolume of Procedures: Pancreatic Resection Stratum B
16757oIQI 04aVolume of Procedures: Abdominal Aortic Aneurysm Repair Stratum A
16758oIQI 04bVolume of Procedures: Abdominal Aortic Aneurysm Repair Stratum B
16759oIQI 04cVolume of Procedures: Abdominal Aortic Aneurysm Repair Stratum C
16760oIQI 04dVolume of Procedures: Abdominal Aortic Aneurysm Repair Stratum D
16761OE:IQI 08Observed to Expected Ratio: Esophageal Resection Mortality Rate
16762OE:IQI 09Observed to Expected Ratio: Pancreatic Resection Mortality Rate
16763OE:IQI 09aObserved to Expected Ratio: Pancreatic Resection Mortality Rate Stratum A
16764OE:IQI 09bObserved to Expected Ratio: Resection Mortality Rate Stratum B
16765OE:IQI 11Observed to Expected Ratio: Abdominal Aortic Aneurysm (AAA) Repair Mortality Rate
16766OE:IQI 11aObserved to Expected Ratio: Abdominal Aortic Aneurysm (AAA) Repair Mortality Rate Stratum A
16767OE:IQI 11bObserved to Expected Ratio: Abdominal Aortic Aneurysm (AAA) Repair Mortality Rate Stratum B
16768OE:IQI 11cObserved to Expected Ratio: Abdominal Aortic Aneurysm (AAA) Repair Mortality Rate Stratum C
16769OE:IQI 11dObserved to Expected Ratio: Abdominal Aortic Aneurysm (AAA) Repair Mortality Rate Stratum D
16770OE:IQI 12Observed to Expected Ratio: Coronary Artery Bypass Graft (CABG) Mortality Rate
16771OE:IQI 13Observed to Expected Ratio: Craniotomy Mortality Rate
16772OE:IQI 14Observed to Expected Ratio: Hip Replacement Mortality Rate
16773OE:IQI 15Acute Myocardial Infarction (AMI) Mortality Rate
16774OE:IQI 16Heart Failure Mortality Rate
16775OE:IQI 17Acute Stroke Mortality Rate
16776OE:IQI 17aObserved to Expected Ratio: Acute Stroke Mortality Rate Stratum A
16777OE:IQI 17bObserved to Expected Ratio: Acute Stroke Mortality Rate Stratum B
16778OE:IQI 17cObserved to Expected Ratio: Acute Stroke Mortality Rate Stratum C
16779OE:IQI 18Gastrointestinal Hemorrhage Mortality Rate
16780OE:IQI 19Hip Fracture Mortality Rate
16781OE:IQI 20Pneumonia Mortality Rate
16782oIQI 08Observed Mortality Rate: Esophageal Resection
16783oIQI 09Observed Mortality Rate: Pancreatic Resection
16784oIQI 09aObserved Mortality Rate: Pancreatic Resection Stratum A
16785oIQI 09bObserved Mortality Rate: Pancreatic Resection Stratum B
16786oIQI 11Observed Mortality Rate: Abdominal Aortic Aneurysm (AAA) Repair
16787oIQI 11aObserved Mortality Rate: Abdominal Aortic Aneurysm (AAA) Repair Stratum A
16788oIQI 11bObserved Mortality Rate: Abdominal Aortic Aneurysm (AAA) Repair Stratum B
16789oIQI 11cObserved Mortality Rate: Abdominal Aortic Aneurysm (AAA) Repair Stratum C
16790oIQI 11dObserved Mortality Rate: Abdominal Aortic Aneurysm (AAA) Repair Stratum D
16791oIQI 12Observed Mortality Rate: Coronary Artery Bypass Graft (CABG)
16792oIQI 13Observed Mortality Rate: Craniotomy
16793oIQI 14Observed Mortality Rate: Hip Replacement
16794oIQI 17aObserved Mortality Rate: Acute Stroke Mortality Rate Stratum A
16795oIQI 17bObserved Mortality Rate: Acute Stroke Mortality Rate Stratum B
16796oIQI 17cObserved Mortality Rate: Acute Stroke Mortality Rate Stratum C
16797oIQI 18Observed Mortality Rate: Gastrointestinal Hemorrhage
16798oIQI 26Observed Coronary Artery Bypass Graft (CABG) Rate - Area Level
16799oIQI 27Observed Percutaneous Coronary Intervention (PCI) Rate - Area Level
16800oIQI 28Observed Hysterectomy Rate - Area Level
16801oIQI 29Observed Laminectomy or Spinal Fusion Rate - Area Level
16802oIQI 30Observed Mortality Rate: Percutaneous Coronary Intervention (PCI)
16803oIQI 31Observed Mortality Rate: Carotid Endarterectomy
16804oIQI 32Observed Acute Myocardial Infarction (AMI) Mortality Rate, Without Transfer Cases
16805oeIQI 26Observed to Expected Coronary Artery Bypass Graft (CABG) Rate - Area Level
16806oeIQI 27Observed to Expected Percutaneous Coronary Intervention (PCI) Rate - Area Level
16807oeIQI 28Observed to Expected Hysterectomy Rate - Area Level
16808oeIQI 29Observed to Expected Laminectomy or Spinal Fusion Rate - Area Level
16809oeIQI 30Percutaneous Coronary Intervention (PCI) Mortality Rate
16810oeIQI 31Carotid Endarterectomy Mortality Rate
16811oeIQI 32Observed to Expected Acute Myocardial Infarction (AMI) Mortality Rate, Without Transfer Cases
16812raIQI 09aMortality Rate: Pancreatic Resection Stratum A
16813raIQI 09bMortality Rate: Pancreatic Resection Stratum B
16814raIQI 11aMortality Rate: Abdominal Aortic Aneurysm Repair Stratum A
16815raIQI 11bMortality Rate: Abdominal Aortic Aneurysm Repair Stratum B
16816raIQI 11cMortality Rate: Abdominal Aortic Aneurysm Repair Stratum C
16817raIQI 11dMortality Rate: Abdominal Aortic Aneurysm Repair Stratum D
16818raIQI 17aRisk-adjusted Mortality Rate: Stroke Stratum A
16819raIQI 17bRisk-adjusted Mortality Rate: Stroke Stratum B
16820raIQI 17cRisk-adjusted Mortality Rate: Stroke Stratum C

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.