Dimensional Warehouse Model Data Model

Entity

Entity AHRQ - Pediatric Quality Indicators

Description

The Pediatric Quality Indicators (PDIs) are a set of measures that can be used with hospital inpatient discharge data to provide a perspective on the quality of pediatric healthcare. Specifically, PDIs screen for problems that pediatric patients experience as a result of exposure to the healthcare system and that may be amenable to prevention by changes at the system or provider level.

Development of quality indicators for the pediatric population involves many of the same challenges associated with the development of quality indicators for the adult population. These challenges include the need to carefully define indicators using administrative data, establish validity and reliability, detect bias and design appropriate risk adjustment, and overcome challenges of implementation and use. However, the special population of children invokes additional, special challenges. Four factors—differential epidemiology of child healthcare relative to adult healthcare, dependency, demographics, and development—can pervade all aspects of children’s healthcare; simply applying adult indicators to younger age ranges is insufficient.

This PDIs focus on potentially preventable complications and iatrogenic events for pediatric patients treated in hospitals, and on preventable hospitalizations among pediatric patients.

The PDIs apply to the special characteristics of the pediatric population; screen for problems that pediatric patients experience as a result of exposure to the healthcare system and that may be amenable to prevention by changes at the provider level or area level; and, help to evaluate preventive care for children in an outpatient setting, and most children are rarely hospitalized.

Attributes
Calendar Dk
Diagnosis Code Dk
Encounter Dk
NQI 01 Neonatal Iatrogenic Pneumothorax Rate
NQI 02 Neonatal Mortality Rate
NQI 03 Neonatal Blood Stream Infection Rate
Patient Dk
PDI 01 Accidental Puncture Or Laceration Rate
PDI 02 Pressure Ulcer Rate
PDI 03 Retained Surgical Item or Unretrieved Device Fragment Count
PDI 05 Iatrogenic Pneumothorax Rate
PDI 06 RACHS-1 Pediatric Heart Surgery Mortality Rate
PDI 07 RACHS-1 Pediatric Heart Surgery Volume
PDI 08 Perioperative Hemorrhage or Hematoma Rate
PDI 09 Postoperative Respiratory Failure Rate
PDI 10 Postoperative Sepsis Rate
PDI 11 Postoperative Wound Dehiscence Rate
PDI 12 CVC Related Blood Stream Infection Rate
PDI 13 Transfusion Reaction Count
PDI 14 Asthma Admission Rate
PDI 15 Diabetes Short-Term Complications Admission Rate
PDI 16 Gastroenteritis Admission Rate
PDI 17 Perforated Appendix Admission Rate
PDI 18 Urinary Tract Infection Admission Rate
PDI 19 Pediatric Safety For Selected Indicators
PDI 90 Pediatric Quality Overall Composite
PDI 91 Pediatric Quality Acute Composite
PDI 92 Pediatric Quality Chronic Composite
Point Of Care Location Dk
Practitioner Dk
Provider Dk

Relationship
AHRQ - Pediatric Quality Indicators_Encounter Dimension_FK
AHRQ - Pediatric Quality Indicators_Patient Dimension_FK
AHRQ - Pediatric Quality Indicators_Practitioner Dimension_FK
AHRQ - Pediatric Quality Indicators_Provider Dimension_FK
AHRQ - Pediatric Quality Indicators_Point Of Care Location Dimension_FK
AHRQ - Pediatric Quality Indicators_Calendar Dimension_FK
AHRQ - Pediatric Quality Indicators_Diagnosis Dimension_FK

Primary Key
AHRQ - Pediatric 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

Diagnosis 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

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

NQI 01 Neonatal Iatrogenic Pneumothorax Rate

Description	Iatrogenic pneumothorax cases (secondary diagnosis) per 1,000 discharges for neonates weighing 500 grams or more but less than 2,500 grams. Excludes normal newborns; cases with chest trauma, pleural effusion, thoracic surgery, lung or pleural biopsy, diphragmatic surgery repair, or cardiac surgery; cases with a principal diagnosis of iatrogenic pneumothorax; and cases with a secondary diagnosis of iatrogenic pneumothorax present on admission. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with any secondary ICD-9-CM diagnosis codes for iatrogenic pneumothorax. Denominator: Surgical and medical discharges, for neonates with birth weight less than 2,500 grams. Surgical and medical discharges are defined by specific DRG or MS-DRG codes. 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

NQI 02 Neonatal Mortality Rate

