Stay up to date with insights, tips, and education from experts in healthcare IT.
Wait, what is “time blocking”? It’s generating a list of start and end dates/times in a result set, and then using that set of rows to do something else, like: Generate a set of extract files for a vendor, with one set of files per time block…
In the MEDITECH report writing world, an old, old “gotcha” for database programmers is to write a report query that selects by Discharge Date, and then when the end-users run the report, they eventually realize that they are only getting patients discharged on the last date of…
Teach a man to fish… One of my staff needed to create a custom lookup in a MEDITECH NPR report to show the “mapped from” and “mapped to” values for a particular BAR.CLAIM map, and he asked me, “Have you ever done that?” The dictionary looks like…
One of many nice things about the MEDITECH system is the availability of date mnemonics that you can use, either when running reports interactively, or when scheduling them. But this functionality is not available in SQL Server Reporting Services (SSRS) or in SQL Server Integration Services (SSIS)…
This example is based on how discharge text data is formatted in the MEDITECH MAGIC Data Repository (DR). In the continuing saga of trying to recreate patient discharge instructions from the DR, I discovered that among the complications is detecting where line breaks should actually go. Set…
