Dimensional Warehouse Model Data Model

Entity

Entity AHRQ - Prevention Quality Indicators

Description

The Prevention Quality Indicators (PQIs) are a set of measures that can be used with hospital inpatient discharge data to identify quality of care for "ambulatory care sensitive conditions." These are conditions for which good outpatient care can potentially prevent the need for hospitalization or for which early intervention can prevent complications or more severe disease. The PQIs are population based and adjusted for covariates.

The PQIs can be used as a "screening tool" to help flag potential health care quality problem areas that need further investigation; provide a quick check on primary care access or outpatient services in a community by using patient data found in a typical hospital discharge abstract; and, help public health agencies, State data organizations, health care systems, and others interested in improving health care quality in their communities.

Attributes
Calendar Dk
Diagnosis Code Dk
Encounter Dk
Patient Dk
Point Of Care Location Dk
PQI 01 Diabetes Short-Term Complications Admission Rate
PQI 02 Perforated Appendix Admission Rate
PQI 03 Diabetes Long-Term Complications Admission Rate
PQI 05 COPD or Asthma In Older Adults Admission Rate
PQI 07 Hypertension Admission Rate
PQI 08 Heart Failure Admission Rate
PQI 09 Low Birth Weight Rate
PQI 10 Dehydration Admission Rate
PQI 11 Bacterial Pneumonia Admission Rate
PQI 12 Urinary Tract Infection Admission Rate
PQI 13 Angina Without Procedure Admission Rate
PQI 14 Uncontrolled Diabetes Admission Rate
PQI 15 Asthma In Younger Adults Admission Rate
PQI 16 Lower-Extremity Amputation Diabetes Admission Rate
PQI 90 Prevention Quality Overall Composite
PQI 91 Prevention Quality Acute Composite
PQI 92 Prevention Quality Chronic Composite
Practitioner Dk
Provider Dk

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

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

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

PQI 01 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 18 years and older. Excludes obstetric admissions and transfers from other institutions. Numerator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for diabetes short-term complications (ketoacidosis, hyperosmolarity, or coma). Denominator: Population ages 18 years and older in the 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. May be combined with uncontrolled diabetes as a single indicator as a simple sum of the rates to form the Healthy People 2010 indicator (note that the AHRQ QITM excludes transfers to avoid double-counting cases). 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

PQI 02 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 18 years and older. Excludes obstetric admissions and transfers from other institutions. Numerator: Discharges, among cases meeting the inclusion and exclusion rules for the denominator, with any-listed ICD-9-CM diagnosis codes for perforations or abscesses of appendix. Denominator: Discharges, for patients ages 18 years and older, 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

PQI 03 Diabetes Long-Term Complications Admission Rate

Description	Admissions for a principal diagnosis of diabetes with long-term complications (renal, eye, neurological, circulatory, or complications not otherwise specified) per 100,000 population, ages 18 years and older. Excludes obstetric admissions and transfers from other institutions. Numerator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for diabetes with long-term complications (renal, eye, neurological, circulatory, or complications not otherwise specified). 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 where the hospital 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

PQI 05 COPD or Asthma In Older Adults Admission Rate

Description	Admissions with a principal diagnosis of chronic obstructive pulmonary disease (COPD) or asthma per 100,000 population, ages 40 years and older. Excludes obstetric admissions and transfers from other institutions. Numerator: Discharges, for patients ages 40 years and older, with either - a principal ICD-9-CM diagnosis code for COPD (excluding acute bronchitis); or - a principal ICD-9-CM diagnosis code for asthma; or - a principal ICD-9-CM diagnosis code for acute bronchitis and any secondary ICD-9-CM diagnosis codes for COPD (excluding acute bronchitis). 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

PQI 07 Hypertension Admission Rate

Description	Admissions with a principal diagnosis of hypertension per 100,000 population, ages 18 years and older. Excludes kidney disease combined with dialysis access procedure admissions, cardiac procedure admissions, obstetric admissions, and transfers from other institutions. Numerator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for hypertension. 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

PQI 08 Heart Failure Admission Rate

Description	Admissions with a principal diagnosis of heart failure per 100,000 population, ages 18 years and older. Excludes cardiac procedure admissions, obstetric admissions, and transfers from other institutions. Numerator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for heart failure. 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

PQI 09 Low Birth Weight Rate

Description	Low birth weight ( 2,500 grams) infants per 1,000 newborns. Excludes transfers from other institutions. Numerator: Number of newborns, among cases meeting the inclusion and exclusion rules for the denominator, with any-listed ICD-9-CM diagnosis codes for birth weight less than 2,500 grams. Denominator: Number of newborns in metropolitan area or county. Newborns 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

PQI 10 Dehydration Admission Rate

Description	Admissions with a principal diagnosis of dehydration per 100,000 population, ages 18 years and older. Excludes obstetric admissions and transfers from other institutions. Numerator: Discharges, for patients ages 18 years and older, with either - a principal ICD-9-CM diagnosis code for dehydration; or - any secondary ICD-9-CM diagnosis codes for dehydration and a principal ICD-9-CM diagnosis code for hyperosmolality and/or hypernatremia, gastroenteritis, or acute kidney injury 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

PQI 11 Bacterial Pneumonia Admission Rate

Description	Admissions with a principal diagnosis of bacterial pneumonia per 100,000 population, ages 18 years and older. Excludes sickle cell or hemoglobin-S admissions, other indications of immunocompromised state admissions, obstetric admissions, and transfers from other institutions. Numerator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for bacterial pneumonia. 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

PQI 12 Urinary Tract Infection Admission Rate