Description	In-hospital deaths per 1,000 neonates. Excludes newborns weighing less than 500 grams; cases with anencephaly, polysystic kidney, trisomy 13 or trisomy 18; and transfers to another hospital. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: All newborn and outborn discharges. 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

NQI 03 Neonatal Blood Stream Infection Rate

Description	Discharges with healthcare-associated bloodstream infection per 1,000 discharges for newborns and outborns with birth weight of 500 grams or more but less than 1,500 grams; with gestational age between 24 and 30 weeks; or with birth weight of 1,500 grams or more and death, an operating room procedure, mechanical ventilation, or transferring from another hospital within two days of birth. Excludes discharges with a length of stay less than 7 days and discharges with a principal diagnosis of sepsis, sepsis or bacteremia, or newborn bacteremia. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with either: - any secondary ICD-9-CM diagnosis codes for other septicemia; or - any secondary ICD-9-CM diagnosis codes for newborn septicemia or bacteremia and any secondary ICD-9-CM diagnosis codes for staphylococcal or Gram-negative bacterial infection Denominator: All newborns and outborns with either: - a birth weight of 500 to 1,499 grams (Birth Weight Categories 2, 3, 4 and 5); or - any-listed ICD-9-CM diagnosis codes for gestational age between 24 and 30 weeks; or - a birth weight greater than or equal to 1,500 grams (Birth Weight Category 6, 7, 8, or 9) and death (DISP=20); or - a birth weight greater than or equal to 1,500 grams (Birth Weight Category 6, 7, 8, or 9) and any-listed ICD-9-CM procedure codes for operating room procedure; or - a birth weight greater than or equal to 1,500 grams (Birth Weight Category 6, 7, 8, or 9) and any-listed ICD-9-CM procedure codes for mechanical ventilation; or - a birth weight greater than or equal to 1,500 grams (Birth Weight Category 6, 7, 8, or 9) and transferring from another health care facility within two days of birth 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

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

PDI 01 Accidental Puncture Or Laceration Rate

Description	Accidental punctures or lacerations (secondary diagnosis) during procedure per 1,000 discharges for patients ages 17 years and younger. Includes metrics for discharges grouped by risk category. Excludes obstetric discharges, spinal surgery discharges, discharges with accidental puncture or laceration as a principal diagnosis, discharges with accidental puncture or laceration as a secondary diagnosis that is present on admission, normal newborns, and neonates with birth weight less than 500 grams. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with any secondary ICD-9-CM diagnosis codes for accidental puncture or laceration during a procedure. Denominator: Surgical and medical discharges, for patients ages 17 years and younger. Surgical and medical discharges are defined by specific DRG or MS-DRG codes. 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

PDI 02 Pressure Ulcer Rate

Description	Stage III or IV pressure ulcers (secondary diagnosis) per 1,000 discharges among patients ages 17 years and younger. Includes metrics for discharges grouped by risk category. Excludes neonates; stays less than five (5) days; transfers from another facility; obstetric discharges; cases with diseases of the skin, subcutaneous tissue and breast; discharges in which debridement or pedicle graft is the only operating room procedure; discharges with debridement or pedicle graft before or on the same day as the major operating room procedure; and those discharges in which pressure ulcer is the principal diagnosis or secondary diagnosis of Stage III or IV pressure ulcer is present on admission. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with any secondary ICD-9-CM diagnosis codes for pressure ulcer and any secondary ICD-9-CM diagnosis codes for pressure ulcer stage III or IV (or unstageable). Denominator: Surgical and medical discharges, for patients ages 17 years and younger. Surgical and medical discharges are defined by specific DRG or MS-DRG codes. 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

PDI 03 Retained Surgical Item or Unretrieved Device Fragment Count

Description	The number of hospital discharges with a retained surgical item or unretrieved device fragment (secondary diagnosis) among surgical and medical patients ages 17 years and younger. Excludes normal newborns, newborns with birth weight less than 500 grams, cases with principal diagnosis of retained surgical item or unretrieved device fragment, cases with a secondary diagnosis of retained surgical item or unretrieved device fragment present on admission, and obstetric cases. Numerator: Surgical and medical discharges, for patients ages 17 years and under, with any secondary ICD-9-CM diagnosis codes for retained surgical item or unretrieved device fragment. Surgical and medical discharges are defined by specific DRG or MS-DRG codes. 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

PDI 05 Iatrogenic Pneumothorax Rate

