Business Data Model Data Model

Entity

Entity Surgery Case

Description

A surgical procedure that is completed by a surgical team. A surgical case can include one or more surgical procedures.

Attributes
Anesthesia Administered Type
Anesthesia Administration End Ts
Anesthesia Administration Start Ts
ASA Score
Blood Glucose Level Ratio
Case Phase
Case Phase Ts
Case Status
Core Body Temperature Num
Emergency Case Ind
Endoscopy Case Ind
Estimated Blood Loss Qty
Estimated Blood Loss Quantity Unit Of Measure
Hair Removal Method
Initial Incision Ts
Instrument Flash Sterilized Ind
Latest Closure Ts
Maternal Labor Duration Qty
Maternal Labor Duration Quantity Unit Of Measure
Outpatient Case Ind
Patient Arrival Ts
Patient Diabetes Ind
Patient Existing Implant Ind
Patient Height Qty
Patient Height Unit Of Measure
Patient Nutrition Status
Patient OR Arrival Ts
Patient OR Exit Ts
Patient PACU Arrival Ts
Patient PACU Exit Ts
Patient Post Op Exit Ts
Patient Ready Ts
Patient Spinal Level
Patient Steroid Use Ind
Patient Tobacco Use Ind
Patient Weight Qty
Patient Weight Quantity Unit Of Measure
Pre-admit Testing Ind
Preventative Antibiotic One Hour Before Incision Indicator
Preventative Antibiotic Stopped Within 24 Hours Indicator
Scheduled OR Arrival Ts
Scheduled Procedure Code
Skin Preparation Agent
Skin Preparation Duration Minute Qty
Surgery Case Id
Surgery Principal Diagnosis
Surgery Time Out Start Ts
Surgery Time Out Taken Ind
Surgery Type
Surgical Approach Technique
Transplant Method
Trauma Case Ind
Urinary Catheter On Arrival Ind
Wound Debridement Ind
Wound Dehiscence Ind

Relationship
Surgery Case_Encounter_FK
Surgery Case_Patient_FK
Surgery Case_Plan Member_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Anesthesia Administered Type

Description	Identifies the anesthesia used during surgery. For example: Local anesthetic Spinal anesthetic Epidural anesthetic General anesthetic
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Anesthesia Administration End Ts

Description	The date and time the anesthesia administration is finished for the patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Anesthesia Administration Start Ts

Description	The date and time the anesthesia administration commences for the patient. This is usually conducted by a member of the anesthetic team.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

ASA Score

Description	The ASA Score indicates a person's physical status in preparation for surgery. The scoring system was adopted by the American Society of Anesthesiologists (ASA) and it classifies people on a 6 point scale as follows: 1 A normal healthy patient. 2 A patient with mild systemic disease. 3 A patient with severe systemic disease. 4 A patient with severe systemic disease that is a constant threat to life. 5 A moribund patient who is not expected to survive without the operation. 6 A declared brain-dead patient whose organs are being removed for donor purposes.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Blood Glucose Level Ratio

Description	The level of glucose measured in the surgery patient's blood.
Data Type	Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Case Phase

Description	Indicates the current phase of the patient surgery workflow. For example: Pre Operative Holding Bay Anesthesia Incision Open Incision Close PACU Post Operative
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Case Phase Ts

Description	Indicates a date and time that a patient's surgery workflow status becomes true. For example: Holding Bay arrival at YYYY/D/MM Into Anesthesia at YYYY/D/MM Into Operating Room at YYYY/D/MM Out of Operating Room at YYYY/D/MM
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Case Status

Description	Indicates the status of the patient in the surgery workflow. For example: Arrived Prepped Enter Incision Close Out of OR PACU Enter PACU Leave Out of Recovery
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Core Body Temperature Num

