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.


Strip Non-Numeric Data

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

Strip Non-Numerics Phone Format

This function returns a formatted phone nunber: NNN-NNN-NNNN or NNN-NNNN

Proper Case

This function converts any text string to proper case (mixed case with initial upper case letter followed by lower case letters). Typically used to convert PATIENT,NAME as stored in MEDITECH to a more user-friendly format.

Name Parsing Function

Returns the user-specified portion of a patient's name from expressions with data in "LAST,FIRST MI..." format. Options include first name, last name, middle initial, title and suffix.