Overview Top Package Entity

Dimensional Warehouse Model Data Model

---

Entity Emergency Department Visit Fact

Description

Contains measures, indicators and Timestamps related to Emergency department visits.

Attributes

AWM Load Info Sk

Calendar Dk

Current Ind

DWM Load Info Sk

ED Admitted to ICU Ind

ED Admitted to Inpatient Ind

ED Arrival in Exam Room Ts

ED Arrival Ts

ED Complaint Ind

ED Departure Ts

ED Diagnosis Ts

ED Discharged Ind

ED Disposition Ts

ED Drug Administration Qty

ED Drug Dosage

ED Drug Type Cd

ED ECG Ind

ED ECG Test Ts

ED EMS Visit Ind

ED Geriatric Visit Ind

ED Identification Ts

ED Imaging Data Ready Ts

ED Imaging Modality Cd

ED Imaging Request Ts

ED Lab Test Data Ready Ts

ED Lab Test Request Ts

ED Lab Test Type Cd

ED Left Against Advice Ind

ED Left Incomplete Treatment Ind

ED Left Unassessed Ind

ED Pediatric Visit Ind

ED Practitioner First Contact Ts

ED Psychiatric Assessment Ind

ED Registration End Ts

ED Registration Start Ts

ED Transfer of Care from EMS Ts

ED Transferred Ind

ED Triage Acuity Rating Cd

ED Triage Acuity Rating Code Dk

ED Triage End Ts

ED Triage Start Ts

Effective From Dt

Effective To Dt

Emergency Department Visit Fact Bk

Emergency Department Visit Fact Dk

Emergency Department Visit Fact Sk

Encounter Dk

Patient Dk

Point Of Care Location Dk

Practitioner Dk

Provider Dk

Source Cd

Source Code Sk

Tenant Sk

Valid From Ts

Valid To Ts

Relationship

Emergency Department Fact_Patient Dimension_FK

Emergency Department Fact_Practitioner Dimension_FK

Emergency Department Fact_Provider Dimension_FK

Emergency Department Fact_Encounter Dimension_FK

Emergency Department Fact_Point Of Care Location Dimension_FK

Emergency Department Fact_Calendar Dimension_FK

ED Triage Acuity Rating Code_FK

Primary Key

Emergency Department Visit Fact PK

Dependencies

NONE

Reverse Dependencies

Attribute Details

 AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
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

---

 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 DWM 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

---

 ED Admitted to ICU Ind

Description	Indicates that the ED patient was admitted to an intensive care unit.
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

---

 ED Admitted to Inpatient Ind

Description	Indicates that the Emergency Department patient was admitted to inpatient care.
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

---

 ED Arrival in Exam Room Ts

Description	The date and time a patient is placed in a location within the emergency department (ED) where an examination or treatment can be carried out. Here the patient will be seen by an ED nurse who will record more details of the patient's condition and history. The patient will also be seen by an ED physician who will continue collecting information on the condition, order any tests or images required and form an opinion on the most likely diagnoses. A final diagnosis will be formed when all information including lab tests and imaging results have been received and reviewed.
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

---

 ED Arrival Ts

Description	The date and time a patient first arrives at the emergency department (ED). This is not necessarily the same as the patients registration time or triage time. The purpose of this timestamp is to facilitate the recording of the amount of time a patient spends in the ED including any time spent waiting to register or to be seen.
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

---

 ED Complaint Ind

Description	Indicates that the patient made a complaint about the timeliness, quality or some other aspect of their care experience in the ED.
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

---

 ED Departure Ts

Description	The date and time a patient left the Emergency Department (ED) whether through admission, transfer or 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

---

 ED Diagnosis Ts

Description	The date and time a patient is diagnosed in Emergency Department (ED) with a specific condition enabling the commencement of appropriate treatment.
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

---

 ED Discharged Ind

Description	Indicates that the ED patient was discharged by ED staff without being admitted.
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

---

 ED Disposition Ts

Description	The date and time a decision is recorded regarding whether the patient should be admitted, discharged or transferred to another facility from Emergency Department.
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

---

 ED Drug Administration Qty

Description	The number of doses of a drug administered in Emergency Department.
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

---

 ED Drug Dosage

Description	The dose of any drug administered in Emergency department
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

---

 ED Drug Type Cd

Description	The type of drug that was administered for the patient visiting Emergency Department.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 ED ECG Ind

Description	Indicator to identify if an ED patient had electrocardiogram (ECG) 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

---

 ED ECG Test Ts

Description	Date and time when the patient had the electrocardiogram (ECG) test.
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

---

 ED EMS Visit Ind

Description	Indicates that the patient arrived at the Emergency Department via an emergency medical service.
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

