Atomic Warehouse Model Data Model

Entity

Entity Surgery Case Detail

Description

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

Attributes
ASA Score Code Sk
Case Phase Code Sk
Case Phase Ts
Case Status Code Sk
Effective From Dt
Effective To Dt
Initial Incision Ts
Latest Closure Ts
Load Info Sk
Outpatient Case Ind
Patient Arrival Ts
Patient OR Arrival Ts
Patient OR Exit Ts
Patient PCAU Exit Ts
Patient Post Op Exit Ts
Patient Ready Ts
Pre-Admission Testing Ind
Preventative Antibiotic One Hour Before Incision Ind
Preventative Antibiotic Stopped Within 24 Hours Ind
Principal Diagnosis Code Sk
Scheduled OR Arrival Ts
Source Code Sk
Surgery Case Id Num
Surgery Case Sk
Surgery Type Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Surgery Case Detail_Surgery Case_FK

Primary Key
Surgery Case Detail PK

Dependencies

Reverse Dependencies

Attribute Details

ASA Score Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Case Phase Code Sk

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/Surrogate Key [INTEGER]
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 Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
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

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

Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Outpatient Case Ind

Description	Indicates 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 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 OR Arrival Ts

Description	The date and time 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 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 PCAU 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 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

Pre-Admission Testing Ind

Description	Indicates whether pre-admission testing was performed for the patient. For example: Full Blood Count Electrocardiogram XRay 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 Ind

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 Ind

Description	Indicates if a patient's preventative 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

Principal Diagnosis Code Sk

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/Surrogate Key [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 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

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Surgery Case Id Num

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

Surgery Case Sk

Description	Surrogate key identifying a specific surgery case.
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

Surgery Type Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data Type	Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	false

Valid To Ts

Description	Ends a period of validity.
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

Relationship Details

Surgery Case Detail_Surgery Case_FK

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

Key Attribute	Surgery Case Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model