PHI and MEDITECH’s Data Repository

To address HIPAA, MEDITECH added logging of access to PHI via reports and all applications, and added that level of detail to MIS user activity logs. So, if you run an NPR, RD, or standard report and the report contains PHI, the run user and the set of patients in the output is logged. MEDITECH has a field in their “programmer” NPR Report Writer routine where they can defeat logging, and that makes sense for big exports where the run user just set up the scheduled report run, but otherwise MEDITECH has fairly comprehensive tracking of access to PHI via most reports.

But what about Data Repository (DR) reports? 

Read More

NPR Tip: Various “Gotchas” in MEDITECH field names

What's in a name?

In teaching NPR, RD, and SQL from DR, a big chunk of my time is spent helping students figure out where data is kept (for example, which segment in NPR), and then what field names are called. MEDITECH segment structures and field names are built “by hand” by the application developer, which results in some unfortunate inconsistencies that make our Report Writing lives harder. This post examines MEDITECH field naming across applications, identifies some various “gotchas” to be aware of, and provides some tips for how to overcome those challenges.

Read More

DR Tip: A Dynamic Extract Documentation Template

This blog post is designed for readers who use MEDITECH’s Data Repository.

As part and parcel of developing ETL extracts for vendors, it is often quite useful to build a technical specification first. In the case of vendor extract files that involve the hospital getting money back from the federal government (think 340B), I recommend that a proper file spec be mandatory.

Read More

SQL Tip: How to Strip Repeating Delimiters from String

This is a small tip, but could be quite useful on the days you need it.

Particularly when you work with MEDITECH 6.x PCS data, you will often encounter query response values that look like this:

{|||,30+3/40 Emergency|||||LSCS|Apgar 4/1 7/5}

Read More

SSRS Tip: Adding a Pipe-delimited option to SSRS Export Destinations

End users are very fond of running reports in SSRS and exporting the results to a variety of formats. Excel is probably the most popular, but invariably there will be other formats needed.

Unfortunately, in SSRS the list of other formats is limited. In particular, a pipe (|) delimited format is not available. But you can, if you are willing to update your SSRS configuration, add this yourself. The following approach has been tested through SSRS 2012. It may work in SSRS 2014+, but we have not yet confirmed it on that platform.

Read More

SQL Tip: The Good, the Bad, and the Ugly of TOP X

As you’re learning SQL, you will invariably come across the TOP X clause to a SELECT, which allows you to get – for example – the first 50 rows of a query:

SELECT TOP 50 ADV.VisitID FROM livedb.dbo.AdmVisits ADV ;

This can be quite handy for testing if tables are populated, or just grabbing some records to review when you’re looking for something. And if you’re an old, grizzled, MEDITECH NPR programmer (as many of our followers are), you’ll be happy to see something that acts like Z.record.limit.

However...

Read More

Migration: Export MOX Using NPR

Recently a MEDITECH hospital wanted to export a handful of MOX databases, since they were migrating away from MOX. I have done a few of these in the past on rare occasions (on a “per database” basis), and most of the programming time was spent on mapping and cleanup — not on the actual extraction of the data itself.

In this blog post, I’ll discuss how I figured out how to write a generic export in an NPR report, so savvy NPR programmers can do this for themselves in the future.

Read More

Using DR Data Def Tables, Updated for CS/MAGIC 5.67 or MT 6.07/6.15

One of the challenges of DR-based report development is the same as for NPR or RD … where is the data you want stored? One way to find out is to go into MEDITECH and find the field, and — if you're lucky — you can do:

Read More

SSIS Tip: Formatting Numbers with Commas via Expression

Oh, Microsoft - why do you make us cry?

And no, I am not talking about Windows 10. Though that does make me cry a bit. Every day.

But enough about me.

Read More

SQL+DR Tip: Use SSIS Templates to Speed Extract Builds

If you’ve started using Microsoft’s SQL Server Integration Services (SSIS) toolkit to create, schedule, and deliver extracts (machine-readable files) to vendors, non-MEDITECH applications, and even internal users who love their Excel, then you know that the same kinds of requirements come up over and over again…

Which means you can speed your SSIS development, and make it more flexible and easier to maintain, by creating an extract template to use each time you start a new project.

Read More

Comments

0 COMMENTS

PHI and MEDITECH’s Data Repository

To address HIPAA, MEDITECH added logging of access to PHI via reports and all applications, and added that level of detail to MIS user activity logs. So, if you run an NPR, RD, or standard report and...Read More

NPR Tip: Various “Gotchas” in MEDITECH field names

What's in a name? In teaching NPR, RD, and SQL from DR, a big chunk of my time is spent helping students figure out where data is kept (for example, which segment in NPR), and then what field names...Read More

