EPIC DATASET TABLES
Patient Information  Patient History Patient Visit  Patient Procedure Events  Patient Medications Patient Labs Patient LDA Patient Measurements  Patient Postoperative Complications  Patient Coding
SIS DATASET TABLES
Patient Information  Patient Medications Patient Labs Patient I/O Patient Vitals Patient Observations Patient Ventilator Patient A-line Patient Procedure Events 

Patient Information

 patient demographic information including: age, sex, height, and weight; information regarding the surgery being performed including: the type of surgery, the start and end time of both the surgery and anesthesia, ASA status, and discharge disposition.

MRN

Medical record number which is a unique identifier for an individual patient.

LOG_ID

Each row of this table contains a unique LOG_ID, which represents a single patient encounter. It is possible for this table to have duplicate MRNs, indicating that a single patient has come in for multiple surgeries.

BIRTH_DATE, HEIGHT, WEIGHT, SEX

BIRTH_DATE gives the patient age in years, HEIGHT gives the patient height in ft and inches, WEIGHT gives the patient weight in grams (for SIS dataset) or ounces (for EPIC dataset), and sex gives the genotypical sex of the patient.
 

ASA_RATING_C, ASA_RATING

ASA_RATING_C gives the ASA Physical Status Class 1-6 for each patient and the ASA_RATING provides the name for each class. 
 

HOSP_ADMSN_TIME, HOSP_DISCH_TIME, LOS 

HOSP_ADMSN_TIME provides the date and time the patient was admitted to the hospital, HOSP_DISCH_TIME provides the date and time the patient was discharged from the hospital, and LOS provides the length of stay in the hospital in days. 

DISCH_DISP_C, DISCH_DISP 

DISCH_DISP_C represents a class 1-100 representing a patients discharge disposition. These classes correlate with the name for each discharge disposition which can be found in DISCH_DISP.

SURGERY_DATE

SURGERY_DATE provides the date on which the patient underwent a surgical procedure.
 

PRIMARY_PROCEDURE_NM

PRIMARY_PROCEDURE_NM indicates the name of the surgical procedure a patient is scheduled to undergo.
 

IN_OR_DTTM, OUT_OR_DTTM

IN_OR_DTTM provides the date and time the patient went into the OR and the procedure was started, and OUT_OR_DTTM provides the date and time the patient left the OR when the procedure was completed.
 

AN_START_DATETIME, AN_STOP_DATETIME

AN_START_DATETIME represents the date and time at which anesthesia was started and AN_STOP_DATETIME represents the date and time at which anesthesia was stopped.  

ICU_ADMIN

ICU_ADMIN displays whether or not a patient was admitted to the ICU during their visit.

PRIMARY_ANES_TYPE_NM

PRIMARY_ANES_TYPE_NM is the primary type of anesthesia a patient received. (ex: general, MAC, etc)

PATIENT_CLASS_GROUP, PATIENT_CLASS_NM

PATIENT_CLASS_GROUP specifies whether an encounter was inpatient or outpatient and PATIENT_CLASS_NM provides more detail.