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

A general overview of the clinical data warehouse at Emory can be found here  

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