DR Tip: A Dynamic Extract Documentation Template

This blog post is designed for readers who use MEDITECH’s Data Repository. As part and parcel of developing ETL extracts for vendors, it is often quite useful to build a technical specification...Read More

SQL Tip: How to Strip Repeating Delimiters from String

This is a small tip, but could be quite useful on the days you need it. Particularly when you work with MEDITECH 6.x PCS data, you will often encounter query response values that look like this:...Read More

SSRS Tip: Adding a Pipe-delimited option to SSRS Export Destinations

End users are very fond of running reports in SSRS and exporting the results to a variety of formats. Excel is probably the most popular, but invariably there will be other formats needed....Read More

SQL Tip: The Good, the Bad, and the Ugly of TOP X

As you’re learning SQL, you will invariably come across the TOP X clause to a SELECT, which allows you to get – for example – the first 50 rows of a query: SELECT TOP 50 ADV.VisitID FROM...Read More

Migration: Export MOX Using NPR

Recently a MEDITECH hospital wanted to export a handful of MOX databases, since they were migrating away from MOX. I have done a few of these in the past on rare occasions (on a “per database”...Read More

Using DR Data Def Tables, Updated for CS/MAGIC 5.67 or MT 6.07/6.15

One of the challenges of DR-based report development is the same as for NPR or RD … where is the data you want stored? One way to find out is to go into MEDITECH and find the field, and — if you're...Read More

SSIS Tip: Formatting Numbers with Commas via Expression

Oh, Microsoft - why do you make us cry? And no, I am not talking about Windows 10. Though that does make me cry a bit. Every day. But enough about me. You (sound developer that you are) have built a...Read More

SQL+DR Tip: Use SSIS Templates to Speed Extract Builds

If you’ve started using Microsoft’s SQL Server Integration Services (SSIS) toolkit to create, schedule, and deliver extracts (machine-readable files) to vendors, non-MEDITECH applications, and even...Read More

SQL Tip: Managing Diagnosis Codes (5.67 edition)

A common challenge in reporting (or extracting data, in this case) that we see over and over again is the need to transform one data structure into another. The best arrangement of data for the...Read More

NPR Tip: Abstract Status Index (Client/Server)

A MEDITECH 6.0 customer recently requested our help to speed up a report she was using to find all accounts with a final abstract date of T-1. Her report, using the “abs.status.x” index was taking...Read More

MEDITECH DR Tip: Data Dictionary Search with Possessives

Some time ago we published a handy tip providing you with a stored procedure you could use to hunt for things in MEDITECH DR data structure(s) — by table name, by NPR DPM, etc. — so you could get...Read More

MEDITECH SSIS+SQL+DR Tip: Using CMS ICD-10 GEM data

CMS Does Not Make Things Easy Sometimes you just have to wonder… New ICD-10 diagnosis and procedural coding has been brought into play in the United Status (October 1, 2015 for diagnosis codes; next...Read More

NPR Tip: Client/Server “Echo Name” feature

In an earlier blog tip I showed how to add an “Echo Name” feature to a MAGIC NPR report, but I did not show a method to do the same thing for Client/Server because I assumed I’d need to use the...Read More

SQL Tip: Auto-printing from SSRS to a Networked Printer

This is probably our second-most requested tip – how do I emulate, from SSRS, the standard MEDITECH scheduled auto-print to a spooled printer functionality? A Bad Idea Before we show you how to...Read More

Testing Code for ICD-10

October 1 is coming fast, which means that this year (2015) US healthcare finally gets to join the rest of the world in using the ICD-10 codeset for diagnoses. MEDITECH is already in reasonable shape...Read More

SQL/SSRS/Data Repository tips, MEDITECH NPR Report Writer tips

Welcome to our Report Writing Blog! Welcome to the Iatric Systems Report Writing Blog. This blog will be the new home to our monthly SQL/SSRS/Data Repository Tips, MEDITECH NPR Report Writer Tips,...Read More

Save Trees and Charge for More ER Supplies

MEDITECH MAGIC or Client/Server – Force a report to PREVIEW and show bar codes for scanning A MEDITECH MAGIC customer recently asked us to produce a report that could show bar codes on the screen of...Read More

NPR Tip: "Echo Name" feature for Customer Report Screens (MAGIC Only)

You may have noticed that MEDITECH standard NPR report screens can have "display only" fields, but in customer reports, there is no attribute or standard method to provide the same feature. In a CDS,...Read More

DR+SQL Tip: Using UNION to Best Effect

MEDITECH migrations platform bring many challenges; one of them being that you may find yourself with a new LIVExDB in the picture and once you’re past the go-live you find that data is flowing only...Read More

DR+NPR Tip: Running Web-based Reports from a MEDITECH Menu

with Mitchell Lawrence, HIS Programmer Analyst at Iatric Systems Overview Many sites using SQL Server Reporting Services will use the External Links feature in MEDITECH to route a user to the "top"...Read More

SQL Tip - Managing Diagnosis Codes

(NOTE: This post only applies to hospitals operating MEDITECH 5.66 or lower. For hospitals operating MEDITECH 5.67 or higher, please refer to Thomas' March, 2016 post. Thank you.) A common challenge...Read More

NPR Tip:  What Happened on March 1st 1980?

MAGIC and Client/Server Time Stamps and how to use them. Example Reports Report with "elapsed time" information Export of Doctor Dictionary Entries created or edited on/after selected date. List of...Read More

SQL Tip —The Data Request Number

As we’ve discussed before in webinars, white papers and in our SQL training classes, we recommend that all DR-based reporting and extracting be driven by stored procedures. Those stored procedures be...Read More

NPR Tip: Every Module Can Have Room and Bed Index (MAGIC or Client/Server)

It is quite common to write reports for current inpatients, and a logical assumption by many NPR report writers is that such reports are best built in ADM, even when the data required is in some...Read More

NPR Tip: Keep Users Entertained During Download or Printing (MAGIC or Client/Server)

If you have a report that users are going to run and wait for, it can be nice to print some kind of progress message to the screen to keep them entertained. The easiest way to do this is to use the...Read More

SQL Tip -- Multi-value Parameters for SSRS

Continuing on from last month, when you start building DR + SSRS reports to replace or supplement NPR or RD reporting, you lose some conveniences from direct MEDITECH integration. One of them is the...Read More

SQL Tip — Facility Prompt by User Access

One of the challenges of moving from inside MEDITECH-integrated reporting (NPR or RD) outside into the realm of DR (SQL + SQL Server Reporting Services or Crystal Reports)- based reporting is that...Read More

Stop at Query if Patient is "on Coumadin" (MAGIC Only)

Someone from Mid Columbia Medical Center in Oregon asked for a way to stop at a query only if a patient was "on coumadin." I am going to interpret that to mean any active PHA order for Warfarin...Read More

SQL Tip -- Check Tables for Data

One of the challenges of the Data Repository (DR) is that we often need sets of tables populated with data and, despite everyone’s best efforts, when the rubber hits the road – one of them is empty....Read More

Getting Most Recent BAR Comment for Account (MAGIC, Client/Server, or 6.0)

A BAR analyst from a C/S hospital posted a request to the "Meditech-L" mailing list, asking for help in including the last billing comment and last billing comment date on a BAR.PAT report. MEDITECH...Read More

SQL Tip — Making Your Own Legos

Today we play with Lego™, or rather we make our own Lego. No, not this way, but in SQL. One of the tremendous things about SQL and the Data Repository is that you can roll your own building blocks...Read More

Writing files from NPR report to a shared folder from a scheduled or submerged report (MAGIC Only)

The only "officially supported" mechanism to write a file to a non-MEDITECH machine is to use FTP. This means you need to set up an FTP as a service on the destination machine, which typically...Read More

NPR Tip (MAGIC only) - Printing Radiology ($T RAD) Text and how to use ECB/ECE loop in a report

In October 2002, we published a tip on how to print Radiology report text in an NPR report. At the time, there was no field or utility to do this (or possibly I just liked to do things the hard way),...Read More

SQL Tip - Parsing Patient and Provider Names

Tis but patient name tis my enemy; Thou art five parts, though not in MEDITECH. What is MEDITECH? It is nor first, nor last, nor suffix, nor prefix, nor any other part belonging to a name. Oh! Be...Read More

NPR Tip (MAGIC or Client/Server) – When Standard Graphics Attributes Fall Short

One limitation of NPR report graphical attributes is that you can only start vertical lines at the top of a box. Here is an example of a page header for a discharge order form: Many preprinted forms...Read More

SQL Tip -  Find Queries, Document Sections and Interventions (MEDITECH 6.x Only)

A report request arrives on your desk – complete with screenshots of screens from MEDITECH complete with circles and arrows. But the fields are unfamiliar… a query to the requestor for a Shift-F9 and...Read More

NPR Tip (MAGIC or Client/Server) – Report to Download with “CSV” Extension Opens Immediately in Excel

At MUSE 2014, the most popular "tip" was probably the demonstration of an NPR report that allows the user to send output to "DOWNLOAD" with a CSV extension on the file and two footnotes on the report...Read More

DR Tip -  Iatric DR SQL and Microsoft Reporting Services Tip ˜ Date Mnemonics

You’ve built a great query, wrapped it up in a beautiful Microsoft Reporting Services report and published it to the SSRS web portal, all ready for your end users to run anytime they want, with the...Read More