Entity Operating Room Performance Analysis

DescriptionAnalysis of the performance and utilization of an Operating Room (OR) for a healthcare organization. The measures included in this analytical requirement track time intervals between various surgical phases carried out within the OR, OR turn around times supporting utilization analysis for OR.


Dimensions (and sample axes of analysis):
- Calendar (Reporting Year)
- Encounter (Inpatient, outpatient settings)
- Patient (Age, Gender, Smoker Status, BMI)
- Point of Care Location
- Practitioner
- Provider
- Procedure
- Diagnosis




Attributes
Average Duration Between Final Wound Closure And Patient OR ExitAverage Duration Between Final Wound Closure And Patient OR Exit
Average Duration Between Patient OR Arrival And First IncisionAverage Duration Between Patient OR Arrival And First Incision
Average Duration Between Patient Ready And OR ArrivalAverage Duration Between Patient Ready And OR Arrival
Average Duration Between Patient Scheduled Time And Actual ArrivalAverage Duration Between Patient Scheduled Time And Actual Arrival
Average Duration Of Surgery ProcedureAverage Duration Of Surgery Procedure
Average Number Of Practitioners Per Surgery CaseAverage Number Of Practitioners Per Surgery Case
Average OR Turnaround TimeAverage OR Turnaround Time
Average PACU DurationAverage PACU Duration
Average PostOp DurationAverage PostOp Duration
Calendar DkCalendar Dk
Diagnosis Code DkDiagnosis Code Dk
Duration Between Final Closure And Patient OR ExitDuration Between Final Closure And Patient OR Exit
Duration Between Patient OR Arrival And First IncisionDuration Between Patient OR Arrival And First Incision
Duration Between Patient Ready And OR ArrivalDuration Between Patient Ready And OR Arrival
Duration Between Patient Scheduled Time And Actual ArrivalDuration Between Patient Scheduled Time And Actual Arrival
Encounter DkEncounter Dk
Number Of Canceled Surgery CasesNumber Of Canceled Surgery Cases
Number Of Deferred Surgery CasesNumber Of Deferred Surgery Cases
Number Of Emergency Surgery CasesNumber Of Emergency Surgery Cases
Number Of First Surgery Cases Started On Or Before Scheduled TimeNumber Of First Surgery Cases Started On Or Before Scheduled Time
Number Of Practitioners Per Surgery CaseNumber Of Practitioners Per Surgery Case
Number Of Scheduled Surgery CasesNumber Of Scheduled Surgery Cases
Number Of Surgery CasesNumber Of Surgery Cases
Number Of Surgery Patients Who Received Preventative Antibiotic One Hour Before IncisionNumber Of Surgery Patients Who Received Preventative Antibiotic One Hour Before Incision
Number Of Surgery Patients Whose Preventative Antibiotic Are Stopped Within 24 Hours After SurgeryNumber Of Surgery Patients Whose Preventative Antibiotic Are Stopped Within 24 Hours After Surgery
OR Time Utilized For Surgery CasesOR Time Utilized For Surgery Cases
OR Turnaround TimeOR Turnaround Time
PACU DurationPACU Duration
Patient DkPatient Dk
Percentage Of Canceled Surgery CasesPercentage Of Canceled Surgery Cases
Percentage Of Deferred Surgery CasesPercentage Of Deferred Surgery Cases
Percentage Of Emergency Surgery CasesPercentage Of Emergency Surgery Cases
Percentage Of First Surgery Cases on TimePercentage Of First Surgery Cases on Time
Percentage Of OR Utilization for Available TimePercentage Of OR Utilization for Available Time
Percentage Of OR Utilization for Scheduled TimePercentage Of OR Utilization for Scheduled Time
Percentage Of Scheduled Surgery CasesPercentage Of Scheduled Surgery Cases
Percentage Of Surgery Patients Who Received Preventative Antibiotic One Hour Before IncisionPercentage Of Surgery Patients Who Received Preventative Antibiotic One Hour Before Incision
Percentage Of Surgery Patients Whose Preventative Antibiotic Are Stopped Within 24 Hours After SurgeryPercentage Of Surgery Patients Whose Preventative Antibiotic Are Stopped Within 24 Hours After Surgery
Point Of Care Location DkPoint Of Care Location Dk
PostOp DurationPostOp Duration
Practitioner DkPractitioner Dk
Procedure Code DkProcedure Code Dk
Provider DkProvider Dk
Scheduled OR TimeScheduled OR Time
Surgery DurationSurgery Duration
Unscheduled OR TimeUnscheduled OR Time

