Dimensional Warehouse Model Data Model

Entity

Entity Respiratory Conditions Snapshot

Description

A snapshot fact table which consists of measures, indicators and timestamps related to the diagnosis and treatment of patients with respiratory conditions.

Attributes
Acute Bronchitis Diagnosis Ts
Acute Bronchitis Ind
Admission Ts
Antibiotic Prescription Ind
Antibiotic Prescription Ts
Appropriate Medication For Asthma Patients Ind
Appropriate Medication For Asthma Patients Ts
Asthma Diagnosis Ts
Asthma Ind
Bronchodilator Dispensed Ind
Bronchodilator Dispense Ts
Calendar Dk
Condition Dk
Control Medication For Asthma Patient Dispense Qty
Control Medication For Asthma Patients Dispense Ts
COPD Diagnosis Ts
COPD Exacerbation Diagnosis Ts
COPD Exacerbation Ind
COPD Ind
Discharge Ts
Geographic Area Dk
Group A Streptococcus Test Ind
Group A Streptococcus Test Ts
Inpatient Ind
Load Info Sk
Outpatient Ind
Patient Dk
Pharyngitis Diagnosis Ts
Pharyngitis Ind
Practitioner Dk
Provider Dk
Spirometry Test Ind
Spirometry Test Ts
Systemic Corticosteroid Dispensed Ind
Systemic Corticosteroid Dispense Ts
Tenant Sk
Upper Respiratory Infection Diagnosis Ts
Upper Respiratory Infection Ind

Relationship
Respiratory Conditions Snapshot_Practitioner Dimension_FK
Respiratory Conditions Snapshot_Provider Dimension_FK
Respiratory Conditions Snapshot_Geographic Area Dimension_FK
Respiratory Conditions Snapshot_Calendar Dimension_FK
Respiratory Conditions Snapshot_Condition Dimension_FK
Respiratory Conditions Snapshot_Patient Dimension_FK

Primary Key
Respiratory Conditions Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Acute Bronchitis Diagnosis Ts

Description	Date and time when the patient was diagnosed with Acute Bronchitis.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Acute Bronchitis Ind

Description	Indicator to identify if a patient has been diagnosed with Acute Bronchitis.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Admission Ts

Description	The date and time a patient was admitted to a healthcare facility, usually as an inpatient. It may also be used to reflect the date and time of an out-patient or emergency patient registration.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Antibiotic Prescription Ind

Description	Indicator to show whether the patient was prescribed antibiotics.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Antibiotic Prescription Ts

Description	Date and time that the patient was most recently prescribed antibiotics.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Appropriate Medication For Asthma Patients Ind

Description	Indicator to identify that a patient with persistent asthma has been prescribed appropriate medication.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Appropriate Medication For Asthma Patients Ts

Description	Date and time when appropriate medication was most recently prescribed for a patient with Asthma.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Asthma Diagnosis Ts

Description	Date and time when the patient was diagnosed with asthma.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Asthma Ind

Description	Indicator to identify if a patient has been diagnosed with asthma.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Bronchodilator Dispensed Ind

Description	Indicator to identify whether a patient who had an COPD exacerbation was dispensed a bronchodilator.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Bronchodilator Dispense Ts

Description	Date and time when a bronchodilator was dispensed for a patient who had an COPD exacerbation.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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

Condition 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

Control Medication For Asthma Patient Dispense Qty

Description	The quantity of asthma control medications dispensed to a patient with persistent asthma.
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Control Medication For Asthma Patients Dispense Ts

Description	Date and time that asthma control medications were most recently dispensed for a patient with persistent asthma.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

COPD Diagnosis Ts

Description	Date and time when the patient was diagnosed with chronic obstructive pulmonary disease (COPD).
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

COPD Exacerbation Diagnosis Ts

Description	Date and time when a patient diagnosed with Chronic obstructive pulmonary disease (COPD) had an exacerbation of COPD.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

COPD Exacerbation Ind

Description	Indicator to identify if a patient has been diagnosed with chronic obstructive pulmonary disease (COPD) and had an exacerbation of COPD.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

COPD Ind

Description	Indicator to identify if a patient has been diagnosed with chronic obstructive pulmonary disease (COPD).
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Discharge Ts

Description	The date and time a patient was released or discharged from a healthcare facility following an admission.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
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

Group A Streptococcus Test Ind

Description	Indicator to identify if a patient diagnosed with Pharyngitis has received a group A streptococcus (strep) test for the episode.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Group A Streptococcus Test Ts

Description	Date and time when the Group A streptococcus test was carried out for the patient diagnosed with Pharyngitis.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Inpatient Ind

Description	An Indicator to Identify an Inpatient. Inpatient is a type of encounter in which the patient visits the healthcare facility and stays overnight and is assigned a bed. An encounter groups a number of healthcare events, typically commencing with an admission or transfer into the healthcare facility and ends with a discharge or transfer out.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Outpatient Ind

Description	An indicator to identify and Outpatient. Outpatient is a type of encounter that takes place when the patient visits the healthcare facility but does not stay overnight and it is not assigned a bed.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [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

Pharyngitis Diagnosis Ts

Description	Date and time when the patient was diagnosed with Pharyngitis.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pharyngitis Ind

Description	Indicator to identify if a patient has been diagnosed with Pharyngitis.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
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

Spirometry Test Ind

Description	Indicator to identify if a patient diagnosed with chronic obstructive pulmonary disease (COPD) has received a spirometry test.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Spirometry Test Ts

Description	Date and time when a spirometry test was carried out for a patient diagnosed with chronic obstructive pulmonary disease (COPD).
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Systemic Corticosteroid Dispensed Ind

Description	Indicator to identify whether a patient who had an COPD exacerbation was dispensed a systemic corticosteroid.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Systemic Corticosteroid Dispense Ts

Description	Date and time when a systemic corticosteroid was dispensed for a patient who had an COPD exacerbation.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Upper Respiratory Infection Diagnosis Ts

Description	Date and time when the patient was diagnosed with an Upper Respiratory Infection.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Upper Respiratory Infection Ind

Description	Indicator to identify if a patient has been diagnosed with an Upper Respiratory Infection.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Respiratory Conditions Snapshot_Practitioner Dimension_FK

Is Identifying Relationship	true
Child Table	Respiratory Conditions Snapshot
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

Respiratory Conditions Snapshot_Provider Dimension_FK

Is Identifying Relationship	true
Child Table	Respiratory Conditions Snapshot
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

Respiratory Conditions Snapshot_Geographic Area Dimension_FK

Is Identifying Relationship	true
Child Table	Respiratory Conditions Snapshot
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

Respiratory Conditions Snapshot_Calendar Dimension_FK

Is Identifying Relationship	true
Child Table	Respiratory Conditions Snapshot
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

Respiratory Conditions Snapshot_Condition Dimension_FK

Is Identifying Relationship	true
Child Table	Respiratory Conditions Snapshot
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	Condition Dimension
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Respiratory Conditions Snapshot_Patient Dimension_FK

Is Identifying Relationship	true
Child Table	Respiratory Conditions Snapshot
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

Primary Key Details

Respiratory Conditions Snapshot PK

Key Attribute	Geographic Area Dk
Key Attribute	Patient Dk
Key Attribute	Practitioner Dk
Key Attribute	Provider Dk
Key Attribute	Calendar Dk
Key Attribute	Condition Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model