| Dimensional Warehouse Model Data Model |
| Description | Analysis of the the performance and utilization of an Emergency Department of a Healthcare Organization. An emergency department (ED), also known as emergency room (ER), accident & emergency (A&E), or casualty department, is a medical treatment facility specialized in acute care of patients who present without prior appointment, either by their own means or by an emergency medical service (EMS). Dimensions (and sample axes of analysis): - Calendar (Reporting Year) - Geographic Area (Region, State) - Patient (Age, Gender, Smoker Status, BMI) - Point of Care Location - ED Triage Acuity Rating - Practitioner - Provider |
| Primary Key | |
Emergency Department Performance 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 |
ED Average Duration Between Disposition To Departure
| Description | The Average interval time between the recording of the disposition decision and the actual departure of the patient from the Emergency Department. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula) |
| 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 |
ED Average Duration Between Imaging Order And Results
| Description | The Average time interval between the request of imagining tests and the availability of results for a patient visiting Emergency Department. Formula: [A/(B+C+D+E)] (see dependencies and their labels for measures used in the formula) |
| 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 |
ED Average Duration Between Lab Order And Results
| Description | The Average time interval between the request of lab tests and the availability of results for a patient visiting Emergency Department. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula) |
| 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 |
ED Average Length Of Stay
| Description | The average time a patient spent in the Emergency Department. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula) |
| 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 |
ED Average Time To Practitioner First Contact
| Description | The average time a patient spent in ED before being seen by a practitioner other than the triage nurse. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula) |
| 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 |
ED Average Triage Duration
| Description | The average time spent in Triage by a patients visiting an Emergency Department. Formula: [(A/B)] (see dependencies and their labels for measures used in the formula) |
| 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 |
ED Disposition To Departure Time
| Description | The interval time (in Mins) between the recording of the disposition decision and the actual departure of the patient from the Emergency Department.This measure is the sum of duration (in mins) for all the ED visits within a period of analysis. |
| 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 |
ED Duration Between Imaging Order And Results
| Description | The time interval (in Mins) between the request of imagining tests and the availability of results for a patient visiting Emergency Department.This measure is the sum of duration (in mins) for all the ED visits within a period of analysis. |
| 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 |
ED Duration Between Lab Order And Results
| Description | The time interval (in Mins) between the request of lab tests and the availability of results for a patient visiting Emergency Department.This measure is the sum of duration (in mins) for all the ED visits within a period of analysis. |
| 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 |
ED Length Of Stay
| Description | fThe time (in Mins) a patient spent in the Emergency Department.This measure is the sum of Length of Stay (in mins) for all the ED visits within a period of analysis. |
| 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 |
ED Time To Practitioner First Contact
| Description | The time (in Mins) a patient spent in Emergency Department before being seen by a practitioner other than the triage nurse.This measure is the sum of Intervals (in mins) for all the ED visits within a period of analysis. |
| 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 |
ED Triage Acuity Rating 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 |
ED Triage Duration
| Description | The time (in Mins) spent in Triage by a patients visting Emergency Department.This measure is the sum of Triage Duration (in mins) for all the ED visits within a period of analysis. |
| 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 |
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 ED Psych Assessments
| Description | The number of patient visits to an emergency department that involved a psychiatric or psychological assessment or consultation. |
| 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 |
Number Of ED Visit Complaints
| Description | The number of patient visits to an emergency department where 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/Percentage [FLOAT(2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Number Of ED Visits
| Description | The number of patient visits to an emergency department. |
| 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 ED Visits Admitted
| Description | The number of patient visits to an emergency department where the patient was admitted to inpatient care. |
| 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 |
Number Of ED Visits Admitted To ICU
| Description | The number of patient visits to an emergency department where the patient was admitted to an intensive care unit. |
| 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 |
Number Of ED Visits Discharged
| Description | The number of patient visits to an emergency department where the patient was discharged by the ED staff without being admitted to inpatient care. |
| 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 ED Visits Left Against Advice
| Description | The number of patient visits to an emergency department where the patient left the ED against the advice of the ED staff. |
| 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 |
Number Of ED Visits Left Incomplete Treatment
| Description | The number of patient visits to an emergency department where the patient left the ED before the treatment decided upon was complete. |
| 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 |
Number Of ED Visits Left Unassessed
| Description | The number of patient visits to an emergency department where the patient left the ED before the ED staff had assessed their condition. |
| 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 |
Number Of ED Visits Medicated
| Description | The number of patient visits to an emergency department where the patient was given medication. |
| 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 |
Number Of ED Visits Transferred
| Description | The number of patient visits to an emergency department where the patient was transferred to another healthcare facility. |
| 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 ED Visits Via EMS
| Description | The number of patient visits to an emergency department where the patient arrived by an EMS. |
| 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 ED Visits With CT
| Description | The number of patient visits to an emergency department that required Computed Tomography (CT). |
| 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 |
Number Of ED Visits With ECG
| Description | The number of patient visits to an emergency department that included an ECG. |
| 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 |
Number Of ED Visits With Lab Tests
| Description | The number of patient visits to an emergency department that involved one or more lab tests. This is not the number of tests but the number of visits involving tests. |
| 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 |
Number Of ED Visits With MRI
| Description | The number of patient visits to an emergency department that required Magnetic resonance imaging (MRI) . |
| 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 |
Number Of ED Visits With Radiography
| Description | The number of patient visits to an emergency department that required plain radiography. |
| 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 |
Number Of ED Visits With Ultrasound
| Description | The number of patient visits to an emergency department that required ultrasonographic study. |
| 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 |
Number Of Geriatric ED Visits
| Description | The number of patient visits to an emergency department where the patient was over 65. |
| 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 Pediatric ED Visits
| Description | The number of patient visits to an emergency department where the patient was under 18. |
| 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 ED Psych Assessments
| Description | Number of patient visits to an emergency department that involved a psychiatric or psychological assessment or consultation, expressed as a percentage of total number of Emergency department visits. 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 ED Visit Complaints
| Description | Number of patient visits to an emergency department where the patient made a complaint about the timeliness, quality or some other aspect of their care experience in the ED, expressed as a percentage of total number of Emergency department visits. 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 ED Visits Admitted
| Description | Number of patient visits to an emergency department where the patient was admitted to inpatient care expressed as a percentage of total number of Emergency department visits. 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 ED Visits Admitted To ICU
| Description | Number of patient visits to an emergency department where the patient was admitted to an intensive care unit (ICU) expressed as a percentage of total number of Emergency department visits. 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 ED Visits Discharged
| Description | Number of patient visits to an emergency department where the patient was discharged by the ED staff without being admitted to inpatient care. expressed as a percentage of total number of Emergency department visits. 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 ED Visits Left Against Advice
| Description | Number of patient visits to an emergency department where the patient left the ED against the advice of the ED staff,expressed as a percentage of total number of Emergency department visits. 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 ED Visits Left Incomplete Treatment
| Description | Number of patient visits to an emergency department where the patient left the ED before the treatment decided upon was complete,expressed as a percentage of total number of Emergency department visits. 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 ED Visits Left Unassessed
| Description | Number of patient visits to an emergency department where the patient left the ED before the ED staff had assessed their condition,expressed as a percentage of total number of Emergency department visits. 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 ED Visits Medicated
| Description | Number of patient visits to an emergency department where the patient was given medication,expressed as a percentage of total number of Emergency department visits. 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 ED Visits Transferred
| Description | Number of patient visits to an emergency department where the patient was transferred to another healthcare facility expressed as a percentage of total number of Emergency department visits. 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 ED Visits via EMS
| Description | Number of patient visits to an emergency department where the patient arrived by an Emergency Medical Services (EMS) expressed as a percentage of total number of Emergency Department visits. 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 ED Visits With CT
| Description | The number of patient visits to an emergency department that included a CT (Computed Tomography),expressed as a percentage of total number of Emergency department visits. 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 ED Visits With ECG
| Description | Number of patient visits to an emergency department that included an ECG expressed as a percentage of total number of Emergency department visits. 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 ED Visits With Lab Tests
| Description | Number of patient visits to an emergency department that involved one or more lab tests,expressed as a percentage of total number of Emergency department visits. This is not the number of tests but the number of visits involving tests. 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 ED Visits With MRI
| Description | The number of patient visits to an emergency department that included an MRI (Magnetic resonance imaging), expressed as a percentage of total number of Emergency department visits. 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 ED Visits With Radiography
| Description | The number of patient visits to an emergency department that included plain radiography,expressed as a percentage of total number of Emergency department visits. 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 ED Visits With Ultrasound
| Description | The number of patient visits to an emergency department that included an ultrasonographic study, expressed as a percentage of total number of Emergency department visits. 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 Geriatric ED Visit
| Description | The number of patient visits to an emergency department where the patient was over 65, expressed as a percentage of Total Number of Emergency Department visits. 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 Pediatric ED Visit
| Description | Number of patient visits to an emergency department where the patient was under 18, expressed as a percentage of Total Number of Emergency Department visits. 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 |
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 |
| Relationship Details |
Emergency Department Performance Analysis_Patient Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Emergency Department Performance 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 |
Emergency Department Performance Analysis_Practitioner Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Emergency Department Performance 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 |
Emergency Department Performance Analysis_Provider Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Emergency Department Performance 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 |
Emergency Department Performance Analysis_Calendar Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Emergency Department Performance 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 |
Emergency Department Performance Analysis_Geographic Area Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Emergency Department Performance 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 |
Emergency Department Performance Analysis_ED Triage Acuity Rating_FK
| Is Identifying Relationship | true |
| Child Table | Emergency Department Performance 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 | Common Code Dimension |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Emergency Department Performance Analysis_Point Of Care Location Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Emergency Department Performance 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 | 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 |
Emergency Department Performance Analysis PK
| Key Attribute | Geographic Area Dk |
| Key Attribute | Patient Dk |
| Key Attribute | Practitioner Dk |
| Key Attribute | Provider Dk |
| Key Attribute | Calendar Dk |
| Key Attribute | Point Of Care Location Dk |
| Key Attribute | ED Triage Acuity Rating Dk |
| Dimensional Warehouse Model Data Model |