Blogs Home
Monday, August 23, 2010 9:16 PM

AdHoc Reporting for MEDITECH NPR Data Definitions

Written by Joe Cocuzzo, Senior VP of Report Writing Services - iatricSystems

MEDITECH fields, at times, can elude even experienced NPR Report Writers. Let's review a quick way to find them using an unlikely technology for this task: SQL Server.

To produce unique lists of DPMS, SEGMENTS, & FIELDS from your MEDITECH Data Definitions, load them into a SQL Server database and then run adhoc SQL queries against them. Today, I want to show you how to use SQL Server to: De-duplicate a list, Find fields by DPM, & Learn about fields that compile to the same object code.

Learn more