Entity Emergency Department Performance Analysis

DescriptionAnalysis 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



Attributes
Calendar DkCalendar Dk
ED Average Duration Between Disposition To DepartureED Average Duration Between Disposition To Departure
ED Average Duration Between Imaging Order And ResultsED Average Duration Between Imaging Order And Results
ED Average Duration Between Lab Order And ResultsED Average Duration Between Lab Order And Results
ED Average Length Of StayED Average Length Of Stay
ED Average Time To Practitioner First ContactED Average Time To Practitioner First Contact
ED Average Triage DurationED Average Triage Duration
ED Disposition To Departure TimeED Disposition To Departure Time
ED Duration Between Imaging Order And ResultsED Duration Between Imaging Order And Results
ED Duration Between Lab Order And ResultsED Duration Between Lab Order And Results
ED Length Of StayED Length Of Stay
ED Time To Practitioner First ContactED Time To Practitioner First Contact
ED Triage Acuity Rating DkED Triage Acuity Rating Dk
ED Triage DurationED Triage Duration
Geographic Area DkGeographic Area Dk
Number Of ED Psych AssessmentsNumber Of ED Psych Assessments
Number Of ED Visit ComplaintsNumber Of ED Visit Complaints
Number Of ED VisitsNumber Of ED Visits
Number Of ED Visits AdmittedNumber Of ED Visits Admitted
Number Of ED Visits Admitted To ICUNumber Of ED Visits Admitted To ICU
Number Of ED Visits DischargedNumber Of ED Visits Discharged
Number Of ED Visits Left Against AdviceNumber Of ED Visits Left Against Advice
Number Of ED Visits Left Incomplete TreatmentNumber Of ED Visits Left Incomplete Treatment
Number Of ED Visits Left UnassessedNumber Of ED Visits Left Unassessed
Number Of ED Visits MedicatedNumber Of ED Visits Medicated
Number Of ED Visits TransferredNumber Of ED Visits Transferred
Number Of ED Visits Via EMSNumber Of ED Visits Via EMS
Number Of ED Visits With CTNumber Of ED Visits With CT
Number Of ED Visits With ECGNumber Of ED Visits With ECG
Number Of ED Visits With Lab TestsNumber Of ED Visits With Lab Tests
Number Of ED Visits With MRINumber Of ED Visits With MRI
Number Of ED Visits With RadiographyNumber Of ED Visits With Radiography
Number Of ED Visits With UltrasoundNumber Of ED Visits With Ultrasound
Number Of Geriatric ED VisitsNumber Of Geriatric ED Visits
Number Of Pediatric ED VisitsNumber Of Pediatric ED Visits
Patient DkPatient Dk
Percentage Of ED Psych AssessmentsPercentage Of ED Psych Assessments
Percentage Of ED Visit ComplaintsPercentage Of ED Visit Complaints
Percentage Of ED Visits AdmittedPercentage Of ED Visits Admitted
Percentage Of ED Visits Admitted To ICUPercentage Of ED Visits Admitted To ICU
Percentage Of ED Visits DischargedPercentage Of ED Visits Discharged
Percentage Of ED Visits Left Against AdvicePercentage Of ED Visits Left Against Advice
Percentage Of ED Visits Left Incomplete TreatmentPercentage Of ED Visits Left Incomplete Treatment
Percentage Of ED Visits Left UnassessedPercentage Of ED Visits Left Unassessed
Percentage Of ED Visits MedicatedPercentage Of ED Visits Medicated
Percentage Of ED Visits TransferredPercentage Of ED Visits Transferred
Percentage Of ED Visits via EMSPercentage Of ED Visits via EMS
Percentage Of ED Visits With CTPercentage Of ED Visits With CT
Percentage Of ED Visits With ECGPercentage Of ED Visits With ECG
Percentage Of ED Visits With Lab TestsPercentage Of ED Visits With Lab Tests
Percentage Of ED Visits With MRIPercentage Of ED Visits With MRI
Percentage Of ED Visits With RadiographyPercentage Of ED Visits With Radiography
Percentage Of ED Visits With UltrasoundPercentage Of ED Visits With Ultrasound
Percentage Of Geriatric ED VisitPercentage Of Geriatric ED Visit
Percentage Of Pediatric ED VisitPercentage Of Pediatric ED Visit
Point Of Care Location DkPoint Of Care Location Dk
Practitioner DkPractitioner Dk
Provider DkProvider Dk

Relationship
Emergency Department Performance Analysis_Patient Dimension_FKEmergency Department Performance Analysis_Patient Dimension_FK
Emergency Department Performance Analysis_Practitioner Dimension_FKEmergency Department Performance Analysis_Practitioner Dimension_FK
Emergency Department Performance Analysis_Provider Dimension_FKEmergency Department Performance Analysis_Provider Dimension_FK
Emergency Department Performance Analysis_Calendar Dimension_FKEmergency Department Performance Analysis_Calendar Dimension_FK
Emergency Department Performance Analysis_Geographic Area Dimension_FKEmergency Department Performance Analysis_Geographic Area Dimension_FK
Emergency Department Performance Analysis_ED Triage Acuity Rating_FKEmergency Department Performance Analysis_ED Triage Acuity Rating_FK
Emergency Department Performance Analysis_Point Of Care Location Dimension_FKEmergency Department Performance Analysis_Point Of Care Location Dimension_FK

