Dimensional Warehouse Model Data Model

Entity

Entity AHRQ - Inpatient Quality Indicators

Description

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.

Attributes
Calendar Dk
Encounter Dk
IQI 01 Esophageal Resection Volume
IQI 02 Pancreatic Resection Volume
IQI 04 Abdominal Aortic Aneurysm Repair Volume
IQI 05 Coronary Artery Bypass Graft Volume
IQI 06 Percutaneous Coronary Intervention Volume
IQI 07 Carotid Endarterectomy Volume
IQI 08 Esophageal Resection Mortality Rate
IQI 09 Pancreatic Resection Mortality Rate
IQI 11 Abdominal Aortic Aneurysm Repair Mortality Rate
IQI 12 Coronary Artery Bypass Graft Mortality Rate
IQI 13 Craniotomy Mortality Rate
IQI 14 Hip Replacement Mortality Rate
IQI 15 Acute Myocardial Infarction Mortality Rate
IQI 16 Heart Failure Mortality Rate
IQI 17 Acute Stroke Mortality Rate
IQI 18 Gastrointestinal Hemorrhage Mortality Rate
IQI 19 Hip Fracture Mortality Rate
IQI 20 Pneumonia Mortality Rate
IQI 21 Uncomplicated Cesarean Delivery Rate
IQI 22 Vaginal Birth After Cesarean Rate Uncomplicated
IQI 23 Laparoscopic Cholecystectomy Rate
IQI 24 Incidental Appendectomy In The Elderly Rate
IQI 25 Bilateral Cardiac Catheterization Rate
IQI 26 Coronary Artery Bypass Graft Rate
IQI 27 Percutaneous Coronary Intervention Rate
IQI 28 Hysterectomy Rate
IQI 29 Laminectomy Or Spinal Fusion Rate
IQI 30 Percutaneous Coronary Intervention Mortality Rate
IQI 31 Carotid Endarterectomy Mortality Rate
IQI 32 AMI Mortality Rate Without Transfer Cases
IQI 33 Primary Cesarean Delivery Rate
IQI 34 Vaginal Birth After Cesarean Rate All
IQI 90 Mortality For Selected Procedures
IQI 91 Mortality For Selected Conditions
Patient Dk
Point Of Care Location Dk
Practitioner Dk
Procedure Code Dk
Provider Dk

Relationship
AHRQ - Inpatient Quality Indicators_Encounter Dimension_FK
AHRQ - Inpatient Quality Indicators_Patient Dimension_FK
AHRQ - Inpatient Quality Indicators_Practitioner Dimension_FK
AHRQ - Inpatient Quality Indicators_Procedure Dimension_FK
AHRQ - Inpatient Quality Indicators_Point Of Care Location Dimension_FK
AHRQ - Inpatient Quality Indicators_Calendar Dimension_FK
AHRQ - Inpatient Quality Indicators_Provider Dimension_FK

Primary Key
AHRQ - Inpatient Quality Indicators PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Calendar Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Encounter Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

IQI 01 Esophageal Resection Volume

Description	The number of hospital discharges with a procedure for espohageal resection or gastrectomy and esophageal cancer for patients 18 years and older or obstetric patients. Numerator: Discharges, for patients ages 18 years and older or MDC 14 (pregnancy, childbirth, and puerperium), with either: • any-listed ICD-9-CM procedure codes for esophageal resection; or • any-listed ICD-9-CM procedure codes for gastrectomy and any-listed ICD-9-CM diagnosis codes for esophageal cancer. Denominator: N/A Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 02 Pancreatic Resection Volume

Description	The number of hospital discharges with a procedure of partial or total pancreatic resection for patients 18 years and older or obstetric patients. Excludes acute pancreatitis admissions. Numerator: Discharges, for patients ages 18 years and older or MDC 14 (pregnancy, childbirth, and puerperium), with any-listed ICD-9-CM procedure codes for partial pancreatic resection or any-listed ICD-9-CM procedure codes for total pancreatic resection. Denominator: N/A Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 04 Abdominal Aortic Aneurysm Repair Volume