Description	Iatrogenic pneumothorax cases (secondary diagnosis) per 1,000 discharges for patients ages 17 years and younger. Excludes normal newborns; neonates with a birth weight less than 2,500 grams; cases with chest trauma, pleural effusion, thoracic surgery, lung or pleural biopsy, diaphragmatic surgery repair or cardiac surgery; cases with a principal diagnosis of iatrogenic pneumothorax; and cases with a secondary diagnosis of iatrogenic pneumothorax present on admission. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with any secondary ICD-9-CM diagnosis codes for iatrogenic pneumothorax. Denominator: Surgical and medical discharges, for patients ages 17 years and younger. Surgical and medical discharges are defined by specific DRG or MS-DRG codes. 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

PDI 06 RACHS-1 Pediatric Heart Surgery Mortality Rate

Description	In-hospital deaths per 1,000 pediatric heart surgery admissions among patients with congenital heart disease ages 17 years and younger. Excludes obstetric discharges; cases with transcatheter interventions as a single cardiac procedure, performed without bypass but with catheterization; cases with septal defect repairs as single cardiac procedures without bypass; cases with heart transplants; premature infants with patent ductus arteriosus (PDA) closure as the only cardiac procedure; age less than 30 days with PDA closure as only cardiac procedure; transfers to another hospital; cases with an unknown disposition; and neonates with birth weight less than 500 grams. Numerator: Number of deaths (DISP=20) among cases meeting the inclusion and exclusion rules for the denominator. Denominator: Discharges, for patients ages 17 years and younger, with either - any-listed ICD-9-CM procedure codes for congenital heart disease (1P); or - any-listed ICD-9-CM procedure codes for non-specific heart surgery (2P) and any-listed ICD-9-CM diagnosis codes for congenital heart disease (2D). 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

PDI 07 RACHS-1 Pediatric Heart Surgery Volume

Description	The number of hospital discharges with a pediatric heart surgery procedure for patients with congenital heart disease ages 17 years and younger. Numerator: Discharges, for patients ages 17 years and younger, with either - any-listed ICD-9-CM procedure codes for congenital heart disease (1P); or - any-listed ICD-9-CM procedure codes for non-specific heart surgery (2P) and any-listed ICD-9-CM diagnosis codes for congenital heart disease (2D). 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

PDI 08 Perioperative Hemorrhage or Hematoma Rate

Description	Perioperative hemorrhage or hematoma cases with control of perioperative hemorrhage, drainage of hematoma, or a miscellaneous hemorrhage- or hematoma-related procedure following surgery per 1,000 surgical discharges for patients ages 17 years and younger. Includes metrics for discharges grouped by high and low risk. Excludes cases with a diagnosis of coagulation disorder; cases with a principal diagnosis of perioperative hemorrhage or hematoma; cases with a secondary diagnosis of perioperative hemorrhage or hematoma present on admission; cases where the only operating room procedure is control of perioperative hemorrhage, drainage of hematoma, or a miscellaneous hemorrhage- or hematoma-related procedure; obstetric cases; and neonates with birth weight less than 500 grams. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator Denominator: Elective surgical discharges, for patients ages 17 years and under, with any-listed ICD-9-CM procedure code for an operating room procedure. Elective surgical discharges are defined by specific DRG or MS-DRG codes with admission type recorded as elective (SID ATYPE=3). 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

PDI 09 Postoperative Respiratory Failure Rate

Description	Postoperative respiratory failure (secondary diagnosis), mechanical ventilation, or reintubation cases per 1,000 elective surgery discharges for patients ages 17 years and younger. Excludes cases in which tracheostomy is the only operating room procedure or in which tracheostomy occurs before the first operating room procedure; cases with neuromuscular disorders, laryngeal or pharyngeal surgery, craniofacial anomalies that had a procedure for the face, esophageal resection, lung cancer, or degenerative neurological disorders; cases with a procedure on the nose, mouth, or pharynx; cases with respiratory or circulatory diseases; neonates with a birth weight less than 500 grams; and obstetric discharges. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator Denominator: Elective surgical discharges, for patients ages 17 years and younger, with any-listed ICD-9-CM procedure codes for an operating room procedure. Elective surgical discharges are defined by specific DRG or MS-DRG codes with admission type recorded as elective (SID ATYPE=3). 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

PDI 10 Postoperative Sepsis Rate