Description	Admissions with a principal diagnosis of urinary tract infection per 100,000 population, ages 18 years and older. Excludes kidney or urinary tract disorder admissions, other indications of immunocompromised state admissions, obstetric admissions, and transfers from other institutions. Numerator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for urinary tract infection. 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

PQI 13 Angina Without Procedure Admission Rate

Description	Admissions with a principal diagnosis of angina without a cardiac procedure per 100,000 population, ages 18 years and older. Excludes cardiac procedure admissions, obstetric admissions, and transfers from other institutions. Numerator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for angina. 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

PQI 14 Uncontrolled Diabetes Admission Rate

Description	Admissions for a principal diagnosis of diabetes without mention of short-term (ketoacidosis, hyperosmolarity, or coma) or long-term (renal, eye, neurological, circulatory, or other unspecified) complications per 100,000 population, ages 18 years and older. Excludes obstetric admissions and transfers from other institutions. Numerator: Discharges, for patients ages 18 years and older, with a principal ICD-9-CM diagnosis code for uncontrolled diabetes without mention of a short-term or long-term complication. 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. May be combined with diabetes short-term complications as a single indicator as a simple sum of the rates to form the Health People 2010 indicator (note that the AHRQ QITM excludes transfers to avoid double counting cases). 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

PQI 15 Asthma In Younger Adults Admission Rate

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

PQI 16 Lower-Extremity Amputation Diabetes Admission Rate

Description	Admissions for any-listed diagnosis of diabetes and any-listed procedure of lower-extremity amputation per 100,000 population, ages 18 years and older. Excludes any-listed diagnosis of traumatic lower-extremity amputation admissions, toe amputation admission (likely to be traumatic), obstetric admissions, and transfers from other institutions. Numerator: Discharges, for patients ages 18 years and older, with any-listed ICD-9-CM procedure codes for lower-extremity amputation and any-listed ICD-9-CM diagnosis codes for diabetes. 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

PQI 90 Prevention Quality Overall Composite

Description	Prevention Quality Indicators (PQI) overall composite per 100,000 population, ages 18 years and older. Includes admissions for one of the following conditions: diabetes with short-term complications, diabetes with long-term complications, uncontrolled diabetes without complications, diabetes with lower-extremity amputation, chronic obstructive pulmonary disease, asthma, hypertension, heart failure, angina without a cardiac procedure, dehydration, bacterial pneumonia, or urinary tract infection. Numerator: Discharges, for patients ages 18 years and older, that meet the inclusion and exclusion rules for the numerator in any of the following PQIs: - PQI #1 Diabetes Short-Term Complications Admission Rate - PQI #3 Diabetes Long-Term Complications Admission Rate - PQI #5 Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults Admission Rate - PQI #7 Hypertension Admission Rate - PQI #8 Heart Failure Admission Rate - PQI #10 Dehydration Admission Rate - PQI #11 Bacterial Pneumonia Admission Rate - PQI #12 Urinary Tract Infection Admission Rate - PQI #13 Angina Without Procedure Admission Rate - PQI #14 Uncontrolled Diabetes Admission Rate - PQI #15 Asthma in Younger Adults Admission Rate - PQI #16 Lower-Extremity Amputation among Patients with Diabetes Rate Discharges that meet the inclusion and exclusion rules for the numerator in more than one of the above PQIs are counted only once in the composite numerator. 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.
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

PQI 91 Prevention Quality Acute Composite

Description	Prevention Quality Indicators (PQI) composite of acute conditions per 100,000 population, ages 18 years and older. Includes admissions with a principal diagnosis of one of the following conditions: dehydration, bacterial pneumonia, or urinary tract infection. Numerator: Discharges, for patients ages 18 years and older, that meet the inclusion and exclusion rules for the numerator in any of the following PQIs: - PQI #10 Dehydration Admission Rate - PQI #11 Bacterial Pneumonia Admission Rate - PQI #12 Urinary Tract Infection Admission Rate Discharges that meet the inclusion and exclusion rules for the numerator in more than one of the above PQIs are counted only once in the composite numerator. 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.
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

PQI 92 Prevention Quality Chronic Composite

Description	Prevention Quality Indicators (PQI) composite of chronic conditions per 100,000 population, ages 18 years and older. Includes admissions for one of the following conditions: diabetes with short-term complications, diabetes with long-term complications, uncontrolled diabetes without complications, diabetes with lower-extremity amputation, chronic obstructive pulmonary disease, asthma, hypertension, heart failure, or angina without a cardiac procedure. Numerator: Discharges, for patients ages 18 years and older, that meet the inclusion and exclusion rules for the numerator in any of the following PQIs: - PQI #1 Diabetes Short-Term Complications Admission Rate - PQI #3 Diabetes Long-Term Complications Admission Rate - PQI #5 Chronic Obstructive Pulmonary Disease (COPD) or Asthma in Older Adults Admission Rate - PQI #7 Hypertension Admission Rate - PQI #8 Heart Failure Admission Rate - PQI #13 Angina Without Procedure Admission Rate - PQI #14 Uncontrolled Diabetes Admission Rate - PQI #15 Asthma in Younger Adults Admission Rate - PQI #16 Lower-Extremity Amputation among Patients with Diabetes Rate Discharges that meet the inclusion and exclusion rules for the numerator in more than one of the above PQIs are counted only once in the composite numerator. 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.
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

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

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

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

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

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

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

AHRQ - Prevention Quality Indicators_Point Of Care Location Dimension_FK

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

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

Primary Key Details

AHRQ - Prevention Quality Indicators PK

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

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model