Description	The number of hospital discharges with a procedure for abdominal aortic aneurysm (AAA) repair for patients 18 years and older or obstetric patients. Includes metrics for the number of discharges grouped by diagnosis and procedure type. Numerator: Discharges, for patients ages 18 years and older or MDC 14 (pregnancy, childbirth, and puerperium), with either • any-listed ICD-9-CM diagnosis codes for un-ruptured AAA and any-listed ICD-9-CM procedure code for open AAA repair; or • any-listed ICD-9-CM diagnosis codes for ruptured AAA and any-listed ICD-9-CM procedure codes for open AAA repair; or • any-listed ICD-9-CM diagnosis codes for un-ruptured AAA and any-listed ICD-9-CM procedure codes for endovascular AAA repair; or • any-listed ICD-9-CM diagnosis codes for ruptured AAA and any-listed ICD-9-CM procedure codes for endovascular AAA repair Denominator: N/A Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 05 Coronary Artery Bypass Graft Volume

Description	The number of hospital discharges with a procedure for coronary artery bypass graft (CABG) for patients 18 years and older or obstetric patients. Numerator: Discharges, for patients ages 18 years and older or MDC 14 (pregnancy, childbirth, and puerperium), with any-listed ICD-9-CM procedure codes for CABG. Denominator: N/A Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 06 Percutaneous Coronary Intervention Volume

Description	The number of hospital discharges with a procedure for percutaneous coronary intervention (PCI) for patients 18 years and older or obstetric patients. Numerator: Discharges, for patients ages 18 years and older or MDC 14 (pregnancy, childbirth, and puerperium), with any-listed ICD-9-CM procedure codes for PCI. Denominator: N/A Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 07 Carotid Endarterectomy Volume

Description	The number of hospital discharges with a procedure for carotid endarterectomy for patients 18 years and older or obstetric patients. Numerator: Discharges, for patients ages 18 years and older or MDC 14 (pregnancy, childbirth, and puerperium), with any-listed ICD-9-CM procedure codes for carotid endarterectomy. Denominator: N/A Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 08 Esophageal Resection Mortality Rate

Description	In-hospital deaths per 1,000 discharges with esophageal resection for cancer, ages 18 years and older. Excludes obstetric discharges and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 18 years and older, with either • any-listed ICD-9-CM procedure codes for esophageal resection and any-listed ICD-9-CM diagnosis codes for esophageal cancer; or • any-listed ICD-9-CM procedure codes for esophageal resection and any-listed ICD-9-CM diagnosis codes for gastrointestinal-related cancer; or • any-listed ICD-9-CM procedure codes for total gastrectomy and any-listed ICD-9-CM diagnosis codes for esophageal cancer Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 09 Pancreatic Resection Mortality Rate

Description	In-hospital deaths per 1,000 discharges with pancreatic resection, ages 18 years and older. Includes metrics for discharges grouped by type of diagnosis and procedure. Excludes acute pancreatitis discharges, obstetric discharges, and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 18 years and older, with any-listed ICD-9-CM procedure codes for partial pancreatic resection or any-listed ICD-9-CM procedure codes for total pancreatic resection Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 11 Abdominal Aortic Aneurysm Repair Mortality Rate

Description	In-hospital deaths per 1,000 discharges with abdominal aortic aneurysm (AAA) repair, ages 18 years and older. Includes metrics for discharges grouped by type of diagnosis and procedure. Excludes obstetric discharges and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 18 years and older, with the following • any-listed ICD-9-CM diagnosis codes for un-ruptured AAA and any-listed ICD-9-CM procedure code for open AAA repair; or • any-listed ICD-9-CM diagnosis codes for ruptured AAA and any-listed ICD-9-CM procedure codes for open AAA repair; or • any-listed ICD-9-CM diagnosis codes for un-ruptured AAA and any-listed ICD-9-CM procedure codes for endovascular AAA repair; or • any-listed ICD-9-CM diagnosis codes for ruptured AAA and any-listed ICD-9-CM procedure codes for endovascular AAA repair Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 12 Coronary Artery Bypass Graft Mortality Rate

Description	In-hospital deaths per 1,000 discharges with coronary artery bypass graft (CABG), ages 40 years and older. Excludes obstetric discharges and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 40 years and older, with any-listed ICD-9-CM procedure code for CABG. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 13 Craniotomy Mortality Rate

