|
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. |