phone icon 781.329.4300  ¦  Message us  ¦ Customer support login

500 characters left

Current Inpatient Orders by Provider

MT platform: All

This report lists non-cancelled ordered procedure details for current inpatients, grouped by ordering provider.

Current Inpatient Orders

MT platform: All

This report lists non-cancelled ordered procedure details for current inpatients.

Current Inpatients without Admit Order

MT platform: All

This report lists current inpatients (excluding newborns) that have no admission order.

Charge Codes and Bills

MT platform: All

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

Census by Attending Provider

MT platform: All

This report lists current inpatients with basic demographics, grouped by attending provider.

Current Inpatient IV Information

MT platform: Client/Server, MAGIC, 6.0

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

Coded Allergies by Patient

MT platform: Client/Server, MAGIC, 6.0

This report returns a list of a patient's historical coded allergies from MRI, based on a user-specified MR/unit number.

Search DR Metadata by Name

MT platform: All

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.)

Allergies by Patient

MT platform: Expanse / 6.1

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

Age intervals (function)

MT platform: All

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.)