Description	The measured core body temperature of the patient during the surgery.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Very Small [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Emergency Case Ind

Description	Indicates if the surgery was an Emergency Case.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Endoscopy Case Ind

Description	Indicates if the surgery was an endoscopy case.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Estimated Blood Loss Qty

Description	The estimated amount of blood loss during the surgery.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Float [FLOAT(5)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Estimated Blood Loss Quantity Unit Of Measure

Description	The unit of measure in which estimated blood loss is expressed.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Hair Removal Method

Description	The method used to remove body hair as part of surgical site preparation. For example: Clipping Electric razor Wet shave Hair removal cream
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Initial Incision Ts

Description	The date and time for the initial incision on the patient in this surgical case.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Instrument Flash Sterilized Ind

Description	Indicates if surgical instruments were flash sterilized.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Latest Closure Ts

Description	The date and time of the latest wound closure on the patient in this case.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Maternal Labor Duration Qty

Description	The amount of time a patient was in maternal labor.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Maternal Labor Duration Quantity Unit Of Measure

Description	Identifies the unit of measure in which duration of maternal labor is expressed. For example: Hours Minutes
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Outpatient Case Ind

Description	An indicator that shows whether the case is an outpatient case or not.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Arrival Ts

Description	The date and time when a patient arrives into pre-op.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Diabetes Ind

Description	Indicates if a surgical patient has a diagnosis of diabetes.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Existing Implant Ind

Description	Indicates if the surgical patient has an existing implant. For example: Pacemaker Right Hip Replacement Pelvic Plates
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Height Qty

Description	The height of the patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Height Unit Of Measure

Description	Unit of measure for height of the patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Nutrition Status

Description	Describes the patient's nutrition status. For example: Malnourished Obese Overweight
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient OR Arrival Ts

Description	The date and time when a patient arrives in the operating room.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient OR Exit Ts

Description	The date and time when a patient leaves the operating room and enters the post-anesthesia care unit.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient PACU Arrival Ts

Description	The date and time a patient enters the post-anesthesia care unit.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient PACU Exit Ts

Description	The date and time the patient leaves the post-anesthesia care unit.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Post Op Exit Ts

Description	The date and time a patient leaves or is transferred out of the post-op room.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Ready Ts

Description	The date and time when a patient is deemed ready for surgery.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Spinal Level

Description	Specifies the vertebral location associated with the patient's surgery. For example: Cervical Vertebrae Thoracic Vertebrae Lumbar Vertebrae
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Steroid Use Ind

Description	Indicates that a patient uses steroids.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Tobacco Use Ind

Description	Indicates that the patient is a smoker.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Weight Qty

Description	The weight of the patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Weight Quantity Unit Of Measure

Description	Unit of measure for weight of the patient.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pre-admit Testing Ind

Description	An indicator that shows whether pre-admission testing was performed for the patient. For example: Full Blood Count Electrocardiogram X-ray Chest Coagulation Screen
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Preventative Antibiotic One Hour Before Incision Indicator

Description	Indicates if the patient received an antibiotic within one hour before surgery to reduce the risk of wound infections.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Preventative Antibiotic Stopped Within 24 Hours Indicator

Description	An indicator that shows whether a patient's preventive antibiotics were stopped within 24 hours after surgery to avoid side effects and other problems associated with antibiotic use.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Scheduled OR Arrival Ts

Description	The date and time when a patient is scheduled to arrive into the operating room.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Scheduled Procedure Code

Description	Procedure code of the surgery scheduled to be performed.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Skin Preparation Agent

Description	Specifies the type of agent that is used to prepare the skin at the surgery site. Example: Betadine
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Skin Preparation Duration Minute Qty

Description	The number of minutes that were spent on the preparation of the patient's skin before surgery.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Surgery Case Id

Description	Alphanumeric identifier for the Surgery Case.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Surgery Principal Diagnosis

Description	The diagnosis representing the condition that is considered the primary reason for the surgical case. For example: Coronary Heart Disease may be the principal diagnosis for a patient's Coronary Artery Bypass Graft.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Surgery Time Out Start Ts

Description	The date and time when the time-out is taken before the first incision. The time-out ensures the correct patient, procedure and site have been confirmed before the first skin incision. Each surgical team member introduces themselves by name and role. The team pauses immediately before the skin incision to confirm out loud that they are performing the correct operation on the correct patient and site and then verbally review with one another.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Surgery Time Out Taken Ind

Description	An indicator that shows whether a time-out was taken before the first incision. The time-out ensures the correct patient, procedure and site have been confirmed before the first skin incision. Each surgical team member introduce themselves by name and role. The team pause immediately before the skin incision to confirm out loud that they are performing the correct operation on the correct patient and site and then verbally review with one another.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Surgery Type

Description	Surgery Type classifies or categorizes surgical cases by their nature. For example: Coronary Artery Bypass Graft can be classified as heart surgery Appendectomy can be classified as gastrointestinal surgery.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Surgical Approach Technique

Description	Specifies the surgical approach technique. For example: Open Surgery Laparoscopic Surgery
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Transplant Method

Description	Specifies the technique used for transplant surgery.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Trauma Case Ind

Description	Indicates if the surgery was a Trauma Case.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Urinary Catheter On Arrival Ind

Description	Indicates if the patient has a urinary catheter in situ on arrival to the operating room.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Wound Debridement Ind

Description	Indicates if all non-healthy tissue was removed from the area of the surgical wound to assist healing.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Wound Dehiscence Ind

Description	Indicates if a closed surgical wound ruptured, tore or otherwise reopened.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Surgery Case_Encounter_FK

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

Surgery Case_Patient_FK

Is Identifying Relationship	false
Child Table	Surgery Case
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
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Surgery Case_Plan Member_FK

Is Identifying Relationship	false
Child Table	Surgery Case
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	Plan Member
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Overview

Top

Package

Entity

Business Data Model Data Model