AHLTAs Clinical Reporting Tool

1

• AHLTAs Clinical Reporting Tool
• The Clinical Data Mart (CDM)

2
What is CDM?

• Unique reporting tool to measure, analyze and
  manage performance of direct patient care,
  wellness, prevention and disease management
• Aggregate data can be used to determine
  compliance with clinical policies and trends in
  population health
• Reports AHLTA demographic, symptomatic, and
  diagnostic data
• Users create clinical ad hoc reports or
  predefined queries

3
Who Benefits from CDM?

• Providers
• Clinic administrators
• Clinical support staff
• Population health experts
• Data analysts
• Researchers

4
CDM Data Classes

• Allergies
• Vital signs
• Health history information
• Lab, radiology and pharmacy orders
• Body mass index
• Immunizations
• Consults
• Problem History
• Operational readiness
• Historical procedures
• Clinical coding
• Medcin data

5
CDM Scope

• Data Content
• Patients 18.7M Appointments 129M Providers
  2.7M
• MTF DMIS IDS 1.8K Clinics 110K Procedures
  44M
• Diagnoses 101.5M Notes1.281M Orders
  156.5M
• Lab Results 620M Rad Results 17.4M Vitals
  34M
• Database Structure
• Data 500GB Indices 440GB Weekly
  Growth 1GB
• Tables 200 logically stored in a normalized
  entity relationship
  data model

6
CDM Capabilities

• Save and schedule queries for future data refresh
• Quickly create trending charts and graphs
• Securely share reports with other CDM users
• Export reports to Excel, comma separated Values
  (.csv) or portable document format (.pdf) for
  distribution or large data analysis studies

7

• CDM Demonstration

8
Appointment Count by Pain Scale
9
Appointment Encounter Status Report
10
Appointment Encounter Status Report
11
EM Report by Diagnosis
12
Female Patient Totals by BMI Category
13
Monthly Diabetic Disease Workload Report
14
Future Goals

• Access for non-AHLTA users
• On-going data quality review
• Data model enhancement
• Research purposes