Moving Beyond Standard BMV Reports Using Data Repository

Moving Beyond Standard BMV Reports Using Data Repository Session 373 Presented by: Ian Proffer

Session Agenda ¡ ¡ Review e. MAR and BMV benchmarking reports in MEDITECH applications and the Data Repository Report development and deployment strategies Example DR-based BMV scan rate and warning reports Questions, answers, & discussion

Areas of Interest ¡ Rx administration summary l l ¡ Doses administered, doses scanned Administered with or without warnings BMV scan rates, looking for improvements l l ¡ By location and user By department and user? BMV warnings analysis l By location, drug, ordering provider, user, etc.

Our Development Strategy 1. 2. 3. 4. 5. Review standard reports available in MEDITECH (MAGIC 5. 61) Identify corresponding data within MEDITECH Data Repository Create reports and structures to present the same data in a more user friendly and meaningful way Validate results against MEDITECH application reports Look for additional methods to relate e. MAR and BMV data to glean additional knowledge into success of BMV / e. MAR effort

MEDITECH e. MAR and BMV Reports ¡ e. MAR Measuring & Monitor Detail l l This report allows users to specify and filter data by location, ordering provider, admin user, drug type, drug, and warning type. It then summarizes medication dose administrations, scan rates, warnings, and patient verifications.

MEDITECH Report Sample User-supplied criteria Summary Stats Warning Counts Administration Warnings By Location and User

Where We Get e. MAR & BMV Data ¡ ¡ MEDITECH Data Repository Versions 5. 61 Most Pharmacy data became available in DR in version 5. 5 l ¡ Includes all NPR DPMs / segments as well as dictionaries Can be easily linked to data in other MEDITECH applications

Data Repository in SQL Management Studio SQL Server 2005 (or 2000) Relational Database Management System with MEDITECH Application Data 6000+ tables containing most data from most MEDITECH applications

e. MAR and BMV Information in the DR BMV scan activity Dose Warning Detail NPR DPM = PHA. RX SEGMENT = scanned. med. x Information about dose administration NPR DPM = PHA. RX SEGMENT = dose. warnings e. MAR Compiled Statistics NPR DPM = PHA. RX SEGMENT = admin NPR DPM = PHA. STATS SEGMENT = emar. daily. admin. stats

A Closer Look at MEDITECH’s Total Statistics Totals for doses administered, scanned, administered with and without warnings, doses not administered, patients verified (by wrist band scanning) and total warnings. Two categories: 1) Doses Administered 2) Doses Not Administered

Data Repository-Driven Version User-supplied criteria includes date range, but can also include Location, Ordering Provider, etc. Totals provide same information as MEDITECH report and can show or hide detail data Charts are easily incorporated to add visual impact – this example highlights improving scan rates

Report Development & Delivery Strategies ¡ ¡ ¡ SQL Server 2005 stored procedures to extract detail and summary e. MAR and BMV data from DR tables SQL Server 2005 Reporting Services to summarize and sort data, provide interactivity and drill-through to related reports, and deliver reports via intranet, email, file share, or printer SQL Server 2005 Analysis Services to perform multi-dimensional analysis

More MEDITECH Reports Scan Rates by User, by Location

SSRS Report Designer Visual Studio 2005 • VS provides a graphical design environment to simplify report development • “Under the hood” complex coding takes place – dedicated IT developers can leverage powerful programming features

SQL Reporting Services (SSRS) Report Manager Web-based administration • Organize into Folders • Security Profiles • Subscriptions • Snapshots Uses local intranet (Microsoft ISS) to host reports and deliver to users

Reporting Services Versions Reports can be exported in a variety of formats, or printed directly from your browser Dates can easily be changed and the report re-run with one mouse click Conditional formatting allows you to highlight values based on your own metrics

Scan Rate by Department With Drill-down to Employee Very useful for clinical managers: location and department are two different things! DR reports allow cross-module analysis, in this case PHA and PP

SSRS Interactivity Remember This Report? Click on the date… Report Manager allows you to view and navigate reports just like a web page – very simple for staff to use. …and the date is passed to run this report.

MEDITECH Measuring and Monitoring Detail Report - Patient Statistics? This is really a breakdown of Warnings by Location and Admin User

Acmeware Version Using Drill-Down Totals By User “+” Allows drill -down to totals by user and warning Totals By Location

MEDITECH Measuring and Monitoring Detail Report - Warning Summary Admin Percent of Total Warnings issued over a date range broken by medications administered and not administered Warnings percent is based on total warnings from Total Statistics Report

Acmeware Warning Summary Report Filtering criteria can be changed immediately and the page refreshed Dropdown Box allows one, multiple or <ALL> selection (SQL 2005) Percentages based on Total Warnings

SQL Server 2005 Analysis Services Cubes are Multidimensional Databases that allow data to be easily analyzed, sorted, filtered, and manipulated to look for trends, outliers, and other information hidden within the data.

What’s In a Cube? ¡ ¡ ¡ Fact Tables define events occurring over time (e. g. , patient visits, medication administrations, warnings, lab tests, etc. ) Measures are numeric computations of facts (e. g. , count number of visits, total number of administration warnings, etc. ) Dimensions are the ways you might want to analyze the measures. Examples include items from MEDITECH dictionaries (e. g. providers, drugs, locations) as well as regular time increments (days, months, years).

BMV Warning Summary Dimensions Measures Facts

Warning Analysis by Administered Location Dimension data can be hidden, but used to filter summary data. Dimensions can be arranged to show logical groupings; subtotals are automatically updated.

Warnings by Location With Chart can be displayed side-by-side with detail data, or on its own.

Warnings by User Chart

More Chart Analysis Options With a Few Clicks… Chart type is quickly changed to show total warnings by month for Jan-April… …for these nurses only.

Differences Between Reporting Services and Analysis Services ¡ SSRS reports: run and done l l l ¡ User may or may not supply criteria Typically designed and maintained by IT staff Reports are designed to present specific, detailed information SSAS data: dynamic and open l l l User decides what to see and how to see it Finished “report” is designed by user (within constraints of your software) Allow immediate analysis of a variety of information – great of revealing trends using summary data

Looking Ahead: Using DR Data to Measure Successful BMV/e. MAR Use ¡ Look for additional methods to correlate e. MAR and BMV data l ¡ ¡ ¡ Associate warnings with medication administration Analyze effect on adverse events Measure improvement in patient outcomes Other indirect influences of BMV and e. MAR

Thank you!