Description	Postoperative sepsis cases (secondary diagnosis) per 1,000 surgery discharges for patients ages 17 years and younger. Includes metrics for discharges grouped by risk category. Excludes cases with a principal diagnosis of sepsis, cases with a secondary diagnosis of sepsis present on admission, cases with a principal diagnosis of infection, cases in which the procedure belongs to surgical class 4, neonates, obstetric discharges, and cases with stays less than four (4) days. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with any secondary ICD-9-CM diagnosis codes for sepsis. Denominator: Surgical discharges, for patients ages 17 years and younger, with any-listed ICD-9-CM procedure codes for an operating room procedure. Surgical discharges are defined by specific DRG or MS-DRG codes. 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

PDI 11 Postoperative Wound Dehiscence Rate

Description	Postoperative reclosures of the abdominal wall per 1,000 abdominopelvic surgery discharges for patients ages 17 years and younger. Includes metrics for discharges grouped by risk category. Excludes cases in which the abdominal wall reclosure occurs on or before the day of the first abdominopelvic surgery, newborn cases with gastroschisis or umbilical hernia repair occurring before the day of the abdominal wall reclosure, cases with a high- or intermediate-risk immunocompromised state, cases with cirrhosis and hepatic failure with a diagnosis of coma or hepatorenal syndrome, cases with transplants, cases with stays less than two (2) days, neonates with birth weight less than 500 grams, and obstetric cases. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with any-listed ICD-9-CM procedure codes for reclosure of postoperative disruption of the abdominal wall. Denominator: Discharges, for patients ages 17 years and younger, with any-listed ICD-9-CM procedure codes for abdominopelvic 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

Description	Central venous catheter-related bloodstream infections (secondary diagnosis) per 1,000 medical and surgical discharges for patients ages 17 years and younger. Includes metrics for discharges grouped by risk category. Excludes cases with a principal diagnosis of a central venous catheter-related bloodstream infection, cases with a secondary diagnosis of a central venous catheter-related bloodstream infection present on admission, normal newborns, neonates with a birth weight of less than 500 grams, cases with stays less than two (2) days, and obstetric cases. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with any secondary ICD-9-CM diagnosis codes for selected infections. Denominator: Surgical and medical discharges, for patients ages 17 years and younger. Surgical and medical discharges are defined by specific DRG or MS-DRG codes. 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

PDI 13 Transfusion Reaction Count

Description	The number of medical and surgical discharges with a secondary diagnosis of transfusion reaction for patients ages 17 years and younger. Excludes cases with a principal diagnosis of transfusion reaction, cases with a secondary diagnosis of transfusion reaction that is present on admission, neonates, and obstetric cases. Numerator: Surgical and medical discharges, for patients ages 17 years and younger, with any secondary ICD-9-CM diagnosis codes for transfusion reaction. Surgical and medical discharges are defined by specific DRG or MS-DRG codes. 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

PDI 14 Asthma Admission Rate

Description	Admissions with a principal diagnosis of asthma per 100,000 population, ages 2 through 17 years. Excludes cases with a diagnosis code for cystic fibrosis and anomalies of the respiratory system, obstetric admissions, and transfers from other institutions. Numerator: Discharges, for patients ages 2 through 17 years, with a principal ICD-9-CM diagnosis code for asthma. Denominator: Population ages 2 through 17 years 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

PDI 15 Diabetes Short-Term Complications Admission Rate

Description	Admissions for a principal diagnosis of diabetes with short-term complications (ketoacidosis, hyperosmolarity, or coma) per 100,000 population, ages 6 through 17 years. Excludes obstetric admissions and transfers from other institutions. Numerator: Discharges, for patients ages 6 through 17 years, with a principal ICD-9-CM diagnosis code for diabetes short-term complications (ketoacidosis, hyperosmolarity, or coma). Denominator: Population ages 6 through 17 years 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

PDI 16 Gastroenteritis Admission Rate

Description	Admissions for a principal diagnosis of gastroenteritis, or for a principal diagnosis of dehydration with a secondary diagnosis of gastroenteritis per 100,000 population, ages 3 months to 17 years. Excludes cases transferred from another facility, cases with gastrointestinal abnormalities or bacterial gastroenteritis, and obstetric admissions. Numerator: Discharges, for patients ages 3 months through 17 years, with either - a principal ICD-9-CM diagnosis code for gastroenteritis; or - any secondary ICD-9-CM diagnosis codes for gastroenteritis and a principal ICD-9-CM diagnosis code for dehydration Denominator: Population ages 3 months through 17 years 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

PDI 17 Perforated Appendix Admission Rate

