Epic Data

 

Epic Data
Epic data includes MSH (2011) and MSQ (2013) hospital data, and select clinics’ data, going back to 2008. Contains visit details and timestamped events, documentation from providers and nurses, provider orders and nursing administration, vital signs and flowsheets.
Custom Queries & Reports Reporting Workbench Slicer Dicer (beta)
Description Work with Epic Reporting analysts to compose custom SQL queries for research or QA. Epic’s built-in tool for returning visits that meet user-specified criteria. Hundreds of canned reports exist, and users can modify by searching & adding new desired fields Experimental new Epic tool to quickly estimate patients that meet desired characteristics
Access Access to canned “on demand” reports; customized reports will be prioritized Generally available, varies by department and user credentials Private beta
Training Access to canned “on demand” reports; customized reports will be prioritized Generally available, varies by department and user credentials Private beta
Data Types Visit details, timestamped events, notes and clinician actions, orders and results, flowsheets for vital signs and other patient measurements. Visit-level data on facilities with throughput timestamps, treatment team members, diagnoses. Can return orders, flowsheet data including vitals, and lab results Patient-level data on diagnoses, demographics, medications, with some capacity for facilities, visit dates, procedures
PHI Yes Always Aggregated and de-identified, but exportable to Reporting Workbench
Cost TBD Free Minutes
Turnaround Weeks to months Hours Training
Advantages/Disadv. Comprehensive and detailed queries are possible, but the work queue is considerable. Building elements of the query in Reporting Workbench may help. Good for identifying active or recent patients that meet specific criteria (sepsis, smokers, charting deficiencies, etc). Good for returning extensible results in Excel-friendly formats, for filtering. Slow when looking at more than a few weeks of data. Fast way to browse cohorts of patients based on diagnosis or facility and drill down to get details.