NPR Report List (CS)
C/S
6.0
Two reports designed to aid sites migrating from Client/Server to a 6.1 release. Lists all custom reports from NPR, broken down by DPM and application.
The Acmeware 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!
A Free Library, Built by People Who Live in the Data.
The DR Network is a free, members-only collection of working SSRS reports, T-SQL code, and RD/NPR samples that you can download, adapt, and put to work inside your own Data Repository. Every item was written by Acmeware consultants and tested against real MEDITECH systems, from MAGIC to Expanse. Sign up once and the whole library is yours, no strings attached.
DR Reports
NPR Report Lists
NPR Report List (MAGIC)
Magic
Two reports designed to aid sites migrating from MAGIC to a 6.1 release. Lists all custom reports from NPR, broken down by DPM and application.
Abstracting (ABS)
Inpatient Readmissions
Magic
C/S
6.0
Expanse
This report shows inpatients that are discharged and subsequently admitted within the user-specified date range and number of days between admissions.
Discharged Patients by Date
Magic
C/S
6.0
This report lists discharged inpatients with demographic info based on a user-provided date range.
Patient Dashboard
Magic
C/S
6.0
This report lists a patient's most recent demographic information as well as all insurances and complete visit history.
Admissions (ADM)
Patient Providers by Discharge Date
Magic
C/S
6.0
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.
Inpatient ADM Clinical Queries
Magic
C/S
6.0
This stored procedure captures the most recent non-multiple documented clinical queries and responses for all inpatients from the ADM module.
Current Inpatient IV Information
Magic
C/S
6.0
This report lists current inpatients by location with all of their IV medication info from Pharmacy.
Census by Attending Provider
Magic
C/S
6.0
Expanse
This report lists current inpatients with basic demographics, grouped by attending provider.
Current Inpatients without Admit Order
Magic
C/S
6.0
Expanse
This report lists current inpatients (excluding newborns) that have no admission order.
Current Inpatient Orders
Magic
C/S
6.0
Expanse
This report lists non-cancelled ordered procedure details for current inpatients.
Current Inpatient Orders by Provider
Magic
C/S
6.0
Expanse
This report lists non-cancelled ordered procedure details for current inpatients, grouped by ordering provider.
Current Inpatients with Last Vital Signs
Magic
C/S
6.0
Expanse
This report shows the last recorded blood pressure, height, weight and temperature for current inpatients, grouped by location.
Lab Results for Current Inpatients
Magic
C/S
6.0
Expanse
This report lists current inpatients with basic demographic data and all lab specimen test results.
Lab Results by Patient Account
Magic
C/S
6.0
Expanse
This report provides all lab specimens with test results based on a user-provided account number.
Current Inpatients with Last Visit
Magic
C/S
6.0
Expanse
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.
Current Inpatient Medication Administrations by Location
Magic
C/S
6.0
Expanse
This report lists current inpatients by location with all of their active medication administrations from Pharmacy.
Census by Location
Magic
C/S
6.0
Expanse
This report lists current inpatients with basic demographics, including facility and location.
Medication Administrations by Patient Account
Magic
C/S
6.0
Expanse
This report lists all Pharmacy medication administrations for a single patient stay, based on a user-provided account number.
Average Census by Hour
Magic
C/S
6.0
Expanse
This report returns the average hospital census by hour-of-day over a user-provided date range.
Cancelled Appointments
Magic
C/S
6.0
This report returns a list of cancelled patient appointments along with the provider, cancellation reason and date, for the user-specified date range when the report is run.
Discharged Patients by Date
Magic
C/S
6.0
This report lists discharged inpatients with demographic info based on a user-provided date range.
Patient Dashboard
Magic
C/S
6.0
This report lists a patient's most recent demographic information as well as all insurances and complete visit history.
COVID-19 Dashboard
Magic
C/S
6.0
Expanse
This report provides a variety of useful measures for patients with confirmed or suspected COVID-19, including relevant metrics like patient census, bed occupancy, ventilator availability, and more.
Billing/Accounts Receivable (BAR)
Clinic and Hospital Matching Charges
C/S
6.0
This stored procedure returns a list of matching charges from LSS/MPM and BAR to help reconcile ambulatory and inpatient charges.
Charge Codes and Bills
Magic
C/S
6.0
Expanse
This report returns BAR charge codes relative to a patient bill, as well as charge amounts for a single patient account number.
Bad Debt Accounts by Date
Magic
C/S
6.0
Expanse
This report provides summary-level charge, balance, adjustment and receipt information for accounts with a bad debt status, based on a user-provided date range.
Charge Summary by Department and Category
Magic
C/S
6.0
Expanse
This report shows total BAR charges grouped by charge department and category for a specified batch date range.
Payment Summary by Insurance
Magic
C/S
6.0
Expanse
This report summarizes and totals BAR adjustments, receipts and refunds by insurance for a batch date range provided by the user.
Patient Account Charges by Category
Magic
C/S
6.0
Expanse
This report provides all charge procedure detail from BAR based on a user-provided account number.
Patient Account Financial Summary
Magic
C/S
6.0
Expanse
This report provides summary charge, balance, adjustment and receipt information from BAR based on a user-provided account number.
Health Information Management (HIM)
Patient Wristband
Expanse
This RD report provides a patient demographic wristband, including full patient name, DOB, age, gender, Medical Record Number, Account Number, REG type and 2D barcode.
Allergies by Patient
Expanse
This report returns a list of a patient's historical allergies from EMR, based on a user-specified medical record number.
Census by Attending Provider
Magic
C/S
6.0
Expanse
This report lists current inpatients with basic demographics, grouped by attending provider.
Current Inpatients without Admit Order
Magic
C/S
6.0
Expanse
This report lists current inpatients (excluding newborns) that have no admission order.
Current Inpatient Orders
Magic
C/S
6.0
Expanse
This report lists non-cancelled ordered procedure details for current inpatients.
Current Inpatient Orders by Provider
Magic
C/S
6.0
Expanse
This report lists non-cancelled ordered procedure details for current inpatients, grouped by ordering provider.
Current Inpatients with Last Vital Signs
Magic
C/S
6.0
Expanse
This report shows the last recorded blood pressure, height, weight and temperature for current inpatients, grouped by location.
Bad Debt Accounts by Date
Magic
C/S
6.0
Expanse
This report provides summary-level charge, balance, adjustment and receipt information for accounts with a bad debt status, based on a user-provided date range.
Lab Results for Current Inpatients
Magic
C/S
6.0
Expanse
This report lists current inpatients with basic demographic data and all lab specimen test results.
Lab Results by Patient Account
Magic
C/S
6.0
Expanse
This report provides all lab specimens with test results based on a user-provided account number.
Current Inpatients with Last Visit
Magic
C/S
6.0
Expanse
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.
Current Inpatient Medication Administrations by Location
Magic
C/S
6.0
Expanse
This report lists current inpatients by location with all of their active medication administrations from Pharmacy.
Census by Location
Magic
C/S
6.0
Expanse
This report lists current inpatients with basic demographics, including facility and location.
Medication Administrations by Patient Account
Magic
C/S
6.0
Expanse
This report lists all Pharmacy medication administrations for a single patient stay, based on a user-provided account number.
Patient Account Charges by Category
Magic
C/S
6.0
Expanse
This report provides all charge procedure detail from BAR based on a user-provided account number.
Inpatient Readmissions
Magic
C/S
6.0
Expanse
This report shows inpatients that are discharged and subsequently admitted within the user-specified date range and number of days between admissions.
Average Census by Hour
Magic
C/S
6.0
Expanse
This report returns the average hospital census by hour-of-day over a user-provided date range.
Patient Account Financial Summary
Magic
C/S
6.0
Expanse
This report provides summary charge, balance, adjustment and receipt information from BAR based on a user-provided account number.
Laboratory (LAB)
Lab Results for Current Inpatients
Magic
C/S
6.0
Expanse
This report lists current inpatients with basic demographic data and all lab specimen test results.
Lab Results by Patient Account
Magic
C/S
6.0
Expanse
This report provides all lab specimens with test results based on a user-provided account number.
COVID-19 Dashboard
Magic
C/S
6.0
Expanse
This report provides a variety of useful measures for patients with confirmed or suspected COVID-19, including relevant metrics like patient census, bed occupancy, ventilator availability, and more.
Medical Records Imaging (MRI)
Coded Allergies by Patient
Magic
C/S
6.0
This report returns a list of a patient's historical coded allergies from MRI, based on a user-specified MR/unit number.
Current Inpatients with Last Visit
Magic
C/S
6.0
Expanse
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.
All Patients with Home Medication
Magic
C/S
6.0
This report returns a list of all patients with an active home medication that match the user-specified drug mnemonic specified when the report is run.
Patient Dashboard
Magic
C/S
6.0
This report lists a patient's most recent demographic information as well as all insurances and complete visit history.
Order Entry / Order Management (OE/OM)
Current Inpatients without Admit Order
Magic
C/S
6.0
Expanse
This report lists current inpatients (excluding newborns) that have no admission order.
Current Inpatient Orders
Magic
C/S
6.0
Expanse
This report lists non-cancelled ordered procedure details for current inpatients.
Current Inpatient Orders by Provider
Magic
C/S
6.0
Expanse
This report lists non-cancelled ordered procedure details for current inpatients, grouped by ordering provider.
COVID-19 Dashboard
Magic
C/S
6.0
Expanse
This report provides a variety of useful measures for patients with confirmed or suspected COVID-19, including relevant metrics like patient census, bed occupancy, ventilator availability, and more.
Pharmacy (PHA)
Current Inpatient IV Information
Magic
C/S
6.0
This report lists current inpatients by location with all of their IV medication info from Pharmacy.
Current Inpatient Medication Administrations by Location
Magic
C/S
6.0
Expanse
This report lists current inpatients by location with all of their active medication administrations from Pharmacy.
Medication Administrations by Patient Account
Magic
C/S
6.0
Expanse
This report lists all Pharmacy medication administrations for a single patient stay, based on a user-provided account number.
Registration (REG)
Patient Wristband
Expanse
This RD report provides a patient demographic wristband, including full patient name, DOB, age, gender, Medical Record Number, Account Number, REG type and 2D barcode.
Census by Attending Provider
Magic
C/S
6.0
Expanse
This report lists current inpatients with basic demographics, grouped by attending provider.
Current Inpatients without Admit Order
Magic
C/S
6.0
Expanse
This report lists current inpatients (excluding newborns) that have no admission order.
Current Inpatient Orders
Magic
C/S
6.0
Expanse
This report lists non-cancelled ordered procedure details for current inpatients.
Current Inpatient Orders by Provider
Magic
C/S
6.0
Expanse
This report lists non-cancelled ordered procedure details for current inpatients, grouped by ordering provider.
Current Inpatients with Last Vital Signs
Magic
C/S
6.0
Expanse
This report shows the last recorded blood pressure, height, weight and temperature for current inpatients, grouped by location.
Bad Debt Accounts by Date
Magic
C/S
6.0
Expanse
This report provides summary-level charge, balance, adjustment and receipt information for accounts with a bad debt status, based on a user-provided date range.
Lab Results for Current Inpatients
Magic
C/S
6.0
Expanse
This report lists current inpatients with basic demographic data and all lab specimen test results.
Lab Results by Patient Account
Magic
C/S
6.0
Expanse
This report provides all lab specimens with test results based on a user-provided account number.
Current Inpatients with Last Visit
Magic
C/S
6.0
Expanse
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.
Current Inpatient Medication Administrations by Location
Magic
C/S
6.0
Expanse
This report lists current inpatients by location with all of their active medication administrations from Pharmacy.
Census by Location
Magic
C/S
6.0
Expanse
This report lists current inpatients with basic demographics, including facility and location.
Medication Administrations by Patient Account
Magic
C/S
6.0
Expanse
This report lists all Pharmacy medication administrations for a single patient stay, based on a user-provided account number.
Patient Account Charges by Category
Magic
C/S
6.0
Expanse
This report provides all charge procedure detail from BAR based on a user-provided account number.
Inpatient Readmissions
Magic
C/S
6.0
Expanse
This report shows inpatients that are discharged and subsequently admitted within the user-specified date range and number of days between admissions.
Average Census by Hour
Magic
C/S
6.0
Expanse
This report returns the average hospital census by hour-of-day over a user-provided date range.
COVID-19 Dashboard
Magic
C/S
6.0
Expanse
This report provides a variety of useful measures for patients with confirmed or suspected COVID-19, including relevant metrics like patient census, bed occupancy, ventilator availability, and more.
Patient Account Financial Summary
Magic
C/S
6.0
Expanse
This report provides summary charge, balance, adjustment and receipt information from BAR based on a user-provided account number.
Prescription Management (RXM)
All Patients with Home Medication
Magic
C/S
6.0
This report returns a list of all patients with an active home medication that match the user-specified drug mnemonic specified when the report is run.
Scheduling (SCH)
Cancelled Appointments
Magic
C/S
6.0
This report returns a list of cancelled patient appointments along with the provider, cancellation reason and date, for the user-specified date range when the report is run.
Functions (TSQL)
Get End of Day (function)
Magic
C/S
6.0
Expanse
This scalar T-SQL function calculates the last second of a given day (23:59:59) when passed a date. Useful for reports requiring date range prompts.
Age in Months and Days (function)
Magic
C/S
6.0
Expanse
This scalar T-SQL function returns a computed age between two dates, shown in whole months and days (0M 0D). Typically used for infants.
Age in Years and Months (function)
Magic
C/S
6.0
Expanse
This scalar T-SQL function returns a computed age between two dates, shown in whole years and months (0Y 0M). Sometimes used for pediatric patients.
Age in Years (function)
Magic
C/S
6.0
Expanse
This scalar T-SQL function computes age between two dates, rounded to the nearest whole year.
Convert MT Time to Datetime (function)
Magic
C/S
6.0
Expanse
This scalar T-SQL function converts an integer stored in MEDITECH TimeID format into a datetime datatype.
Proper Case (function)
Magic
C/S
6.0
This scalar T-SQL function converts any text string to proper case. Typically used to convert patient, provider, and insurance names as stored in MEDITECH.
Convert CDS Response to DateTime (function)
Magic
C/S
6.0
Expanse
This scalar T-SQL function converts MEDITECH customer-defined query responses to the T-SQL datetime format.
Parse Name (function)
Magic
C/S
6.0
This scalar T-SQL function returns a user-specified portion of a patient name from expressions with data in LAST,FIRST MI format.
Clinic and Hospital Matching Charges
C/S
6.0
This stored procedure returns a list of matching charges from LSS/MPM and BAR to help reconcile ambulatory and inpatient charges.
Compare DR Schemas
Magic
C/S
6.0
Expanse
This T-SQL query is useful to compare DR database schemas between test and live databases, showing changed items by category.
Patient Providers by Discharge Date
Magic
C/S
6.0
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.
Report Server Usage
Magic
C/S
6.0
Expanse
This stored procedure shows all published SSRS reports from Report Manager along with their created, modified and last run date, if it exists.
Find DR Dependencies
Magic
C/S
6.0
This stored procedure helps document programming objects so you can catalog your code and understand which MEDITECH Data Repository live tables and columns your code refers to.
Inpatient ADM Clinical Queries
Magic
C/S
6.0
This stored procedure captures the most recent non-multiple documented clinical queries and responses for all inpatients from the ADM module.
Search DR Metadata by Name
Magic
C/S
6.0
Expanse
Use this stored procedure when you are not sure where to find data from a particular DR table or column. It searches DR table and column names and returns relevant metadata.
