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.
|OMOP Table||EHR Record Type|
|death||Patient Date of Death|
|care_site||Care Site/Place of Service|
|Care Site Address|
|Hospital Outpatient Visit|
|Inpatient Hospitalization from ED Visit|
|Mobile Unit Encounter|
|measurement||Lab Component Result|
|Medication Order with Dispense|
|Outpatient Medication Order with Dispense|
|Medication Order with Administration|
|Immunization from Medication Order|
|Immunization from Procedure Order|
|Past Medical History|
|Surgical History Procedure|
|Lab Component Result Note|