1 / 33

Friday 6/3/2010 10:00am Ian Proffer

6.0 Custom Reports with Data Repository and SSRS 2008. Friday 6/3/2010 10:00am Ian Proffer. Session Overview. MEDITECH 6.0 at Woman’s Hospital Report development options in MEDITECH 6.0 Clinical reports from DR: some examples How it’s done: DR and SQL Server 2008 Reporting Services.

lauren
Download Presentation

Friday 6/3/2010 10:00am Ian Proffer

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 6.0 Custom Reports with Data Repository and SSRS 2008 Friday 6/3/2010 10:00am Ian Proffer

  2. Session Overview • MEDITECH 6.0 at Woman’s Hospital • Report development options in MEDITECH 6.0 • Clinical reports from DR: some examples • How it’s done: DR and SQL Server 2008 Reporting Services

  3. About Woman’s Hospital • A 225-bed, private, non-profit hospital in Baton Rouge, LA • Established in 1968, it specializes in inpatient and outpatient care for women and babies • Using Meditech since 1988 • Converted their MAGIC DR to C/S in early 2010 • Live with 6.0 in November 2010

  4. Woman’s Hospital Report Needs • Dozens of cross-module NPR reports needed to be re-written to provide data from the DR • Nursing data combined with: • ADM – demographics • EDM – emergent patient assessments • LAB, PHA – test results, meds ordered • Clinical needs dictated near real-time data availability for providers • Reports needed to be pre-compiledand delivered on schedule every day • Reports are also available on-demand from system users

  5. Just a few requests...

  6. 6.0 Reporting Tools • NPR Report Writer • Can be used with pre-6.0 C/S applications (ABS, ADM, BAR, LAB, PHA, etc.) • 6.0 Custom Report Designer • Can be used with 6.0 applications (EDM, EMR,HIM, OM, PCS, REG) • Data Repository • Can be used with all 6.0 applications (and others outside Meditech too!)

  7. Report Designer NPR RW DR Reports (SSRS) Data Flow Diagram & Ad-hoc Reporting MEDITECH 6.0 Application Databases C/S Application Databases 6.0 Application Databases Data Repository on SQL Server 2005 or 2008 RDMS livemdb livennndb

  8. Why Woman’s Chose Data Repository • Customization • Standard reports did not meet their needs • Combining 6.0 and C/S data was challenging with the Custom Report Designer • Performance • Data retrieval and report presentation speed from DR is fast • Flexibility • SQL Server SSRS allows report “snapshots” to be pre-compiled • Report output can be send to automated print and fax queues as .pdf files

  9. For Cross Module Reports... • DR is the best solution! • Patient Bed Board Report • Physician Activity Report • Infant Birth Height and Weight Report • RX’s Entered Without Administration Documented • Patients By Chief Complaint • List of ER Patients Admitted By Location • Any report that uses registration, abstracting, or billing data as well as assessment, emergency department, or any other 6.0 module data

  10. Creating Cross Database Queries Admission (Registration) main segment PCS Account Interventions

  11. Reports – A Closer Look

  12. NICU Birth Weights

  13. NICU In-House Babies

  14. NICU Charge Levels

  15. Medical Records Birth List

  16. Patient Census by Insurance

  17. Check Query Links

  18. Pharmacy-Lab Drug Level

  19. Physician Report - Newborn

  20. Physician Report - OB

  21. Physician Report - Surgery

  22. Behind the Scenes • Report management with SQL Server Reporting Services (SSRS) • Report scheduling and delivery using SSRS subscriptions • A SQL datamart is used to pre-compile and quickly retrieve 6.0 PCS data • Report design and functionality are built with Visual Studio 2008

  23. Behind the Scenes: SSRS Report Manager

  24. Behind the Scenes: SSRS Subscriptions

  25. SQL Server Database Development

  26. A datamart makes it simpler. Where to find the data?

  27. Why Use a Datamart? • Simplicity • There are 500+ PCS tables in the DR • 6.0 DR table naming standards are complex (e.g., PcsAcct_Main, PcsAcuity_Main, PcsAcct_AcuityMain) • Assessment questions and responses are stored in different tables • Linking a record from a 6.0 PCS table back to the Patient/Visit to which the record is associated is more difficult than C/S (compound primary keys) • Assessments can have multiple interventions; interventions can be on multiple assessments • Interventions can have grouped questions, grouped questions can have multiple response instances

  28. Why Use a Datamart? • Performance • Once a minute a scheduled job runs that updates any new PCS intervention activity for all inpatients • All reports run against this pre-populated datamart for near-instant results • Some reports use only data from the datamart • Other reports use the datamart for some data and join to other non-6.0 modules for other data • Auditing and recoverability are built-in

  29. Behind the Scenes: Visual Studio

  30. Behind the Scenes: Visual Studio

  31. The Results: Near Real-Time Clinical Data

  32. Discussion, Questions & Answers

  33. Thank you! • Our other MUSE sessions • 11am, #372-Basic Meaningful Use Reporting From DR • 1:30pm, #334-Inspiring Reporting Options in the World of 6.0

More Related