Research Data Services

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. Reference OHDSI’s data dictionary for OMOP Common Data Model.

Scientific Computing partners with researchers to advance scientific discovery. While many utilize the custom MSDW queries to analyze patient data and the self-service query tools to access MSDW data on their own, many researchers also utilize services for independent data collection, capture, and analysis. Compare these research services:



  Custom Queries eRAP REDCap
Description Work with MSDW analysts to compose custom SQL queries for research or QA.  See our 10-Step process. A web-based interactive tool for data entry and reporting. Custom databases are rapidly developed for your longitudinal single and multi-site studies. A secure web application for building and managing online surveys and databases. Track data manipulation, user activity, export procedures, scheduling, calendaring, and branching logic.
Security PHI data is available only through approved IRB/QI documentation; MSDW is HIPAA compliant 21 CFR Part 11 compliant; HIPAA Compliant HIPAA Compliant
Unique Capabilities Most comprehensive and sophisticated way to search the largest database at Mount Sinai Database is customized specifically to your research project(s) and accessible to your team, including external collaborators Complete control over the design and specification of surveys and information
Included Features   Reporting tools, randomization engine, file upload, data upload, integrated with other Mount Sinai health systems, including Epic, Specimen Management Systems (Freezerworks, IMP LIMS), and SCC Labs Audit trails for tracking data manipulation and user activity; automated export procedures for seamless data downloads to Excel, PDF, and common statistical packages (SPSS, SAS, Stata, R);  built-in project calendar, a scheduling module, ad hoc reporting tools, and advanced features, such as branching logic, file uploading, and calculated fields
Limitations De-identified data is produced except with approved IRB/QI documentation Requires consultation meetings and detailed requirements up front to build a custom database to user specifications Best utilized for survey responses and scheduling
Cost $180/hour $140/hour

$200 database production fee per year

$140/hour consulting fee/project-specific services or development

Free to sign up and use and ask general questions

Support MSDW Service Desk eRAP Service Desk REDCap Service Desk
More Information About MSDW Data Frequently Asked eRAP Questions REDCap User Training Videos