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 18+ 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 6.1. Each report includes a SQL stored procedure and Visual Studio .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 Inpatients with Average a1C Result

This report lists current inpatients with results from the most recently collected lab specimen with an A1c test. If more than 1 test was performed, the average result is returned.

Current Inpatient Orders by Provider

This report lists non-cancelled OE 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. It excludes discontinued, stopped and expired prescriptions.

Coded Allergies by Patient

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

Charge Summary by Dept and Category

This report shows total BAR charges grouped by charge department and category for a given BatchDateTime.

Census by Location

This report lists current inpatients with basic demographics, including facility and location.

Census by Attending Provider

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

Bad Debt Accounts by Date

This report provides summary charge, balance, adjustment and receipt information for accounts with a bad debt (BD) status that have a non-zero balance. The report uses date range prompts to limit results based on the bad debt age date from BAR.

FILTERS

Platforms




Modules











Categories