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.


 

Is Numeric

Tests varchar datatype to determine if they can be handled as numeric values. A useful alternative to the SQL IsNumeric function that handles resulted LAB values more accurately.

Average Census by Hour

This report returns the average hospital census by hour-of-day over a given date range.

Get End of Day

Automatically calculates the last second of a given day (23:59:59) when passed a date in mm/dd/yyyy format. Useful for getting to the end of a day on reports that prompt the user for a date range.

seconds to hours and minutes

Returns the hours and minutes (displayed in HH:MM format) between two Meditech TimeID values (stored as seconds).

kilograms to pounds

Converts data captured as grams to display as pounds and ounces (e.g. "7lbs 13oz").

Datetime to Hours and Minutes

Calculates the interval in hours and minutes between two dates, displayed as "hh:mm" format. Useful for calculating elapsed time.

CDS Responses to Date Time

Converts MEDITECH Customer Defined Query (CDS) responses (where date and time values are captured separately) into SQL datetime format.

Age Years Months

Calculates the age between two dates for display in "xY xM" format for pediatric patients.

Age In Years

This function returns a computed age in years between two dates, accurate to the day, by accommodating months with less than 31 days.

Age Months Days

Returns a computed age in "xM xD" format, typically used for pediatric patients.

FILTERS

Platforms




Modules











Categories