Page History
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 |
