phone icon 781.329.4300  ¦  Message us

Age in Months and Days (function)

MT platform: All

This scalar TSQL function returns a computed age between two dates, shown in whole months and days (0M 0D), typically used for infants.

Age in Years (function)

MT platform: All

This scalar TSQL function returns a computed age between two dates, shown to the nearest whole year.

Convert CDS Response to DateTime (function)

MT platform: All

This scalar TSQL function converts MEDITECH customer-defined query responses (where date and time values are captured separately) to the TSQL datetime format.

Age in Years and Months (function)

MT platform: All

This scalar TSQL function returns a computed age between two dates, shown in whole years and months (0Y 0M). Sometimes used for pediatric patients.

Convert MT Time to Datetime (function)

MT platform: All

This scalar TSQL function returns a datetime datatype given the input of an integer stored in MEDITECH TimeID format.

Clinic and Hospital Matching Charges

MT platform: Client/Server, 6.0

This stored procedure returns a list of matching charges from LSS/MPM (PBR tables) and BAR to help reconcile ambulatory and inpatient charges.

Find DR Dependencies

MT platform: Client/Server, MAGIC, 6.0

This stored procedure is designed to help document programming objects (stored procedures and user-defined functions) so you can catalog your code and understand which MEDITECH Data Repository live tables and columns your code refers to. It will help plan for DR database schema changes and major version upgrades.

Compare DR Schemas

MT platform: All

This TSQL query is useful to compare DR database schemas between test and live databases. This script produces a detailed list of changes by comparing your existing release in live against a newer version in test, and shows changed items by category (new tables, new columns, removed columns, datatype changes, etc.).

Get end of day (function)

MT platform: All

This scalar TSQL function 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.