---

 ED Geriatric Visit Ind

Description	Indicates that the patient visiting Emergency Department is over 65 years of age.
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

---

 ED Identification Ts

Description	The date and time the patient's identification is established in emergency department (ED). This is not necessarily the same as the registration time.
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

---

 ED Imaging Data Ready Ts

Description	The date and time the result of an imaging test was available for the patient in emergency department.
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

---

 ED Imaging Modality Cd

Description	The type of imaging test requested or the type of test series requested for the patient in emergency department.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 ED Imaging Request Ts

Description	The date and time an imaging test was requested for the patient in emergency department.
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

---

 ED Lab Test Data Ready Ts

Description	The date and time the results of a lab test were available for the patient in emergency department.
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

---

 ED Lab Test Request Ts

Description	The date and time a lab test or test series was requested for the patient in emergency department.
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

---

 ED Lab Test Type Cd

Description	The type of test requested or the type of test series requested for the patient in emergency department.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 ED Left Against Advice Ind

Description	Indicates that the patient left the ED against the advice of the ED staff.
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

---

 ED Left Incomplete Treatment Ind

Description	Indicates that the patient left the ED before the treatment decided upon was complete.
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

---

 ED Left Unassessed Ind

Description	Indicates that the patient left the ED before the ED staff had assessed their condition.
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

---

 ED Pediatric Visit Ind

Description	Indicates that the patient visiting Emergency Department is under 18 years of age.
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

---

 ED Practitioner First Contact Ts

Description	The date and time a patient has first contact with an Emergency Department (ED) physician or provider other than a triage nurse.
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

---

 ED Psychiatric Assessment Ind

Description	Indicates that the ED visit involved a psychiatric or psychological assessment or consultation.
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

---

 ED Registration End Ts

Description	The date and time the Patient is registered in the emergency department. This includes taking details of the patient's name, address, contact details for next of kin, insurance details and any other billing information that may be required.
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

---

 ED Registration Start Ts

Description	The date and time the Patient's registration is started in the emergency department. This includes taking details of the patient's name, address, contact details for next of kin, insurance details and any other billing information that may be required.
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

---

 ED Transfer of Care from EMS Ts

Description	The date and time the responsibility for care of the patient was transferred from the emergency medical service to the emergency department (ED) staff where a patient arrived at the ED via ambulance or other paramedic facility.
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

---

 ED Transferred Ind

Description	Indicates that the ED patient was transferred to another 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

---

 ED Triage Acuity Rating Cd

Description	A rating of the severity or urgency of a patient's condition based on a triage assessment.
Data Type	Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 ED Triage Acuity Rating 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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 ED Triage End Ts

Description	The date and time the Patient's Triage is completed. Here basic details of the patient's condition, medical history are recorded as well as the patients vital signs. An assessment of the urgency of the patient's condition is also made an normally categorized on a 5 point scale.
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

---

 ED Triage Start Ts

Description	The date and time the Patient starts Triage. Here basic details of the patient's condition, medical history are recorded as well as the patients vital signs. An assessment of the urgency of the patient's condition is also made an normally categorized on a 5 point scale.
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

---

 Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Effective To Dt

Description	Ends a period of effectivity.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

---

 Emergency Department Visit Fact Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Emergency Department Visit Fact 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	true

---

 Emergency Department Visit Fact Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
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	false
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	false
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	false
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	false
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	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

---

 Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
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

---

 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

---

 Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
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

---

 Valid To Ts

Description	Ends a period of validity.
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

Relationship Details

 Emergency Department Fact_Patient Dimension_FK

Is Identifying Relationship	false
Child Table	Emergency Department Visit Fact
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

---

 Emergency Department Fact_Practitioner Dimension_FK

Is Identifying Relationship	false
Child Table	Emergency Department Visit Fact
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

---

 Emergency Department Fact_Provider Dimension_FK

Is Identifying Relationship	false
Child Table	Emergency Department Visit Fact
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

---

 Emergency Department Fact_Encounter Dimension_FK

Is Identifying Relationship	false
Child Table	Emergency Department Visit Fact
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

---

 Emergency Department Fact_Point Of Care Location Dimension_FK

Is Identifying Relationship	false
Child Table	Emergency Department Visit Fact
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

---

 Emergency Department Fact_Calendar Dimension_FK

Is Identifying Relationship	false
Child Table	Emergency Department Visit Fact
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

---

 ED Triage Acuity Rating Code_FK

Is Identifying Relationship	false
Child Table	Emergency Department Visit Fact
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	Common 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

 Emergency Department Visit Fact PK

Key Attribute

Emergency Department Visit Fact Dk

---

Overview Top Package Entity

Dimensional Warehouse Model Data Model