Dimensional Warehouse Model Data Model

Entity

Entity Admission Snapshot

Description

A snapshot fact table which includes measures, time stamps and indicators related to admission.

Attributes
ACE Inhibitor Ind
Admission Cnt
Admission Ts
Antibiotic Within 4 Hours Of Arrival Ind
Appropriate Antibiotic Administered Ind
Aspirin At Discharge Ind
Aspirin On Arrival Ind
Assessment Of Left Ventricular Function LVF Ind
Beta Blocker At Arrival Ind
Blood Culture Prior To Antibiotic Ind
Calendar Dk
Discharge Instructions Ind
Discharge Ts
DWM Load Info Sk
Encounter Dk
Expected Admission Ts
Expected Discharge Ts
Geographic Area Dk
Load Info Sk
Oxygenation Assessment Ind
Patient Dk
PCI Within 120 Minutes Of Arrival Ind
Pneumococcal Vaccination Ind
Point Of Care Location Dk
Practitioner Dk
Provider Dk
Tenant Sk
Thrombolytic Medication Within 30 Minutes Of Arrival Ind
Tobacco Counseled Ind

Relationship
Admission Snapshot_Encounter Dimension_FK
Admission Snapshot_Patient Dimension_FK
Admission Snapshot_Provider Dimension_FK
Admission Snapshot_Practitioner Dimension_FK
Admission Snapshot_Calendar Dimension_FK
Admission Snapshot_Geographic Area Dimension_FK
Admission Snapshot_Point Of Care Location Dimension_FK

Primary Key
Admission Snapshot PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

ACE Inhibitor Ind

Description	Indicator that patient received ACE (angiotensin converting enzyme) inhibitors and ARBs (angiotensin receptor blockers) when appropriate.
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 Cnt

Description	Used to count fact rows. Always set to 1.
Data Type	Standards - Data Domains.ddm/Data Domains/Count [INTEGER]
Default Value	1
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Admission Ts

Description	The admit date/time. It is to be used if the event date/time is different than the admit date and time, i.e., a retroactive update. This field is also used to reflect the date/time of an out-patient/emergency patient registration.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Antibiotic Within 4 Hours Of Arrival Ind

Description	Indicator that patient received antibiotics with 4 hours of arrival at hospital. For example: for pneumonia patient.
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 Antibiotic Administered Ind

Description	Indicator that the first antibiotic that the patient was prescribed in the healthcare facility was the best to treat the infection type.
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

Aspirin At Discharge Ind

Description	Indicator that the patient was given aspirin at the time of discharge when appropriate.
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

Aspirin On Arrival Ind

Description	Indicator that the patient was given aspirin at the time of arrival at the healthcare facility.
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

Assessment Of Left Ventricular Function LVF Ind

Description	Indicator that patient received an LVF assessment to determine how the left chamber of the heart is pumping.
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

Beta Blocker At Arrival Ind

Description	Indicator that the patient was given a beta blocker at the time of arrival at the healthcare facility.
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

Blood Culture Prior To Antibiotic Ind

Description	Indicator that a blood culture was performed on the patient prior to prescribing antibiotic to determine the best antibiotic to use.
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

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

Discharge Instructions Ind

Description	Indicator that patient received discharge instructions regarding how to manage their condition. For example: how to deal with heart failure symptoms.
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 discharge date/time. It is to be used if the event date/time is different than the discharge date and time, that is, a retroactive update. This field is also used to reflect the date/time of an outpatient/emergency patient discharge.
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

DWM Load Info Sk

Description	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

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

Expected Admission Ts

Description	The date and time that the patient is expected to be admitted. This field is also used to reflect the date/time of an outpatient/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

Expected Discharge Ts

Description	The date and time that the patient is expected to be discharged. This is a non-event related date used by ancillaries to determine more accurately the projected workloads. This field is also used to reflect the anticipated discharge date/time of an outpatient/emergency patient, or an inpatient.
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

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

Oxygenation Assessment Ind

Description	Indicator that patient hospitalized was assessed for oxygen and given oxygen if appropriate. For example: for pneumonia
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

PCI Within 120 Minutes Of Arrival Ind

Description	Indicator that patient received Percutaneous Coronary Intervention (PCI) to open blocked blood vessels within 120 minutes of arrival at the hospital. For example: For a heart attack patient.
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

Pneumococcal Vaccination Ind

Description	Indicator that patient hospitalized for pneumonia received a pneumonia (pneumococcal) shot.
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

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

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

Thrombolytic Medication Within 30 Minutes Of Arrival Ind

Description	Indicator that patient received thrombolytic medication to stop blood clots within 30 minutes of arrival at hospital. For example: for a heart attack.
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

Tobacco Counseled Ind

Description	Indicator that patient received smoking assessment and advice to stop smoking.
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

Admission Snapshot_Encounter Dimension_FK

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

Admission Snapshot_Patient Dimension_FK

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

Admission Snapshot_Provider Dimension_FK

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

Admission Snapshot_Practitioner Dimension_FK

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

Admission Snapshot_Calendar Dimension_FK

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

Admission Snapshot_Geographic Area Dimension_FK

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

Admission Snapshot_Point Of Care Location Dimension_FK

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

Primary Key Details

Admission Snapshot PK

Key Attribute	Encounter Dk
Key Attribute	Patient Dk
Key Attribute	Provider Dk
Key Attribute	Practitioner Dk
Key Attribute	Calendar Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Geographic Area Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model