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.


 

Payment Summary by Insurance

This report summarizes and totals BAR adjustments, receipts and refunds by insurance for a batch date range provided by the user.

Patient Account Financial Summary

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

Patient Account Charge Detail by Category

This report provides all charge procedure detail 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.

Lab Results for Current Inpatients

This report lists current inpatients with basic demographic data and all lab specimen test results.

Lab Results by Patient Account

This report provides all lab specimens with test results based on a user-provided account number.

Inpatient Readmissions

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

Current Inpatients without Admit Order

This report lists current inpatients (excluding newborns) that have no admission order.

Current Inpatients with Last Vital Signs

This report shows the last recorded blood pressure, height and weight and temperature for current inpatients, grouped by location.

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.

FILTERS

Platforms




Modules









Categories