Analytics services and solutions for MEDITECH.

For sites using Microsoft SQL Server Reporting Services only: this stored procedure shows all published SSRS reports from Report Manager along with their created, modified and last run date, if it exists.

This stored procedure returns a list of each provider type per inpatient visit, optimized for flat-file output. The report logic is driven by the patient discharge date range.

This TSQL query is useful to compare DR database schemas between test and live databases. This script produces a detailed list of changes by comparing your existing release in live against a newer version in test, and shows changed items by category (new tables, new columns, removed columns, datatype changes, etc.).

This stored procedure returns a list of matching charges from LSS/MPM (PBR tables) and BAR to help reconcile ambulatory and inpatient charges.