| Dimensional Warehouse Model Data Model |
| Description | Analysis 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 |
| Primary Key | |
Operating Room Performance Analysis PK |
|
| Dependencies | |
NONE |
|
| Reverse Dependencies | |
|
|
| Attribute Details |
Average Duration Between Final Wound Closure And Patient OR Exit
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Average Duration Between Patient OR Arrival And First Incision
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
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 and when they actually arrive into OR. 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 |
Average Duration Between Patient Scheduled Time And Actual Arrival
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Average Duration Of Surgery Procedure
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Average Number Of Practitioners Per Surgery Case
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Average OR Turnaround Time
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Average PACU Duration
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Average PostOp Duration
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Count [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 Final Closure And Patient OR Exit
| Description | The time interval in minutes between the the final wound closure time for surgical procedures and the patient leaving the 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 Between Patient OR Arrival And First Incision
| Description | The time interval in minutes between when a surgery patient arrives in the Operating Room and when the first surgical incision is made. |
| 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 Between Patient Ready And OR Arrival
| Description | The 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 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 Between Patient Scheduled Time And Actual Arrival
| Description | The time interval in minutes between a patient's scheduled arrival time and when they actually arrive for surgery in holding bay. |
| 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 |
Number Of Canceled Surgery Cases
| Description | The total number of surgeries scheduled in advance but has been canceled within 24 hours of the surgery time. |
| 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 Deferred Surgery Cases
| Description | The total number of surgery cases which are postponed indefinitely, the surgical case goes ahead at a later date and time. |
| 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 Emergency Surgery Cases
| Description | The number of emergency surgical cases. An emergency surgery case is unscheduled, unplanned and is in response to an acute patient condition. |
| 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 First Surgery Cases Started On Or Before Scheduled Time
| Description | The 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 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 Per Surgery Case
| Description | The number of practitioners involved in the surgery case. This would typically include lead surgeon, assisting surgeon, anesthesiologist, OR 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 Scheduled Surgery Cases
| Description | The 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 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 | The 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 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 Patients Who Received Preventative Antibiotic One Hour Before Incision
| Description | The number of surgery patients who are administered an antibiotic within one hour before surgery to reduce the risk of wound infections. |
| 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 Patients Whose Preventative Antibiotic Are Stopped Within 24 Hours After Surgery
| Description | 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. This measures the number of surgery patients whose antibiotic medication is discontinued within 24 hours, as appropriate for the condition. |
| 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 |
OR Time Utilized For Surgery Cases
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
OR Turnaround Time
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
PACU Duration
| Description | The 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 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 Canceled Surgery Cases
| Description | Percentage 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 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 Deferred Surgery Cases
| Description | The 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 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 Emergency Surgery Cases
| Description | Percentage 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 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 First Surgery Cases on Time
| Description | The 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 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 OR Utilization for Available Time
| Description | The 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 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 OR Utilization for Scheduled Time
| Description | The 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 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 Scheduled Surgery Cases
| Description | Percentage 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 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 Surgery Patients Who Received Preventative Antibiotic One Hour Before Incision
| Description | The 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 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 Surgery Patients Whose Preventative Antibiotic Are Stopped Within 24 Hours After Surgery
| Description | The 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 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 |
PostOp Duration
| Description | The 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 Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| 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 OR Time
| Description | The total time booked for the Operating Room for all the surgery cases within the 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 |
Surgery Duration
| Description | The time interval in minutes between the time of the first surgical incision and the final wound closure time for surgical procedures. |
| 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 |
Unscheduled OR Time
| Description | The total time the Operating Room is available and it is not scheduled for any surgeries 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 |
| Relationship Details |
Operating Room Performance Analysis_Patient Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Operating Room 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 |
Operating Room Performance Analysis_Practitioner Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Operating Room 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 |
Operating Room Performance Analysis_Point Of Care Location Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Operating Room 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 |
Operating Room Performance Analysis_Diagnosis Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Operating Room 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 | Diagnosis Code Dimension |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Operating Room Performance Analysis_Procedure Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Operating Room 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 | Procedure Code Dimension |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Operating Room Performance Analysis_Calendar Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Operating Room 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 |
Operating Room Performance Analysis_Encounter Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Operating Room 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 | Encounter Dimension |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Operating Room Performance Analysis_Provider Dimension_FK
| Is Identifying Relationship | true |
| Child Table | Operating Room 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 |
| Primary Key Details |
Operating Room Performance Analysis PK
| Key Attribute | Patient Dk |
| Key Attribute | Practitioner Dk |
| Key Attribute | Point Of Care Location Dk |
| Key Attribute | Provider Dk |
| Key Attribute | Diagnosis Code Dk |
| Key Attribute | Procedure Code Dk |
| Key Attribute | Calendar Dk |
| Key Attribute | Encounter Dk |
| Dimensional Warehouse Model Data Model |