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 Visit

 diagnosis and diagnosis code for a particular visit

MRN

Medical record number which is a unique identifier for an individual patient. MRNs will appear in multiple rows of this table, signifying that this patient has multiple diagnoses listed in their EMR.

LOG_ID

LOG_ID is the identification number for a single patient encounter.

diagnosis_code, dx_name

diagnosis_code is the International Classification of Diseases, Ninth Revision, Clinical Modification (ICD-9-CM) codes for each patient diagnosis available in their EMR and dx_name is the name of the corresponding diagnosis