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.


 

Age All

Returns the age in years between two dates, including the age in "xM xD" format for pediatric patients.

Name Suffix Parse

Returns a patient's suffix (JR, SR, etc.), if present, from expressions with data in "LAST,FIRST MI..." format.

Middle Initial Parse

Returns a patient's middle initial, if present, from expressions with data in "LAST,FIRST MI..." format.

Add Padding to String

This function pads a string with N number of spaces.

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-level charge, balance, adjustment and receipt information for accounts with a bad debt (BD) status. The report uses date range prompts to limit results based on the bad debt age date from BAR.

Title Parse

Returns a patient's title (MD, etc.), if present, from expressions with data in "LAST,FIRST MI..." format.

Strip Non-Numeric Data

This function strips non-numeric data and leaves the original formatting.

FILTERS

Platforms




Modules









Categories