Description	In-hospital deaths per 1,000 discharges with craniotomy, ages 18 years and older. Excludes patients with a principal diagnosis of head trauma, obstetric discharges, and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 18 years or older, with a DRG or MS-DRG code for craniotomy. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 14 Hip Replacement Mortality Rate

Description	In-hospital deaths per 1,000 pelvic and thigh osteoarthrosis discharges with partial or full hip replacement, ages 18 years and older. Excludes hip fracture discharges, obstetric discharges, and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 18 years and older, with any-listed ICD-9-CM procedure codes for a partial or full hip replacement and any-listed ICD-9-CM diagnosis codes for osteoarthrosis for pelvic region and thigh (or site unspecified or multiple sites). Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 15 Acute Myocardial Infarction Mortality Rate

Description	In-hospital deaths per 1,000 hospital discharges with acute myocardial infarction (AMI) as a principal diagnosis for patients ages 18 years and older. Excludes obstetric discharges and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for AMI. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 16 Heart Failure Mortality Rate

Description	In-hospital deaths per 1,000 hospital discharges with heart failure as a principal diagnosis for patients ages 18 years and older. Excludes obstetric discharges and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for heart failure. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 17 Acute Stroke Mortality Rate

Description	In-hospital deaths per 1,000 hospital discharges with acute stroke as a principal diagnosis for patients ages 18 years and older. Includes metrics for discharges grouped by type of stroke. Excludes obstetric discharges and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for subarachnoid stroke or a principal ICD-9-CM diagnosis code for hemorrhagic stroke or a principal ICD-9-CM diagnosis code for ischemic stroke. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 18 Gastrointestinal Hemorrhage Mortality Rate

Description	In-hospital deaths per 1,000 hospital discharges with gastrointestinal hemorrhage as a principal diagnosis for patients age 18 years and older. Excludes obstetric discharges and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for gastrointestinal hemorrhage. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 19 Hip Fracture Mortality Rate

Description	In-hospital deaths per 1,000 hospital discharges with hip fracture as a principal diagnosis for patients ages 65 years and older. Excludes periprosthetic fracture discharges, obstetric discharges, and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 65 years and older, with a principal ICD-9-CM diagnosis code for hip fracture. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 20 Pneumonia Mortality Rate

Description	In-hospital deaths per 1,000 hospital discharges with pneumonia as a principal diagnosis for patients ages 18 years and older. Excludes obstetric discharges and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for pneumonia. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 21 Uncomplicated Cesarean Delivery Rate

Description	Cesarean deliveries without a hysterotomy procedure per 1,000 deliveries. Excludes deliveries with complications (abnormal presentation, preterm delivery, fetal death, multiple gestation diagnoses, or breech procedure). Numerator: Number of Cesarean deliveries among cases meeting the inclusion and exclusion rules for the denominator. Cesarean deliveries are identified by either • DRG or MS-DRG codes for Cesarean delivery; or • any-listed ICD-9-CM procedure codes for Cesarean delivery without any-listed ICD-9-CM procedure codes for hysterotomy. Denominator: All deliveries, identified by DRG or MS-DRG code. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 22 Vaginal Birth After Cesarean Rate Uncomplicated

Description	Vaginal births per 1,000 deliveries by patients with previous Cesarean deliveries. Excludes deliveries with complications (abnormal presentation, preterm delivery, fetal death, multiple gestation diagnoses, or breech procedure). Numerator: Number of vaginal deliveries, identified by DRG or MS-DRG code, among cases meeting the inclusion and exclusion rules for the denominator. Denominator: All deliveries, identified by DRG or MS-DRG code, with any-listed ICD-9-CM diagnosis codes for previous Cesarean delivery. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 23 Laparoscopic Cholecystectomy Rate

Description	Laparoscopic cholecystectomy discharges per 1,000 cholecystectomy discharges for patients with cholecystitis and/or cholelithiasis ages 18 years and older. Excludes obstetric discharges. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with any-listed ICD-9-CM procedure codes for laparoscopic cholecystectomy. Denominator: Discharges, for patients ages 18 years and older, with any-listed ICD-9-CM procedure codes for cholecystectomy and any-listed ICD-9-CM diagnosis codes for uncomplicated cholecystitis and/or cholelithiasis. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 24 Incidental Appendectomy In The Elderly Rate

