July 24, 2014, 5:52 pm

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

Joe Cocuzzo, Senior Vice President – Report Writing Services

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 have slightly different graphics for a page header, looking like this, leaving a space in the upper right for an “address-o-graph” stamping:

How could we reproduce this on an NPR report?

You can produce a vertical line, horizontal line, or grey or white box anywhere on the page in a C/S or MAGIC NPR report by using the utility Z.graphics, which has the following arguments:

Arguments:       A = Box type   0 – black border

1 – grey box

2 – grey box and black border

B = length of box

C = ht of box (DFT=1)  (can be 0 for just a horizontal line)

D = number of chars to move right (+) or left (-) before starting box

E = number of chars to move down (+) or (-) before starting box.

F = gray scale (default = 10%)

G = width of lines (DFT=5)

So if we remove the BX command from the page header of the report, and use the HL= (horizontal line) command to draw a line across the bottom of the page header, we can just add a call to Z.graphics to draw the vertical line down from the top of the page to the vertical line:

Let’s review how we are using the Z.graphics command.  To draw our box, we pass the following arguments:

A = 0, this means we want a black border box

B = 0, length of box is zero which means we are drawing a vertical line.

C = 6, make the box 6 lines high (decimals are accepted as values)

D = 65 move to the right 65 spaces before starting the “box” (really a line here)

E = 0-5.5  We need to move up 5.5 lines so we subtract 5.5 from zero for the “move up” argument.  We could also pass “-5.5” as the E argument.

F = not relevant, no grey shading

G = width of line (0-9 accepted)

(Note that to draw horizontal lines, you pass a non-zero length and a zero height).

We could also use an LC attribute to hold our Z.graphics code:

A LC expression becomes the condition of an IF statement that is wrapped around the line. So if you use an LC for other purposes, you need to decide if you need your line to print or be suppressed.  To control what happens, add a nil or a value at the end of your LC expression, and that will control the value of the IF condition and will control whether the line prints.


If you have Boxes anywhere on your report, MEDITECH will automatically create a box around the entire page, so unless I add a special footnote to this report, I will still get this:

To prevent the default boxing add the following footnote to your report. (This footnote also will suppress the boxing of the standard page banner if your report has one).

Once we have done this, the automatic boxing of the page no longer occurs:

This article originally appeared in the July 2014 issue of Iatric Systems Updates! newsletter.

July 24, 2014, 5:49 pm

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

Thomas Harlan, Technical Team Lead – Data Repository at Iatric Systems

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 screenshot of the resulting pop-up yields nothing. “Ah,” you think, “custom queries on a CDS, document section or intervention. Why oh why didn’t MEDITECH code Shift-F9 so it would tell us what query mnemonic was in play? Why?

But fear not, thanks to the DR xfer process also covering dictionaries, you can use SQL to query the build of screens, assessments, and interventions. Attached to this tip is a stored procedure that searches the dictionaries for usage of queries and lets you know not only which screens they are used on, but which collector tables contain the responses!

As with all of our example SQL code, you will need to run the script against your DR to compile a named query (or stored procedure) that you can then call with a simple SQL command like:

EXEC zcus.dbo.MIS_zcus_iatric_find_query_config ‘CAN.OX’ — Query mnemonic to search for or ALL

,’ALL’ — Query text to search for or ALL

,’ALL’ — Document Section Mnemonic or ALL

,’ALL’ — Document Section text or ALL

,’ALL’ — Intervention Mnemonic or ALL

,’ALL’ — Intervention text to search for or ALL

,’N’   — Show Row Counts from storage locations

Note that each parameter drives a LIKE predicate in the code, so you can search for partial strings (or use wildcards like % and _).

Also note that you can mix the fields, using some or all of them.

Those screen shots you got? With the circles and arrows? Use the text labels from the fields to search by Query Text and you will find what you’re looking for.

In this example our search finds us five records:

Query ID

Query Text

Query Type

Group Response ID

MIS Doc Sect ID

MIS Doc Sect Name

Pcs Intervention ID

Pcs Intervention Name


O2 Delivery Method




Radiology D/C documentation




O2 Delivery Method




Cancer Center Documentation


Cancer Center Documentation


O2 Delivery Method




Cancer Center Documentation


Documentation for Ambulatory Services


O2 Delivery Method




Radiology RN Documentation


Radiology RN Documentation


O2 Delivery Method




Radiology D/C documentation


Radiology RN Documentation

Here we see that the CAN.OX query can be find on four different document sections in three different interventions – or as a standalone.

Particularly when you are trying to retrieve PCS assessment query data, your speediest way to get at the response is to first identify potential visits, then search those visit’s interventions, then document sections and then finally the query/response data. Knowing which interventions and document sections hold the queries you are looking for will speed up that process enormously.

A Warning Note: But wait, you say, what about RegAcctQuery_Result? Doesn’t it hold all of the PCS query responses? Isn’t it designed to be reported against so you don’t have to plunge into the hellish complexity of the PCS tables?