Relationship
Operating Room Performance Analysis_Patient Dimension_FKOperating Room Performance Analysis_Patient Dimension_FK
Operating Room Performance Analysis_Practitioner Dimension_FKOperating Room Performance Analysis_Practitioner Dimension_FK
Operating Room Performance Analysis_Point Of Care Location Dimension_FKOperating Room Performance Analysis_Point Of Care Location Dimension_FK
Operating Room Performance Analysis_Diagnosis Dimension_FKOperating Room Performance Analysis_Diagnosis Dimension_FK
Operating Room Performance Analysis_Procedure Dimension_FKOperating Room Performance Analysis_Procedure Dimension_FK
Operating Room Performance Analysis_Calendar Dimension_FKOperating Room Performance Analysis_Calendar Dimension_FK
Operating Room Performance Analysis_Encounter Dimension_FKOperating Room Performance Analysis_Encounter Dimension_FK
Operating Room Performance Analysis_Provider Dimension_FKOperating Room Performance Analysis_Provider Dimension_FK

Primary Key
Operating Room Performance Analysis PKOperating Room Performance Analysis PK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Average Duration Between Final Wound Closure And Patient OR Exit
DescriptionThe average time interval (in minutes) between the final wound closure time for surgical procedures and the patient leaving the Operating Room.

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



 Average Duration Between Patient OR Arrival And First Incision
DescriptionThe average time in minutes between when a patient arrives in the Operating Room and when the first surgical incision is made.

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



 Average Duration Between Patient Ready And OR Arrival
DescriptionThe average time in minutes between when a surgery patient is ready for movement into the Operating Room and when they actually arrive into OR.

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



 Average Duration Between Patient Scheduled Time And Actual Arrival
DescriptionThe average time in minutes between when a patient arrival was scheduled and when they actually arrive for surgery in the holding bay.


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



 Average Duration Of Surgery Procedure
DescriptionThe average time interval (in minutes) between the first wound incision and the final wound closure time for surgical procedures.

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



 Average Number Of Practitioners Per Surgery Case
DescriptionThe average number of practitioners involved in surgery cases. This would typically include lead surgeon, assisting surgeon, anesthesiologist, OR nurses and so forth.

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



 Average OR Turnaround Time
DescriptionThe average time interval (in minutes) between one patient leaving the Operating Room and the next patient arriving in the OR. This is the time interval to prepare the OR for the next surgery.

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



 Average PACU Duration
DescriptionThe average time spent in Post Anesthesia Care Unit (PACU). This is the time interval (in minutes) between patient leaving the operating room and leaving the post anesthesia care unit (PACU).

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



 Average PostOp Duration
DescriptionThe average time spent in the Post Operative area. This is the time interval (in minutes) between the patient leaving the post anesthesia care unit (PACU) until they leave PostOp.

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



 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



 Diagnosis Code 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



 Duration Between Final Closure And Patient OR Exit
DescriptionThe time interval in minutes between the the final wound closure time for surgical procedures and the patient leaving the Operating Room.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Duration Between Patient OR Arrival And First Incision
DescriptionThe time interval in minutes between when a surgery patient arrives in the Operating Room and when the first surgical incision is made.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Duration Between Patient Ready And OR Arrival
DescriptionThe time interval in minutes between when a surgery patient is ready for movement into the operating room and when they actually arrive into OR.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Duration Between Patient Scheduled Time And Actual Arrival
DescriptionThe time interval in minutes between a patient's scheduled arrival time and when they actually arrive for surgery in holding bay.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Encounter 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 Canceled Surgery Cases
DescriptionThe total number of surgeries scheduled in advance but has been canceled within 24 hours of the surgery time.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Deferred Surgery Cases
DescriptionThe total number of surgery cases which are postponed indefinitely, the surgical case goes ahead at a later date and time.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Emergency Surgery Cases
DescriptionThe number of emergency surgical cases. An emergency surgery case is unscheduled, unplanned and is in response to an acute patient condition.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of First Surgery Cases Started On Or Before Scheduled Time
DescriptionThe number of first scheduled surgery cases of the day where the surgery started on or before the scheduled time. The on-time start for the first scheduled surgery of the day is very important for operating room efficiency.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Practitioners Per Surgery Case
DescriptionThe number of practitioners involved in the surgery case. This would typically include lead surgeon, assisting surgeon, anesthesiologist, OR nurse and so forth.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Scheduled Surgery Cases
DescriptionThe number of cases scheduled for surgery . A scheduled surgery also known as elective surgery does not involve a medical emergency and time is scheduled in advance.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Surgery Cases
DescriptionThe total number of surgeries (scheduled and emergency) within the period of analysis.


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



 Number Of Surgery Patients Who Received Preventative Antibiotic One Hour Before Incision
DescriptionThe number of surgery patients who are administered an antibiotic within one hour before surgery to reduce the risk of wound infections.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Number Of Surgery Patients Whose Preventative Antibiotic Are Stopped Within 24 Hours After Surgery
DescriptionIt is important for hospitals to stop giving preventative antibiotics within 24 hours after surgery to avoid side effects and other problems associated with antibiotic use. For certain surgeries, however, antibiotics may be needed for a longer time. This measures the number of surgery patients whose antibiotic medication is discontinued within 24 hours, as appropriate for the condition.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 OR Time Utilized For Surgery Cases
DescriptionThe total actual time (in minutes) the Operating Room is being used for surgery cases. The measue is the sum of minutes from when a patient is ready for surgery to the patient OR exit time for all the surgical cases within the period of analysis.