Description	Incidental appendectomy discharges per 1,000 hospital discharges with abdominal or pelvic surgery for patients ages 65 years and older. Excludes surgical removal of the colon (colectomy) or pelvic evisceration discharges, appendiceal cancer discharges, and obstetric discharges. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with any-listed ICD-9-CM procedure codes for incidental appendectomy. Denominator: Discharges, for patients ages 65 years and older, with any-listed ICD-9-CM procedure codes for abdominal and pelvic surgery. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 25 Bilateral Cardiac Catheterization Rate

Description	Bilateral cardiac catheterization discharges per 1,000 heart catheterizations discharges for coronary artery disease for patients ages 18 years and older. Excludes valid indications for right-side catheterization discharges and obstetric discharges. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with any-listed ICD-9-CM procedure codes for right and left heart catheterization without any-listed ICD-9-CM diagnosis codes for indications for right-sided catheterization. Denominator: Discharges, for patients ages 18 years and older, with any-listed ICD-9-CM procedure codes for heart catheterization and any-listed ICD-9-CM diagnosis codes for coronary artery disease. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 26 Coronary Artery Bypass Graft Rate

Description	Coronary artery bypass graft (CABG) discharges per 100,000 population, ages 40 years and older. Excludes obstetric discharges. Numerator: Discharges, for patients ages 40 and older, with any-listed ICD-9-CM procedure codes for CABG. Denominator: Population ages 40 years and older in metropolitan area† or county. Discharges in the numerator are assigned to the denominator based on the metropolitan area or county of patient residence, not the metropolitan area or county of the hospital where the discharge occurred. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 27 Percutaneous Coronary Intervention Rate

Description	Percutaneous coronary intervention (PCI) discharges per 100,000 population, ages 40 years and older. Excludes obstetric discharges. Numerator: Discharges, for patients ages 40 years and older, with any-listed ICD-9-CM procedure codes for PCI. Denominator: Population ages 40 years and older in metropolitan area† or county. Discharges in the numerator are assigned to the denominator based on the metropolitan area or county of the patient residence, not the metropolitan area or county of the hospital where the discharge occurred. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 28 Hysterectomy Rate

Description	Hysterectomy discharges per 100,000 female population, ages 18 and older. Excludes genital cancer discharges, pelvic or lower-abdominal trauma discharges, and obstetric discharges. Numerator: Female discharges, for patients ages 18 years and older, with any-listed ICD-9-CM procedure codes for hysterectomy. Denominator: Female population ages 18 years and older in metropolitan area or county. Discharges in the numerator are assigned to the denominator based on the metropolitan area or county of the patient residence, not the metropolitan area or county of the hospital where the discharge occurred. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 29 Laminectomy Or Spinal Fusion Rate

Description	Laminectomies or spinal fusion discharges per 100,000 population, ages 18 years and older. Excludes obstetric discharges. Numerator: Discharges, for patients ages 18 years and older, with any-listed ICD-9-CM procedure codes for laminectomy or spinal fusion. Denominator: Population ages 18 years and older in metropolitan area or county. Discharges in the numerator are assigned to the denominator based on the metropolitan area or county of the patient residence, not the metropolitan area or county of the hospital where the discharge occurred. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 30 Percutaneous Coronary Intervention Mortality Rate

Description	In-hospital deaths per 1,000 percutaneous coronary intervention (PCI) discharges for patients 40 years and older. Excludes obstetric discharges and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 40 years and older, with any-listed ICD-9-CM procedure codes for PCI. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 31 Carotid Endarterectomy Mortality Rate

Description	In-hospital deaths per 1,000 carotid endarterectomy (CEA) discharges for patients ages 18 years and older. Excludes obstetric discharges and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 18 years and older, with any-listed ICD-9-CM procedure codes for carotid endarterectomy. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 32 AMI Mortality Rate Without Transfer Cases

