Quantcast
Data Repository Talk

MEDITECH Data Repository Library of Resources

Welcome to the Data Repository Network, your library of free SQL report downloads for MEDITECH DR. Based on our 20+ years of custom DR development from MEDITECH hospitals like yours, these simplified reports and T-SQL functions are your building blocks for writing and deploying your own custom reports, and include versions for all MEDITECH platforms: MAGIC, C/S, 6.0 and Expanse/6.1. Each report includes a T-SQL stored procedure and SSRS .rdl file so you can get up and running quickly.


 

Current Inpatients with Last Visit

This report lists current inpatients with basic demographics, including facility and location information, and adds the last inpatient and non-ER outpatient visit, if present.

Current Inpatient Orders by Provider

This report lists non-cancelled OE/OM order details for current inpatients by ordering provider.

Current Inpatient Orders

This report lists non-cancelled order details for current inpatients.

Current Inpatient Med Admins by Location

This report lists current inpatients by location with all of their active medication administrations from Pharmacy.

Allergies by Patient

This report returns a single patient by unit number with a list of their allergy information from EMR.

Coded Allergies by Patient

This report returns a single patient by unit number with a list of their coded allergies.

Patient Wristband

A patient demographic wristband, including full patient name, DOB, age, gender, Medical Record Number, Account Number, REG type and 2D barcode.

Clinic and Hospital Matching Charges

This stored procedure returns a list of matching charges from LSS/MPM (PBR) and BAR to help reconcile Ambulatory and Inpatient Charges.

Last Name Parse

Returns a patient's last name from expressions with data in "LAST,FIRST MI..." format.

First Name Parse

Returns a patient's first name from expressions with data in "LAST,FIRST MI..." format.

FILTERS

Platforms




Modules









Categories