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.