Primary Key
Emergency Department Performance Analysis PKEmergency Department Performance Analysis PK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Calendar Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 ED Average Duration Between Disposition To Departure
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 ED Average Duration Between Imaging Order And Results
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 ED Average Duration Between Lab Order And Results
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 ED Average Length Of Stay
DescriptionThe average time a patient spent in the Emergency Department.

Formula: [(A/B)]
(see dependencies and their labels for measures used in the formula)
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 ED Average Time To Practitioner First Contact
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 ED Average Triage Duration
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 ED Disposition To Departure Time
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 ED Duration Between Imaging Order And Results
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 ED Duration Between Lab Order And Results
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 ED Length Of Stay
DescriptionfThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 ED Time To Practitioner First Contact
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 ED Triage Acuity Rating Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 ED Triage Duration
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Geographic Area Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Psych Assessments
DescriptionThe number of patient visits to an emergency department that involved a psychiatric or psychological assessment or consultation.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visit Complaints
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits
DescriptionThe number of patient visits to an emergency department.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits Admitted
DescriptionThe number of patient visits to an emergency department where the patient was admitted to inpatient care.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits Admitted To ICU
DescriptionThe number of patient visits to an emergency department where the patient was admitted to an intensive care unit.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits Discharged
DescriptionThe number of patient visits to an emergency department where the patient was discharged by the ED staff without being admitted to inpatient care.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits Left Against Advice
DescriptionThe number of patient visits to an emergency department where the patient left the ED against the advice of the ED staff.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits Left Incomplete Treatment
DescriptionThe number of patient visits to an emergency department where the patient left the ED before the treatment decided upon was complete.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits Left Unassessed
DescriptionThe number of patient visits to an emergency department where the patient left the ED before the ED staff had assessed their condition.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits Medicated
DescriptionThe number of patient visits to an emergency department where the patient was given medication.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits Transferred
DescriptionThe number of patient visits to an emergency department where the patient was transferred to another healthcare facility.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits Via EMS
DescriptionThe number of patient visits to an emergency department where the patient arrived by an EMS.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits With CT
DescriptionThe number of patient visits to an emergency department that required Computed Tomography (CT).
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits With ECG
DescriptionThe number of patient visits to an emergency department that included an ECG.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits With Lab Tests
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits With MRI
DescriptionThe number of patient visits to an emergency department that required Magnetic resonance imaging (MRI) .
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits With Radiography
DescriptionThe number of patient visits to an emergency department that required plain radiography.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of ED Visits With Ultrasound
DescriptionThe number of patient visits to an emergency department that required ultrasonographic study.
Data TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Geriatric ED Visits
DescriptionThe number of patient visits to an emergency department where the patient was over 65.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Pediatric ED Visits
DescriptionThe number of patient visits to an emergency department where the patient was under 18.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Patient Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Psych Assessments
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visit Complaints
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits Admitted
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits Admitted To ICU
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits Discharged
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits Left Against Advice
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits Left Incomplete Treatment
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits Left Unassessed
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits Medicated
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits Transferred
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits via EMS
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits With CT
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits With ECG
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits With Lab Tests
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits With MRI
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits With Radiography
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of ED Visits With Ultrasound
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of Geriatric ED Visit
DescriptionThe 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Percentage Of Pediatric ED Visit
DescriptionNumber 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 TypeStandards - Data Domains.ddm/Data Domains/Percentage [FLOAT(2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Point Of Care Location Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Practitioner Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Provider Dk
DescriptionA numeric surrogate key used to uniquely identify entities in the dimensional model.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Emergency Department Performance Analysis_Patient Dimension_FK
Is Identifying Relationshiptrue
Child TableEmergency Department Performance Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Emergency Department Performance Analysis_Practitioner Dimension_FK
Is Identifying Relationshiptrue
Child TableEmergency Department Performance Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePractitioner Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Emergency Department Performance Analysis_Provider Dimension_FK
Is Identifying Relationshiptrue
Child TableEmergency Department Performance Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableProvider Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Emergency Department Performance Analysis_Calendar Dimension_FK
Is Identifying Relationshiptrue
Child TableEmergency Department Performance Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCalendar Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Emergency Department Performance Analysis_Geographic Area Dimension_FK
Is Identifying Relationshiptrue
Child TableEmergency Department Performance Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableGeographic Area Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Emergency Department Performance Analysis_ED Triage Acuity Rating_FK
Is Identifying Relationshiptrue
Child TableEmergency Department Performance Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableCommon Code Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Emergency Department Performance Analysis_Point Of Care Location Dimension_FK
Is Identifying Relationshiptrue
Child TableEmergency Department Performance Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePoint Of Care Location Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Emergency Department Performance Analysis PK
Key AttributeGeographic Area Dk
Key AttributePatient Dk
Key AttributePractitioner Dk
Key AttributeProvider Dk
Key AttributeCalendar Dk
Key AttributePoint Of Care Location Dk
Key AttributeED Triage Acuity Rating Dk