Description	In-hospital deaths per 1,000 hospital discharges with acute myocardial infarction (AMI) as a principal diagnosis for patients ages 18 years and older. Excludes obstetric discharges, transfers to another hospital, and transfers in from another acute care hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for AMI. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 33 Primary Cesarean Delivery Rate

Description	First-time Cesarean deliveries without a hysterotomy procedure per 1,000 deliveries. Excludes deliveries with complications (abnormal presentation, preterm delivery, fetal death, multiple gestation diagnoses, or breech procedure). Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with either: • DRG or MS-DRG codes for Cesarean delivery; or • any-listed ICD-9-CM procedure codes for Cesarean delivery without any-listed ICD-9-CM procedure codes for hysterotomy Denominator: All deliveries, identified by DRG or MS-DRG code. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 34 Vaginal Birth After Cesarean Rate All

Description	Vaginal Birth After Cesarean (VBAC) Rate, All Vaginal births per 1,000 deliveries by patients with previous Cesarean deliveries. Numerator: Number of vaginal deliveries, identified by DRG or MS-DRG code, among cases meeting the inclusion and exclusion rules for the denominator. Denominator: All deliveries, identified by DRG or MS-DRG code, with any-listed ICD-9-CM diagnosis codes for previous Cesarean delivery. Note: The procedure or diagnosis codes are continuously updated. See the latest measure descriptions published by AHRQ for the list of ICD-9-CM codes as well as notes about specific cases to exclude from the measure calculations.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 90 Mortality For Selected Procedures

Description	The weighted average of the observed-to-expected ratios for the following component indicators: • IQI #8 Esophageal Resection Mortality Rate • IQI #9 Pancreatic Resection Mortality Rate • IQI #11 Abdominal Aortic Aneurism (AAA) Repair Mortality Rate • IQI #12 Coronary Artery Bypass Graft (CABG) Mortality Rate • IQI #13 Craniotomy Mortality Rate • IQI #14 Hip Replacement Mortality Rate • IQI #30 Percutaneous Coronary Intervention (PCI) Mortality Rate • IQI #31 Carotid Endarterectomy Mortality Rate The weights include component weights and shrinkage weights. The component weights are denominator weights, defined as the relative frequency of the denominators for the component indicators in the reference population. The shrinkage weights are the signal-to-noise ratio, where the signal variance is estimated from the reference population, and the noise variance is estimated from the user’s data and is unique to each provider in the user’s data.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

IQI 91 Mortality For Selected Conditions

Description	The weighted average of the observed-to-expected ratios for the following component indicators: • IQI #15 Acute Myocardial Infarction (AMI) Mortality Rate • IQI #16 Heart Failure Mortality Rate • IQI #17 Acute Stroke Mortality Rate • IQI #18 Gastrointestinal Hemorrhage Mortality Rate • IQI #19 Hip Fracture Mortality Rate • IQI #20 Pneumonia Mortality Rate The weights include component weights and shrinkage weights. The component weights are denominator weights, defined as the relative frequency of the denominators for the component indicators in the reference population. The shrinkage weights are the signal-to-noise ratio, where the signal variance is estimated from the reference population, and the noise variance is estimated from the user’s data and is unique to each provider in the user’s data.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Point Of Care Location Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Practitioner Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Procedure Code Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Provider Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Relationship Details

AHRQ - Inpatient Quality Indicators_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Inpatient Quality Indicators
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Encounter Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

AHRQ - Inpatient Quality Indicators_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Inpatient Quality Indicators
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Patient Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

AHRQ - Inpatient Quality Indicators_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Inpatient Quality Indicators
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

AHRQ - Inpatient Quality Indicators_Procedure Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Inpatient Quality Indicators
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Procedure Code Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

AHRQ - Inpatient Quality Indicators_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Inpatient Quality Indicators
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Point Of Care Location Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

AHRQ - Inpatient Quality Indicators_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Inpatient Quality Indicators
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Calendar Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

AHRQ - Inpatient Quality Indicators_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Inpatient Quality Indicators
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Provider Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

AHRQ - Inpatient Quality Indicators PK

Key Attribute	Encounter Dk
Key Attribute	Patient Dk
Key Attribute	Practitioner Dk
Key Attribute	Procedure Code Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Calendar Dk
Key Attribute	Provider Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model