| Research Data Services |
|
Scientific Computing and Data 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 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 |