Dimensional Warehouse Model Data Model

Entity

Entity Surgery Analysis

Description

The analysis of the treatment of patients involving surgery, typically carried out in the operating room. Key metrics include counts and duration of cases and procedures as well as calculated averages to provide perspective.

Attributes
Average Duration Between Patient Ready And OR Arrival
Average Duration Of Surgical Procedure
Average Number Of Practitioners In Surgery Team
Average Number Of Procedures Per Surgery Case
Average PACU Care Duration
Average PostOp Care Duration
Average Scheduled OR Arrival Time Deviation
Average Surgery OR Duration
Calendar Dk
Diagnosis Code Dk
Duration Between Patient Ready And OR Arrival
Duration Of PACU Care
Duration Of PostOp Care
Duration Of Surgery OR
Duration Of Surgical Procedures
Encounter Dk
Medication Dk
Number Of Auto Accident Related Surgery Cases
Number Of Cancer Related Surgery Cases
Number Of Cardiac Patients With Controlled Blood Glucose
Number Of Inpatient Surgery Cases
Number Of Medications Used
Number Of Outpatient Surgery Cases
Number Of Patients With Appropriate Hair Removal
Number Of Postoperative Deaths
Number Of Practitioners In Surgery Case
Number Of Procedures
Number Of Surgery Cases
Patient Dk
Point Of Care Location Dk
Practitioner Dk
Procedure Code Dk
Provider Dk
Scheduled Actual OR Arrival Time Deviation
Surgery Life Cycle Status Duration

Relationship
Surgery Analysis_Point Of Care Location Dimension_FK
Surgery Analysis_Encounter Dimension_FK
Surgery Analysis_Diagnosis Dimension_FK
Surgery Analysis_Procedure Dimension_FK
Surgery Analysis_Medication Dimension_FK
Surgery Analysis_Calendar Dimension_FK
Surgery Analysis_Practitioner Dimension_FK
Surgery Analysis_Patient Dimension_FK
Surgery Analysis_Provider Dimension_FK

Primary Key
Surgery Analysis PK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Average Duration Between Patient Ready And OR Arrival

Description	The average time in minutes between when a surgery patient is ready for movement into the operating room (OR) and when they actually arrive into OR.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Duration Of Surgical Procedure

Description	The average time, in minutes, taken to complete surgical procedures. This is based on the time spent on each procedure rather than the total time patients spend in the operating room. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Number Of Practitioners In Surgery Team

Description	The average number of practitioners involved in surgery cases. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Number Of Procedures Per Surgery Case

Description	The average number of procedures performed during surgery. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average PACU Care Duration

Description	The average time, in minutes, a patient spends in a post anesthesia care unit (PACU). Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average PostOp Care Duration

Description	The average time, in minutes, a patient spends in post operative (PostOp) care. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Scheduled OR Arrival Time Deviation

Description	Average operating room tardiness in minutes based on schedule start time.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Average Surgery OR Duration

Description	The average time, in minutes, a surgery patient spends in the operating room. Formula: [A/B] (see dependencies and their labels for measures used in the formula)
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [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

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

Duration Between Patient Ready And OR Arrival

Description	The time in minutes between when a surgery patient is ready for movement into the operating room (OR) and when they actually arrive into OR.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Duration Of PACU Care

Description	Time, in minutes, in post anesthesia care unit (PACU).
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

Duration Of PostOp Care

Description	Time, in minutes, in post operative 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

Duration Of Surgery OR

Description	Time, in minutes, actually in surgery, in operating room.
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

Duration Of Surgical Procedures

Description	The time, in minutes, taken to complete surgical procedures, typically the interval between wound incision and wound closure time for each procedure performed during surgery.
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

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

Medication 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 Auto Accident Related Surgery Cases

Description	Count of surgery cases directly related to automobile accidents.
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 Cancer Related Surgery Cases

Description	Count of surgery cases directly related to cancer.
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 Cardiac Patients With Controlled Blood Glucose

Description	Count of cardiac surgery patients with controlled levels of blood glucose at 6 a.m. post surgery.
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 Inpatient Surgery Cases

Description	Count of surgery cases for inpatients.
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 Medications Used

Description	Number of distinct medications used in the Surgery Case.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Number Of Outpatient Surgery Cases

Description	Count of surgery cases for outpatients.
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 Patients With Appropriate Hair Removal

Description	Count of surgery patients having had the appropriate hair removed for the said surgery.
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 Postoperative Deaths

Description	Count of patients who died shortly after surgery typically on day of surgery or within a short period afterwards.
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 Practitioners In Surgery Case

Description	A count of practitioners involved in surgery. This can typically include a lead surgeon, assisting surgeon, anesthesiologist, nurse and so forth.
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 Procedures

Description	Count of procedures involved in surgery.
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 Surgery Cases

Description	Count of actual surgery cases.
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

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

Procedure 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	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

Scheduled Actual OR Arrival Time Deviation

Description	The duration, in minutes, of any delays due to patients arriving in the operating room after their planned arrival time.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Surgery Life Cycle Status Duration

Description	Time, in minutes, the patient is in the specific surgery life cycle state.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Surgery Analysis_Point Of Care Location Dimension_FK

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

Surgery Analysis_Encounter Dimension_FK

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

Surgery Analysis_Diagnosis Dimension_FK

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

Surgery Analysis_Procedure Dimension_FK

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

Surgery Analysis_Medication Dimension_FK

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

Surgery Analysis_Calendar Dimension_FK

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

Surgery Analysis_Practitioner Dimension_FK

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

Surgery Analysis_Patient Dimension_FK

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

Surgery Analysis_Provider Dimension_FK

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

Primary Key Details

Surgery Analysis PK

Key Attribute	Provider Dk
Key Attribute	Point Of Care Location Dk
Key Attribute	Patient Dk
Key Attribute	Encounter Dk
Key Attribute	Practitioner Dk
Key Attribute	Diagnosis Code Dk
Key Attribute	Procedure Code Dk
Key Attribute	Medication Dk
Key Attribute	Calendar Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model