Welcome to the DR Network.

Everything you need to get started building reports with Data Repository. All free and available for every MEDITECH version from MAGIC to Expanse. Sign up today!

Contact us

Patient Providers by Discharge Date

  • MT platform: Client/Server, MAGIC

This stored procedure returns a list of each provider type per inpatient visit, optimized for flat-file output. The report logic is driven by the patient discharge date range.

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.).

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.

Parse Name (function)

  • MT platform: Client/Server, MAGIC, 6.0

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

(Read our blog for more information about user-defined functions in T-SQL.)

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.

(Read our blog for more information about user-defined functions in T-SQL.)

Proper Case (function)

  • MT platform: Client/Server, MAGIC, 6.0

This scalar TSQL 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, provider, insurance names, etc. as stored in MEDITECH to a more user-friendly format.

(Read our blog for more information about user-defined functions in T-SQL.)

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.

(Read our blog for more information about user-defined functions in T-SQL.)

Age in Years (function)

  • MT platform: All

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