The Mount Sinai Data Warehouse (MSDW) collects clinical and operational data for use in clinical and translational research, as well as quality improvement initiatives. The majority of the data provided by the MSDW comes from the Epic (Verona, WI) electronic health record (EHR), which is the primary EHR for the Mount Sinai Health System (MSHS). Epic was implemented as the inpatient EHR at Mount Sinai Hospital (MSH) in late 2011. Subsequently, Epic has been implemented in additional inpatient facilities across the MSHS, including Mount Sinai Queens (2013), Mount Sinai West (2018), Mount Sinai St. Lukes (2018), Mount Sinai Brooklyn (2019) and Mount Sinai Beth Israel (2020).
The MSDW provides researchers access to data on the over 12 million unique patients in the Mount Sinai Health System Epic EHR, of which nearly 5.5 million of these patients have had an encounter. In total there are over 115 million patient encounters recorded in Epic.
The Mount Sinai Data Warehouse (MSDW) ecosystem is Epic and OMOP-centric. The majority of the data collected by the MSDW comes from the Epic Clarity and Caboodle databases, as Epic is the primary electronic health record (EHR) across the Mount Sinai Health System (MSHS). The clinical data is extracted from the Epic Caboodle and Clarity databases, transformed to the OMOP Common Data Model (CDM) and is stored in the MSDW2 database, which is now located on the Minerva High Performance Computing cluster. This data is refreshed daily.
Data Sources
| OMOP Table | EHR Record Type |
| person | Patient Demographics |
| death | Patient Date of Death |
| provider | Provider |
| provider_specialty_xtn* | Provider Specialty |
| care_site | Care Site/Place of Service |
| location | Patient Address |
| Provider Address | |
| Care Site Address | |
| visit_occurrence | Inpatient Hospitalization |
| Hospital Outpatient Visit | |
| Inpatient Hospitalization from ED Visit | |
| ED Visit | |
| Outpatient Visit | |
| Telehealth Visit | |
| Mobile Unit Encounter | |
| measurement | Lab Component Result |
| Vital Signs | |
| procedure_occurrence | General Procedure |
| Surgical Procedure | |
| condition_occurrence | Encounter Diagnosis |
| Problem List | |
| Hospital Problem | |
| Billing Diagnosis | |
| drug_exposure | Medication Order |
| Medication Order with Dispense | |
| Outpatient Medication Order with Dispense | |
| Medication Order with Administration | |
| Immunization Administration | |
| Immunization from Medication Order | |
| Immunization from Procedure Order | |
| observation | Patient Demographics |
| Allergy | |
| Past Medical History | |
| Surgical History Procedure | |
| Social History | |
| Family History | |
| note | Clinical Note |
| Lab Component Result Note |