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
Nextgen - Two Presentations on the data schema