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.


 

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.

Inpatient Readmissions

This report shows inpatients that are discharged and subsequently admitted within the specified date range and number of days between admissions.

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.

Patient Account Financial Summary

This report provides summary charge, balance, adjustment and receipt information from BAR based on a user-provided account number.

Medication Administrations by Patient Account

This report lists all Pharmacy medication administrations for a single patient stay, based on a user-provided account number.

Title Parse

Returns a patient's title (MD, etc.), if present, from expressions with data in "LAST,FIRST MI..." 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.

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.

MEDITECH Time to Date Time

Returns a datetime datatype given the input of an integer stored in MEDITECH TimeID format.

FILTERS

Platforms




Modules











Categories