Clinical Reporting using Meditech - PowerPoint PPT Presentation

1 / 49
About This Presentation
Title:

Clinical Reporting using Meditech

Description:

... 375 Rehabilitation 4,402 Total Adult Admissions 5,990 Total Adult Patient Days 27,099 Newborn Admissions 687 Newborn Patient Days 2,040 Total ... – PowerPoint PPT presentation

Number of Views:1025
Avg rating:3.0/5.0
Slides: 50
Provided by: acmewareC
Category:

less

Transcript and Presenter's Notes

Title: Clinical Reporting using Meditech


1
Clinical Reporting using Meditechs Data
Repository
  • Jamie McDonald

2
Hays Medical Center is a regional referral center
for northwest Kansas, located in the City of
Hays, Ellis County, Kansas, a community with a
population of approximately 20,000.
3
  • Services offered at Hays Medical Center
  • Inpatient and ambulatory surgical services
  • Obstetrical services
  • Level II neonatal intensive care services
  • Medical and radiation oncology services
  • Diagnostic imaging services, including magnetic
    resonance imaging (MRI), computerized tomography
    (CT), mammography and sonography, nuclear
    medicine
  • Two cardiac catheterization labs and one
    peripheral vascular lab
  • Open Heart Surgery
  • Emergency service staffed by physicians 24 hours
    a day
  • Pulmonary medicine and neuroscience
  • Rehabilitation therapies
  • Patient and clinical education
  • Center for Health Improvement

4
  • Hays Medical Center has 192 licensed beds
  • 172 acute beds (including 12 ICU and 12 CPCU
    beds)
  • 22 inpatient rehabilitation beds

5
  • Services offered at Hays Medical Center
  • Physician Offices including 27 employed
    physicians, 7 locum physicians, and 13 mid-level
    providers. Specialties include
  • Cardiovascular Surgery
  • Cardiology
  • Neurology
  • Pediatrics
  • Surgery
  • Family Practice
  • Internal Medicine
  • Pulmonology
  • Obstetrics-Gynecology
  • Oncology
  • Psychology

6
  • Hays Medical Center, Inc. Hospital Statistics for
    2006
  • Historical Utilization Data Fiscal Year Ended
    June 30,2006
  • Adult Admissions Adult Patient Days
  • Acute care 5,614 Acute
    care 22,697
  • Rehabilitation
    375 Rehabilitation 4,402
  • Total Adult Admissions 5,990 Total Adult
    Patient Days 27,099
  • Newborn Admissions 687 Newborn Patient
    Days 2,040
  • Total Admissions 6,677 Total Patient
    Days 29,139
  • Births
    681 Inpatient Surgeries 2,434
  • Ambulatory Surgeries 4,513

7
  • Hays Medical Center Meditech History
  • Initial GO LIVE June 1, 2003, with Client Server
    5.3
  • ADM/MRI/ABS AP
  • BAR GL
  • ITS MIS
  • MM NPR
  • OE PHA
  • PP SCH/OR

8
  • Hays Medical Center Meditech History
  • Subsequent GO LIVES
  • Nov 2003 --MPM Scheduling/PBR
  • May 2004 PCS, EMR, LAB, DR
  • August 2004 Pilot Program for POM
  • Sept 2004 5.4 SR 1
  • Jan 2005 PWM / PCM
  • Feb 2005 EAR (Scripting Transcription only)
  • April 2005 -- EDM (Patient Tracker only)
  • August 2005 More of EAR PWM, AOM
  • February 2006 5.5 SR 2
  • January 2007 -- BMV
  • March 2007 5.5 SR 2C (Update for LSS)

9
  • Hays Medical Center Meditech
  • Future GO LIVES
  • June 2007 - MIG
  • October 2007 5.5 SR 5
  • March 2008 - QA/RM
  • April 2008 EDM
  • June 2008 Oncology
  • December 2008 - Scanning/Archiving (to replace
    Valco)

10
Why use the data repository?
  • Complex reports are much easier to write using
    T-SQL than NPR
  • Process time dramatically decreases
  • Easy to join data across modules
  • Data from multiple sources (Pyxis)
  • Dynamic drill down reporting
  • Ease of exporting data
  • Various front end reporting tool options

11
Keys to Reporting Clinical Data
  • Take the time to understand the process and the
    specific needs of the department
  • Automate as much as possible
  • Write code to be as efficient as possible
  • Document within your code
  • Setup alerts
  • Exception Reporting
  • Nursing document which assessments and queries
    are being replaced

12
Report Examples
  • Nursing
  • Picc Lines
  • Restraints
  • Inpatient Therapy (OT,ST,PT)
  • Acuity
  • Medical Oncology
  • Cancer Type
  • Scheduling
  • Pharmacy
  • Drawer Errors
  • Possible Deviations

13
What information needs to be included for picc
lines?
  • Need all attempts and successful picc line
    insertions summarized by Nurse.
  • All Picc Line Orders
  • All Picc Line Related Charges
  • Exception report