Formula: [(A+B+C+D)]
(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



 OR Turnaround Time
DescriptionThe time interval in minutes between one patient leaving the Operating Room and the next patient arriving in OR. This is the time interval to prepare the OR for the next surgery.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 PACU Duration
DescriptionThe time a patient spends in Post Anesthesia Care Unit (PACU). This is the time interval in minutes between a patient leaving the Operating Room and leaving post anesthesia care unit (PACU).
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 Canceled Surgery Cases
DescriptionPercentage of scheduled cases which has been canceled within 24 hours of the scheduled surgery time.


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 Deferred Surgery Cases
DescriptionThe Percentage of surgery cases which are postponed indefinitely, the surgical case goes ahead at a later date and time.


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 Emergency Surgery Cases
DescriptionPercentage of emergency surgical cases.The emergency surgery case is unscheduled, unplanned and is in response to an acute patient condition.


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 First Surgery Cases on Time
DescriptionThe percentage of days' first scheduled surgery cases where the surgery started on or before the scheduled time. The on-time start for the first scheduled surgery of the day is very important for operating room efficiency.


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 OR Utilization for Available Time
DescriptionThe percentage of available Operating Room time utilized by surgical cases.


Formula: [(A/(B+C)) * 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 OR Utilization for Scheduled Time
DescriptionThe percentage of scheduled Operating Room time utilized by surgical cases.

For example: An OR has been scheduled for surgeries from 9:00 to 12:00 and 13:00 to 17:00 hrs. So the total Scheduled time for OR is 7 hours. The total surgery case time is the Time between Patient Entering OR and Leaving OR + the OR turn around Time and it comes to 6 hours.
The Utilization is (6/7 * 100) = 85.7 %. This means that the OR is under utilized.


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 Scheduled Surgery Cases
DescriptionPercentage of surgical cases scheduled for surgery . A scheduled surgery also known as elective surgery does not involve a medical emergency and time is scheduled in advance.


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 Surgery Patients Who Received Preventative Antibiotic One Hour Before Incision
DescriptionThe percentage of surgery patient who are administered an antibiotic within one hour before surgery to reduce the risk of wound infections.

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 Surgery Patients Whose Preventative Antibiotic Are Stopped Within 24 Hours After Surgery
DescriptionThe percentage of surgery patients whose antibiotic medication is discontinued within 24 hours, as appropriate for the condition. It is important for hospitals to stop giving preventative antibiotics within 24 hours after surgery to avoid side effects and other problems associated with antibiotic use. For certain surgeries, however, antibiotics may be needed for a longer time.

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



 PostOp Duration
DescriptionThe time a patient spends in the Post Operative area. This is the time interval in minutes between a patient leaving the post anesthesia care unit (PACU) until they Leave PostOp.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
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



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



 Scheduled OR Time
DescriptionThe total time booked for the Operating Room for all the surgery cases within the period of analysis.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Surgery Duration
DescriptionThe time interval in minutes between the time of the first surgical incision and the final wound closure time for surgical procedures.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Unscheduled OR Time
DescriptionThe total time the Operating Room is available and it is not scheduled for any surgeries 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

Relationship Details

 Operating Room Performance Analysis_Patient Dimension_FK
Is Identifying Relationshiptrue
Child TableOperating Room 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



 Operating Room Performance Analysis_Practitioner Dimension_FK
Is Identifying Relationshiptrue
Child TableOperating Room 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



 Operating Room Performance Analysis_Point Of Care Location Dimension_FK
Is Identifying Relationshiptrue
Child TableOperating Room 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



 Operating Room Performance Analysis_Diagnosis Dimension_FK
Is Identifying Relationshiptrue
Child TableOperating Room Performance Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableDiagnosis Code Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Operating Room Performance Analysis_Procedure Dimension_FK
Is Identifying Relationshiptrue
Child TableOperating Room Performance Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableProcedure Code Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Operating Room Performance Analysis_Calendar Dimension_FK
Is Identifying Relationshiptrue
Child TableOperating Room 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



 Operating Room Performance Analysis_Encounter Dimension_FK
Is Identifying Relationshiptrue
Child TableOperating Room Performance Analysis
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableEncounter Dimension
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Operating Room Performance Analysis_Provider Dimension_FK
Is Identifying Relationshiptrue
Child TableOperating Room 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

Primary Key Details

 Operating Room Performance Analysis PK
Key AttributePatient Dk
Key AttributePractitioner Dk
Key AttributePoint Of Care Location Dk
Key AttributeProvider Dk
Key AttributeDiagnosis Code Dk
Key AttributeProcedure Code Dk
Key AttributeCalendar Dk
Key AttributeEncounter Dk