Yes, but… a query needs to have its AccountQuery flag set to Y before the responses will flow over to RegAcctQuery_Result and the background job that populates the table from the PCS tables needs to be working flawlessly.

Unfortunately, for the data that you need for this latest report… that probably won’t be true. So back to the PCS mines for you!

Bonus! Attached to this tip, in addition to the SQL code, is a Microsoft Reporting Services report to package it up all pretty-like and make it easy to distribute to your analysts.

Extra Credit: When you examine the code, you’ll find that the @cRowCountYN parameter does not search every single possible response storage location. Add some more! Particularly if you know there are custom screens attached to modules like MM or BAR at your organization.

This article originally appeared in the July 2014 issue of Iatric Systems Updates! newsletter.

July 24, 2014, 12:51 pm

MEDITECH: The Windy City

SHARE. LEARN. ENGAGE. September 9.

What’s all the buzz about?

  • Learn how to use the system you have right now to meet your strategic goals.
  • Attend new sessions on topics like Clinical Decision Support, the Physician Status Board, and Pre-Admission and Mobile Ordering.
  • Share ideas and lessons learned with your peers and MEDITECH’s support team.
  • Hear success stories during the Customer Clinical Panel.
  • Engage with our physician consultants.


Learn more at meditech.com. Or check out their video about the Getting the Most from Your MEDITECH System.

July 24, 2014, 12:42 pm

MEDITECH: 6.0 Leads Memorial Health Care Systems to HIMSS Stage 6

Just seven months after implementing 6.0, Critical Access Hospital Memorial Health Care Systems (Seward, NE) achieved HIMSS Stage 6, proving hospitals with limited resources can be IT leaders when they have a dedicated staff and the right EHR.

“We had a clear vision from the very beginning and decided that ultimately, we wanted to be an innovation leader, not a follower,” says Director of IT Mark Criner. “Thanks to great C-level support, along with our MEDITECH partnership, we’re reaching our goals.” 

Read more at meditech.com.

July 22, 2014, 1:02 pm

Patient Portals: If I Build It, Will They Come?

Thursday, Jul 24, 2014 2:00 PM – 3:00 PM EDT

Attend this educational session to learn why your hospital needs a patient engagement plan for your portal, and how it impacts your attestation while benefiting your patients at the same time.

This session will cover:
• What’s included in a typical patient portal engagement plan
• How you can quickly get an engagement plan up and running
• Stakeholders to include in your plan
• Frequently overlooked elements of a patient engagement plan
• Examples of how hospitals have seen considerable
value from their patient engagement plans

Join us to discover how to maximize adoption of your portal while meeting (and exceeding) critical attestation requirements.

July 17, 2014, 12:37 pm

50 Things to Know About Epic, Cerner, MEDITECH, McKesson, athenahealth and Other Major EHR Vendors

To improve the quality of our healthcare while lowering its cost, we will make the immediate investments necessary to ensure that, within five years, all of America’s medical records are computerized.” — President-elect Barack Obama, Jan. 8, 2009

Five years later, billions have been poured into the transition to electronic health records. As of May, CMS has paid out a total of $14.6 billion in incentive payments to hospitals and health systems for the adoption and use of EHRs. These incentive payments, coupled with the looming threat of financial penalties for non-adopters and a need to better coordinate care have driven providers to rapidly adopt EHRs over the past few years. The EHR market is expected to reach $9.3 billion annually by the end of 2015.

As the EHR market has matured, a once-crowded field of vendors has narrowed significantly. At the end of 2013, 10 EHR vendors accounted for about 90 percent of the hospital EHR market, based on meaningful use attestation data from CMS: Epic, MEDITECH, CPSI, Cerner, McKesson, Healthland, Siemens, Healthcare Management Systems, Allscripts and NextGen Healthcare.

Read more at Becker’s Hospital CIO.


July 16, 2014, 12:47 pm

MUSE International Conference Recordings


July 15, 2014, 12:57 pm

MEDITECH Celebrates 45 Years of Healthcare Innovation

MEDITECH is celebrating its 45th year in business! A longtime leader in the health IT industry, we’ve built our reputation on providing integrated software and service for acute, ambulatory, long term care, and home care settings.

MEDITECH was founded on August 4, 1969 by the innovator of the MUMPS programming language, A. Neil Pappalardo. Today, we have over 4,000 employees, spread across nine facilities in Massachusetts, two in Minnesota, and one in Atlanta.

Read more at meditech.com.

July 15, 2014, 12:54 pm

MEDITECH: Fantastic Forum!

Inspiring Nurses, Inspired Care

MEDITECH’s twelfth annual Nurse and Home Care Forum explored how a supportive environment— enhanced by an integrated EHR—helps to keep nurses energized, and focused on what matters most.

Laughter: Still the Best Medicine

Wellness Educator Bobbie Staten offers her suggestions for using humor to balance work and life stress.

Read more at meditech.com.

July 14, 2014, 12:48 pm

MEDITECH: Scenes from the 2014 Nurse and Home Care Forum