This report returns a list of a patient's historical allergies from EMR, based on a user-specified medical record number.

This report shows returns BAR charge codes relative to a patient bill, as well as charge amounts for a single patient account number.

This report lists current inpatients by location with all of their IV medication info from Pharmacy.

Use this this stored procedure when you're not sure where to find data from a particular DR table or column. It searches for DR table or column names and returns relevant metadata from the DrTable_Main and DrTable_Columns (M-AT) or DrTableMain and DrTableColumns (MAGIC, C/S) tables.  (For more information on searching for metadata and data storage in MEDITECH, read this blog post.)

This table-valued T-SQL function returns date interval/period calculations that can be used to assemble age or any elapsed time string.  (Read our blog for more information about user-defined functions in T-SQL.)

This stored procedure captures the most recent (from ADM) non-multiple documented clinical queries and responses for all inpatients.

This stored procedure is designed to help document programming objects (stored procedures and user-defined functions) so you can catalog your code and understand which MEDITECH Data Repository live tables and columns your code refers to. It will help plan for DR database schema changes and major version upgrades.

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.