EPIC - This document provides a step-by-step documentation including SQL scripts and python procedures to extract ONC standard datasets from Epic and load an i2b2 data warehouse. https://datahandbook.epic.com/Reports/Details/9000400 (Need to be a EPIC customer to view)
AllScripts - Data Schema https://developer.allscripts.com/Account/Login?ReturnUrl=%2fDownloads#clientkits (Need to be a All Scripts customer to view)
| TABLES | PRIMARY KEYS |
|---|---|
| DEMOGRAPHICS | IMREDEM_CODE |
| SCHEDULE | IMRESCHED_CODE |
| ENCOUNTER | IMREENC_CODE |
| CONTACT | IMRECONTACT_CODE |
| IMMUNIZATION_RECORD | IMMREC_ID |
| LABORDERS | IMRELABORDER_CODE |
| MEDICATIONS | IMREMED_CODE |
| PROVIDER | IMREPROV_CODE |
| RESULT | RESULT_ID |
| VITALS_DATA | VITALS_CODE |
| DX | IMREDX_CODE |
| HX_DIAGNOSIS | HX_DIAGNOSIS_ID |
Common Patient Tables
• HPSITE.DEMOGRAPHICS – Name, DOB, SSN, Bloodtype, Language, Marital Status
• HPSITE.ADDRESSES – holdsaddressesfor5typesofentities
• Patient, Provider, Site, Insurance Carriers, Institutions
• HPSITE.INSURANCES – containsinsuranceinformationforthepatient
• HPSITE.DEMOGRAPHICPICTURE ― link to picture in the EHR that is associated with the patient
• HPSITE.PHARMACYFAVORITE ― Containsprimarypharmacyinformation
• HPSITE.DEMGUARANTOR ― contains patient guarantor information