Description	Admissions for any-listed diagnosis of perforations or abscesses of the appendix per 1,000 admissions with any-listed appendicitis, ages 1 through 17 years. Excludes obstetric admissions and transfers from other institutions. Numerator: Discharges, for patients ages 1 through 17 years, with any-listed ICD-9-CM diagnosis codes for perforations or abscesses of appendix. Denominator: Discharges, for patients ages 1 through 17 years, with any-listed ICD-9-CM diagnosis codes for appendicitis. Discharges 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

PDI 18 Urinary Tract Infection Admission Rate

Description	Admissions with a principal diagnosis of urinary tract infection per 100,000 population, ages 3 months to 17 years. Excludes cases with kidney or urinary tract disorders, cases with a high- or intermediate-risk immunocompromised state, cases with cirrhosis and hepatic failure with a diagnosis of coma or hepatorenal syndrome, cases with transplants, transfers from other institutions, and obstetric admissions. Numerator: Discharges, for patients ages 3 months through 17 years, with a principal ICD-9-CM diagnosis code for urinary tract infection. Denominator: Population ages 3 months through 17 years 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

PDI 19 Pediatric Safety For Selected Indicators

Description	The weighted average of the observed-to-expected ratios for the following component indicators: - PDI #1 Accidental Puncture or Laceration Rate - PDI #2 Pressure Ulcer Rate - PDI #5 Iatrogenic Pneumothorax Rate - PDI #8 Perioperative Hemorrhage or Hematoma Rate - PDI #9 Postoperative Respiratory Failure Rate - PDI #10 Postoperative Sepsis Rate - PDI #11 Postoperative Wound Dehiscence Rate - PDI #12 Central Venous Catheter-Related Blood Stream Infection 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. Numerator: N/A Denominator: N/A
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

PDI 90 Pediatric Quality Overall Composite

Description	Pediatric Quality Indicators (PDI) overall composite per 100,000 population, ages 6 to 17 years. Includes admissions for one of the following conditions: asthma, diabetes with short-term complications, gastroenteritis, or urinary tract infection. Numerator: Discharges, for patients ages 6 to 17 years, that meet the inclusion and exclusion rules for the numerator in any of the following PDIs: - PDI #14 Asthma Admission Rate - PDI #15 Diabetes Short-Term Complications Admission Rate - PDI #16 Gastroenteritis Admission Rate - PDI #18 Urinary Tract Infection Admission Rate Discharges that meet the inclusion and exclusion rules for the numerator in more than one of the above PDIs are counted only once in the composite numerator. Denominator: Population ages 6 to 17 years 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.
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

PDI 91 Pediatric Quality Acute Composite

Description	Pediatric Quality Indicators (PDI) composite of acute conditions per 100,000 population, ages 6 to 17 years. Includes admissions for gastroenteritis or urinary tract infection. Numerator: Discharges, for patients ages 6 to 17 years, that meet the inclusion and exclusion rules for the numerator in any of the following PDIs: - PDI #16 Gastroenteritis Admission Rate - PDI #18 Urinary Tract Infection Admission Rate Discharges that meet the inclusion and exclusion rules for the numerator in more than one of the above PDIs are counted only once in the composite numerator. Denominator: Population ages 6 to 17 years 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.
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

PDI 92 Pediatric Quality Chronic Composite

Description	Pediatric Quality Indicators (PDI) composite of chronic conditions per 100,000 population, ages 6 to 17 years. Includes admissions for asthma or diabetes with short-term complications. Numerator: Discharges, for patients ages 6 to 17 years, that meet the inclusion and exclusion rules for the numerator in any of the following PDIs: - PDI #14 Asthma Admission Rate - PDI #15 Diabetes Short-Term Complications Admission Rate Discharges that meet the inclusion and exclusion rules for the numerator in more than one of the above PDIs are counted only once in the composite numerator. Denominator: Population ages 6 to 17 years 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.
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

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

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 - Pediatric Quality Indicators_Encounter Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Pediatric 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 - Pediatric Quality Indicators_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Pediatric 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 - Pediatric Quality Indicators_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Pediatric 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 - Pediatric Quality Indicators_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Pediatric 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

AHRQ - Pediatric Quality Indicators_Point Of Care Location Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Pediatric 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 - Pediatric Quality Indicators_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Pediatric 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 - Pediatric Quality Indicators_Diagnosis Dimension_FK

Is Identifying Relationship	true
Child Table	AHRQ - Pediatric 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	Diagnosis Code 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 - Pediatric Quality Indicators PK

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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model