14
Basic Steps Picc line
  • Transfer daily information on picc line
    documentation via DTS
  • To minimize process time
  • Link visits to OeOrders and BarChargeTransactions
  • To obtain order and charge information
  • Use SQL Reporting Services to display summary
    data along with drill down detail

15
Picc Line Summary Report
Drill down to Nursing detail
16
Picc Line Nursing Details
Drills down to patient orders and billing
17
Picc Line Orders and Charges
18
Restraints
  • What data do we need?
  • Number of initiates and removes
  • Data summarized by department with detail
  • Basic Steps
  • Transfer data daily to separate table (for past
    12 months)
  • Query data from 12 month table
  • Currently displayed in CyberView

19
Restraints
Drop down for last 12 months
Locations from selected month above
Accts from selected dept
20
Inpatient Therapy
What information do we want?
  • Number of patients relative to inpatient volumes
  • Units of Service
  • Number of refusals
  • Treatment numbers by type
  • Summary by department and therapist
  • Drill down to detail information

21
Basic steps for Inpatient therapy
  • Census data from Adm transferred to a separate
    table on a nightly basis for current fiscal year
  • Patient Count by Therapy Assessment
  • Defined refine criteria for refusals
  • Units of service from Its or Bar
  • Totals by treatment type
  • Summarized data with drill down to daily
    summaries and detail

22
Inpatient Therapy
This report automatically runs when link or
report is selected
Select month for daily drill down
23
Monthly Therapy patients vs. Inpatient Volumes
(OT,PT,ST)
24
Drill down daily summary (OT, PT, ST)
  • Vertical market opportunities
  • Discuss specific market segment opportunities
  • Address distribution strategies for those markets
    or segments
  • Address use of third-party partner role in
    distribution to vertical markets

25
Therapy Summary by Selected Department
Department drop down Physical Therapy Occupational
Therapy Speech Therapy
Current drill down items
Current drill down items
26
PT drilldown on Selected Month
Drills down to daily by month and therapist
Drills down to refusal comments
Drills down to nursing documentation details
27
Refusal drill down for PT
28
Daily Summary by Therapist
29
Current fiscal year by Therapist
There is a therapist drop down selection at the
top of the report
30
Acuity Reporting
  • Acuity Assessment
  • Calculate acuity based on latest care level
    documented
  • Report for charge nurses to run dynamically
  • Data is run on a schedule to report data by
    location and the number of patients per level

31
Acuity Assessment
32
Charge Nurse Acuity Report
Drills down to nursing documentation
Drills down to patient count by acuity level
Drills down to adm patient detail
33
Drill down on current census from Nursing Acuity
Show those that have not had acuity documented
34
Acuity Drill down on Location
(This data is also stored in a data mart every 6
8 hours)
35
MEDONC CLINIC REPORTING
  • What do we want to know?
  • What are the percent of patients and cancer types
    being seen in the clinic?
  • How we calculate the numbers?
  • Patients are selected on all cancer type drgs
  • Data is grouped by first cancer drg
  • The stats are summarized by current month to date
    and current year to date

36
Medonc Cancer Types
Drills down to patient level detail
37
Medonc Exam appointments
  • What do we need to know?
  • Actual appointment times vs. scheduled
    appointment time?
  • How do we get the data?
  • Link appointment to OeOrders (thru sch
    dictionary) and then to ItsOrderExams
  • Group data by appointment types
  • Create exception reporting

38
Medonc Actual appointment times
Drills down to patient detail
39
Medonc exception report (exam times)
40
Medonc Exception Report (OeOrders)
41
Pyxis Data
  • What do we want to accomplish?
  • Easy access to Pyxis Data
  • Link Pyxis data with Meditech drug
    administrations
  • Provide alerts for possible diversions
  • Report on drawer failures
  • Provide discrepancy data to pharmacy and nurse
    mangers

42
Pyxis Med Data
  • Move Pyxis archive files over to DR
  • Acmeware Inc. Geoff Grouten
  • Drawer failures and errors
  • Group by type of failure
  • Group by Station and Drawer
  • Define method of diversion alert still refining
  • Links to MT med administrations
  • Comparative data by patient

43
Pocket Errors by Type of Error
Drills down to station
44
Pocket Error Drill Down
Drills down to drawer, sub drawer, and pocket
45
Pocket Error Summary by Station(Drawer, Sub
Drawer, Pocket)
46
High Usage Summary
Drills down to Pyxis transactions and then from
pt acct links to admins within Meditech
47
PHA Diversion Reports in development
  • High usage (possible diversion) will be
    determined by standard deviation
  • Comparative data within the unit drug for date
    range
  • Drill down to patient data with transactions from
    Pyxis and meditech drug administrations
  • Linked to other controlled medications for user
  • Discrepancy reports
  • Pharmacy
  • Nurse managers

48
Home Page Reporting Service Manager
49
Thank you for attending!
Thanks to Acmeware, Blue Elm, and
CyberView/Medisolv for the invaluable help over
the past few years.
  • Jamie McDonald
  • Hays Medical Center
  • Hays, KS 67601
  • jmcdonal_at_haysmed.com
  • 785-623-5023
Write a Comment
User Comments (0)
About PowerShow.com