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 History

 patient’s health history including all patient diagnoses available in the EHR

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.

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