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

Browser not supported