Dimensional Warehouse Model Data Model

Entity

Entity Hospital Pneumonia Care Quality Analysis

Description

The analysis of the quality of care given in the hospital to pneumonia patients.

Attributes
Calendar Dk
Geographic Area Dk
Number Of Pneumonia Patients Assessed And Given Pneumococcal Vaccination
Number Of Pneumonia Patients Given Initial Antibiotic Within 4 Hours After Arrival
Number Of Pneumonia Patients Given Oxygenation Assessment
Number Of Pneumonia Patients Given The Most Appropriate Initial Antibiotic
Number Of Pneumonia Patients Having A Blood Culture Performed Prior To First Antibiotic Received In Hospital
Number Of Pneumonia Patients Treated
Patient Dk
Percentage Of Pneumonia Patients Assessed And Given Pneumococcal Vaccination
Percentage Of Pneumonia Patients Given Initial Antibiotic Within 4 Hours After Arrival
Percentage Of Pneumonia Patients Given Oxygenation Assessment
Percentage Of Pneumonia Patients Given The Most Appropriate Initial Antibiotic
Percentage Of Pneumonia Patients Having A Blood Culture Performed Prior To First Antibiotic Received In Hospital
Plan Member Dk
Practitioner Dk
Provider Dk

Relationship
Hospital Pneumonia Care Quality Analysis_Calendar Dimension_FK
Hospital Pneumonia Care Quality Analysis_Geographic Area Dimension_FK
Hospital Pneumonia Care Quality Analysis_Plan Member Dimension_FK
Hospital Pneumonia Care Quality Analysis_Patient Dimension_FK
Hospital Pneumonia Care Quality Analysis_Provider Dimension_FK
Hospital Pneumonia Care Quality Analysis_Practitioner Dimension_FK

Primary Key
Hospital Pneumonia Care Quality Analysis 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

Geographic Area 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

Number Of Pneumonia Patients Assessed And Given Pneumococcal Vaccination

Description	A pneumonia (pneumococcal) shot can help prevent pneumonia in the future, even for patients who have been hospitalized for pneumonia. This measures the number of patients who are provided with an assessment and this medication.
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

Number Of Pneumonia Patients Given Initial Antibiotic Within 4 Hours After Arrival

Description	The number of patients who are provided with antibiotics within 4 hours of arrival at the healthcare location to improve the treatment of pneumonia caused by bacteria.
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

Number Of Pneumonia Patients Given Oxygenation Assessment

Description	The number of pneumonia patients who are provided with oxygen.
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

Number Of Pneumonia Patients Given The Most Appropriate Initial Antibiotic

Description	The number of patients who were evaluated and provided the most appropriate initial antibiotics for treating their infection type.
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

Number Of Pneumonia Patients Having A Blood Culture Performed Prior To First Antibiotic Received In Hospital

Description	The number of patients who have a blood culture performed to determine what kind of medicine will work best to treat their pneumonia prior to receiving their first antibiotic in the hospital.
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

Number Of Pneumonia Patients Treated

Description	Number of pneumonia patients treated.
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

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

Percentage Of Pneumonia Patients Assessed And Given Pneumococcal Vaccination

Description	A pneumonia (pneumococcal) shot can help prevent pneumonia in the future, even for patients who have been hospitalized for pneumonia. This measures the percentage of patients who are provided with an assessment and this medication. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of Pneumonia Patients Given Initial Antibiotic Within 4 Hours After Arrival

Description	Timely use of antibiotics can improve the treatment of pneumonia caused by bacteria. This measures the percentage of patients who are provided with antibiotics. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of Pneumonia Patients Given Oxygenation Assessment

Description	The percentage of pneumonia patients who are provided with oxygen. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of Pneumonia Patients Given The Most Appropriate Initial Antibiotic

Description	The percentage of patients who were evaluated and provided the most appropriate initial antibiotics for treating their infection type. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Percentage Of Pneumonia Patients Having A Blood Culture Performed Prior To First Antibiotic Received In Hospital

Description	The percentage of patients who have a blood culture performed to determine what kind of medicine will work best to treat their pneumonia. Formula: [(A/B)*100] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Plan Member 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

Hospital Pneumonia Care Quality Analysis_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Hospital Pneumonia Care Quality Analysis
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

Hospital Pneumonia Care Quality Analysis_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Hospital Pneumonia Care Quality Analysis
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	Geographic Area Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Hospital Pneumonia Care Quality Analysis_Plan Member Dimension_FK

Is Identifying Relationship	true
Child Table	Hospital Pneumonia Care Quality Analysis
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	Plan Member Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Hospital Pneumonia Care Quality Analysis_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Hospital Pneumonia Care Quality Analysis
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

Hospital Pneumonia Care Quality Analysis_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Hospital Pneumonia Care Quality Analysis
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

Hospital Pneumonia Care Quality Analysis_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Hospital Pneumonia Care Quality Analysis
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

Primary Key Details

Hospital Pneumonia Care Quality Analysis PK

Key Attribute	Plan Member Dk
Key Attribute	Patient Dk
Key Attribute	Provider Dk
Key Attribute	Practitioner Dk
Key Attribute	Calendar Dk
Key Attribute	Geographic Area Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model