Emory Healthcare Clinical Data Warehouse
The Clinical Data Warehouse (CDW) is a repository that integrates data from multiple business and clinical applications within Emory Healthcare and some external benchmarking databases – providing data needed for clinical quality reporting, research and operational decision-making support. More than 500 users employ the CDW to collectively run more than 40,000 reports monthly, drill down into the data, create ad-hoc queries and graphs, and export the information. The primary goal of the CDW is to provide standardized metrics, filters and reports to ensure that results are consistent over time, among users and across the enterprise. Flexibility to create customized, research-specific metrics is available as well. Access to this data is important for:
- Clinical, financial, administration and research analysis
- Improving quality of patient care, outcomes and satisfaction
- Supporting regulatory requirements
- Research innovation
Training for CDW Use
Training is available for individuals with direct access to the CDW. Training includes a one-day introductory training course, conducted every four to six weeks. The course is focused on:
- What is the CDW?
- High-level overview of available data
- How to use the MicroStrategy reporting application to create/modify reports
Clinical Data Warehouse Overview
Analytics Resource Center (ARC)
The Analytics Resource Center website is a central hub of information on data and analytics at Emory Healthcare. The site provides data analysts with a data map, system inventory, how-to guides, as well as upcoming networking events.
Active User Community
Emory Healthcare’s large CDW user community interacts through a popular discussion listserv and various events.
CDW Data Sources
The data available within the CDW includes patient billing and collections, general ledger and budget information, patient visit data, provider information, diagnoses and procedures, clinical laboratory results, clinician documentation, pharmacy, and emergency department utilization and details.
Below is a summary of the subject areas available within the CDW as of March 2015:
Information | Description | Source |
|---|---|---|
Patient and Provider | Patient, Provider and Location | EeMR, HealthQuest, IDX, Centricity Business |
Hospital Visits, Readmissions, Providers, Locations | HealthQuest | |
Clinic Visits, Providers, Locations | IDX, Centricity Business | |
Diagnoses, Procedures | Billing Diagnoses and Procedures (ICD and CPT) | HealthQuest, IDX, Centricity Business, Meta |
Problem List | EeMR | |
Patient Financial Data | Hospital and Clinic Billings, Payments, Payors, RVUs | HealthQuest, IDX, Centricity Business |
Laboratory | Chemistry, Microbiology | PathNet |
Anatomic Pathology | PathNet, CoPath | |
Medications | Prescriptions, Inpatient Orders, EMAR, Inpatient dispensing, Immunizations | EeMR |
Scheduling | Outpatient Appointment and Resource Scheduling | IDX, Centricity Business |
Emergency Data | Emergency Department Visits, Procedures, Events, Timing | EeMR |
Clinical Documentation | PowerForms Structured Documents | EeMR |
Direct Charting, IView, Medication Reconciliation | EeMR | |
PowerNotes Physician Notes | EeMR | |
Allergies | EeMR | |
Orders Management | Online Orders | EeMR |
Detailed Turnaround Timing | EeMR | |
Radiology | Radiology Reports, Room Utilization | EeMR |
External Quality Metrics | Risk metrics, core measures | UHC |
Cost | Encounter-level costs | EPSi |
Surgery | Surginet, Anesthesia modules | EeMR |