Data Sources

1
CDR

• Data Sources
• NCBH/WFUP Patient (Stokes-Reynolds, Hoot
  Memorial)
• Most Enterprise NCBH Systems
• Absent School Labs, Specialized/Departmental
  ancillary/support systems (CVIS, Respiratory,
  Endoscopy)
• Data Storage
• Sun Solaris UNIX OS Oracle 10 RDBMS
• Data Access
• TSI
• Information Services Decision Support, Quality
  Resource Center
• Other Departments Strategic Planning, Medical
  Records, Financial Management
• Applications

2
CDR

• Data Timing
• Extracts process real-time, daily, weekly,
  monthly, as needed
• Maturity or Completeness
• Refresh on Changes/Updates
• Data Concerns
• Quality
• Completeness
• Focus
• Combines, Merges, changes
• Dates Times
• Data Definitions Terminology
• Clinical vs. Data Systems
• Specifics
• Synonyms
• Approximations

3
CDR Data Sources

• NCBH Patient Accounting (HealthQuest)
• Data since 1988
• Visit summary
• Patient demographics
• Coded ICD9 Diagnosis
• Coded ICD9 / CPT4 Procedures
• Bed Assignments
• Physician Assignments / Roles
• Revenue / Charges
• Reimbursement
• Financial transactions
• Purpose
• Registration
• Patient Billing and Collections
• ADT
• Strengths

4
CDR Data Sources NCBH Patient Accounting
(HealthQuest)

5
CDR Data Sources NCBH Patient Accounting
(HealthQuest)

6
CDR Data Sources NCBH Patient Accounting
(HealthQuest)

7
CDR Data Sources NCBH Patient Accounting
(HealthQuest)

8
CDR Data Sources NCBH Patient Accounting
(HealthQuest)

9
CDR Data Sources NCBH Patient Accounting
(HealthQuest)

10
CDR Data Sources NCBH Patient Accounting
(HealthQuest)

11
CDR Data Sources NCBH Patient Accounting
(HealthQuest)

12
CDR Data Sources NCBH Patient Accounting
(HealthQuest)

13
CDR Data Sources NCBH Patient Accounting
(HealthQuest)

14
CDR Data Sources NCBH Patient Accounting
(HealthQuest)

15
CDR Data Sources

• WFUP Patient Accounting (Physician Billing)
  (Flowcast)
• Data since 1997
• Coded ICD9 Diagnosis
• Coded CPT4 Procedures
• Location (Clinic)
• Physician
• Revenue / Charges
• Reimbursement
• Purpose
• Clinic Department Physician Revenue
• Patient Billing and Collections
• Strengths
• Outpatient utilization and operational
  measurements
• Reimbursement analysis
• Issues

16
CDR Data Sources

• Laboratory Results (SunQuest, Copath, Medcom,
  Quest 360)
• Data since 1992
• Blood Bank
• Microbiology
• Chemistry
• Hematology
• Purpose Patient Care, Results Reporting
• Strengths Research Potential
• Issues Vendor controlled outbound interfaces
• Text Based Values (Cultures)
• Limited Operational Elements

17
CDR Data Sources - Laboratory Results
18
CDR Data Sources - Laboratory Results
19
CDR Data Sources - Laboratory Results
20
CDR Data Sources

• Inpatient EMR (CareCast aka LastWord)
• Data since 2000
• Pharmacy (drugs, doses, orders, allergies)
• Orders (chemistry, diagnostic, dietary,
  etc)
• Findings (observations, pain assessment, etc)
• Vitals (height, weight, blood pressure,
  etc)
• ED Tracking (admits, departs, staging,
  consults)
• Purpose
• Acute patient (nursing) assessment
• Orders (CPOE)
• Strengths
• RX Source
• Vitals
• Issues

21
CDR Data Sources -Inpatient EMR (CareCast)
22
CDR Data Sources -Inpatient EMR (CareCast)
23
CDR Data Sources -Inpatient EMR (CareCast)
24
CDR Data Sources -Inpatient EMR (CareCast)
25
CDR Data Sources -Inpatient EMR (CareCast)
26
CDR Data Sources

• Ambulatory EMR (Centricity aka Logician)
• Data since 1998
• Schedules
• Allergies
• Medication
• Prescriptions
• Problems
• Findings / Assessments
• Purpose
• Clinic Documentation
• Strengths
• Medications History
• Problem History
• Issues

27
CDR Data Sources Ambulatory EMR
28
CDR Data Sources Ambulatory EMR
29
CDR Data Sources Ambulatory EMR
30
CDR Data Sources Ambulatory EMR
31
CDR Data Sources

• Ancillary Results (Electronically interfaced
  systems)
• Data since 2000
• Diagnostic Neurology
• Cardiology (Echo, Cath, Treadmill)
• Endoscopy
• Radiology
• Respiratory Therapy
• Vascular Lab
• Purpose Results Reporting Documentation
• Strengths Research Potential
• Issues Text Based (Not Coded)

32
CDR Data Sources Ancillary Results
33
CDR Data Sources Ancillary Results
34
CDR Data Sources Ancillary Results
35
CDR Data Sources

• Operating Room (John Galt)
• Data since 2003
• Case summaries
• Procedures
• Personnel
• Charge Items
• Purpose
• Inventory
• Utilization
• Charges
• Strengths
• History across multiple OR systems
• Issues
• Procedure Codes not industry standard

36
CDR Data Sources Operating Room
37
CDR Data Sources Operating Room
38
CDR Data Sources

• Transcription (Noteslink, Chartscript,
  T-System)
• Data since 2002
• History and Physicals
• Operative Note
• Office Visit
• Procedure Note
• Discharge Summary
• New patient Evaluation
• Return Visits
• Letter to Doctor
• Letter to Patient
• Purpose Patient Care Documentation
• Strengths Content
• Issues Text Based (Not Coded)