October 29, 2014, 5:19 pm

Educational Webcast: Cost Justify Vital Sign and Smart Pump Integration with Your EHR

Learn how you can obtain funding for the integration of vital sign monitors and smart pumps with your hospital’s EHR by attending this webcast from the comfort of your office on 11/4/2014 or 11/12/2014.

You’ll learn how recent research supports the expense of medical device integration, and you’ll take away plug-n-play ROI formulas you can use to help advance this technology at your hospital.

Select a date below to read all of the specific topics that will be covered and register to attend:

More than 150 nursing informatics professionals attended this session during an ANIA-hosted presentation in August. Find out why. Whether you’ve integrated hundreds of medical devices with your EHR — or none — this informative webcast will benefit you.

Register now to attend.

For more information please contact Amanda Howell at amanda.Howell@iatric.com or 978-674-8121

October 29, 2014, 4:21 pm

MUSE Online Peer Group JAM Sessions are Enrolling

PEER GROUP JAM SESSION SCHEDULE

An online JAM session provides dedicated networking time for the peer group participants. Peer group meetings strive to focus on networking, education, and solutions. (Note that Commercial members can be a valuable resource of information, expertise, and experience. They are welcome to participate).

Date Event Date and Time (Eastern) Leader
30
Oct
JAM SESSION – ORM Operating Room Management Thursday, October 30, 2014 11:00 AM Alice Rogers,Clinical Coordinator RN, Hanover Hospital
4
Nov
JAM Session – LTC Long Term Care Tuesday, November 04, 2014 11:00 AM Michelle Williams, Long Term Care Systems Analyst Citizens Memorial Hospital
11
Nov
JAM Session – MU Meaningful Use Tuesday, November 11, 2014 11:00 AM Beverly Bateman Program Manager – Quality & Regulatory Reporting CHRISTUS Health
12
Nov
Peer Group Jam Session – BMV / eMAR Wednesday, November 12, 2014 12:00 PM Cathy Alvarez – Uvalde Memorial Hospital, Uvalde, Texas
19
Nov
JAM Session PEDIATRICS Wednesday, November 19, 2014 2:00 PM Jodi Bush, Business Analyst, Specialist, Cook Children’s Hospital
10
Dec
JAM Session – MHC MEDITECH Home Care Wednesday, December 10, 2014 11:00 AM Jennifer Earl, Systems Analyst for Continuing Care Citizens Memorial Hospital

Source.

October 28, 2014, 11:06 am

HIMSS Analytics Honors Ontario Shores Centre for Mental Health Sciences With Stage 7 Award

HIMSS Analytics announced that Ontario Shores Centre for Mental Health Sciences (Ontario Shores) in Whitby, Ontario, has received a Stage 7 Award. The award represents attainment of the highest level on the Electronic Medical Records Adoption ModelSM (EMRAM), which is used to track EMR progress at hospitals and health systems. Ontario Shores is the first hospital to receive a Stage 7 Award in Canada, and the first ever Stage 7 behavioral health facility.

HIMSS Analytics developed the EMR Adoption Model in 2005 as a methodology for evaluating the progress and impact of electronic medical record systems for hospitals in the HIMSS Analytics™ Database. There are eight stages (0-7) that measure a hospital’s implementation and utilization of information technology applications. The final stage, Stage 7, represents an advanced patient record environment. The validation process to confirm a hospital has reached Stage 7 includes a site visit by an executive from HIMSS Analytics and former or current chief information officers to ensure an unbiased evaluation of the Stage 7 environments.

Read more at himssanalytics.org.

October 24, 2014, 12:42 pm

Meaningful Use Quiz & Answers

Since school just recently started, I thought this month I would do a Meaningful Use (MU) Quiz. Below are Meaningful Use questions I am asked most frequently, and the answers either from FAQs, Factsheets or questions our team has asked the Centers for Medicare & Medicaid Services (CMS) or the Office of the National Coordinator for Health Information Technology (ONC).

Question:  Does Iatric Systems Professional Services offer Meaningful Use assistance?
Answer: Yes, they do offer services for needs such as mock audits, gap analysis, Flex 2014 documentation and many other Meaningful Use Needs. Contact Joe Sainz at Joe.Sainz@iatric.com for more information.

Question: Are newborns excluded from all Meaningful Use calculations and if so, where does it state this?
Answer: Yes, routine newborn accounts are excluded from the calculations for Meaningful Use. As CMS states, those services are not considered acute inpatient services. FAQ 2991 provides more details.

Read more at iatric.com.

October 22, 2014, 12:23 pm

SQL Tip — Check Tables for Data

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

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. The MT task to get it turned on missed it, or you were doing it yourself with a self-service Special IL (if you’re on C/S or MAGIC), and you skipped one yourself.

This is painful to find when you’re deep in the project. There should be a good way to check in advance which tables you need are populated or not. And you can certainly do that by doing a SELECT * FROM… per table. But how about a way to check a bunch of tables, in a batch operation, to see if they have data in them – and how much – in one go?

To this useful end, we’re going to use the capability of T-SQL to execute SQL commands created by other SQL commands in code. This is generally termed “dynamic SQL” and revolves around using the sp_executesql command. The attached code shows a simple and (hopefully) straightforward example of executing a stored procedure like this:

EXEC zcus.dbo.IatricDynamicTableVerify ‘Livendb.dbo.DMisUserStatistics|Livefdb.dbo.MisAuditNprPatAccess_Main|Livefdb.dbo.HimRecAuditNpr_Main|Live

fdb.dbo.HimRecAudit_Main’ ;

To check those four tables to see if they have data, how much in total, the first and last time they were updated and some very simple statistics about them. You’ll get result roughly like so:

TableID

DataRowCount

FirstUpdated

LastUpdated

DataMonths

MonthlyVolume

Comment

Livefdb.dbo.HimRecAudit_Main

35,056,210

2012-11-02 21:02:09

2014-10-08 22:17:45

23

1,524,183

Livefdb.dbo.HimRecAuditNpr_Main

15,223,878

2012-11-02 21:08:39

2014-10-08 22:07:40

23

661,907

Livefdb.dbo.MisAuditNprPatAccess_Main

9,575,012

2013-12-17 10:19:53

2014-10-08 22:05:19

10

957,501

Livendb.dbo.DMisUserStatistics

5,039,040

2012-11-02 14:53:00

2014-10-08 22:04:00

23

219,088

When you dig into the code you’ll find that we create some tables to manage the “buckets” we want to check – that we use the IatricSplit() function (also attached to this tip) to break up the pipe(|)-delimited list of table names into a little table of its own – and then we loop (using WHILE instead of cursor, because cursors are evil…) through the list of table names passed in.

Within each loop we compose a SELECT statement in a text string, bringing in the name of the table to check, and then we EXEC the “created” statement to query the table for how many rows of data it has, when it was first and last updated and the average monthly volume of rows added to the table.

   SET @cSQL = ‘SELECT MAX(‘+CHAR(39)+@cTableID+CHAR(39)+’) AS TableID’+

‘,COUNT(*) AS DataRowCount’+

‘,MIN(TBL.RowUpdateDateTime) AS FirstUpdated ‘+

‘,MAX(TBL.RowUpdateDateTime) AS LastUpdated ‘+

‘FROM ‘+@cTableID+’ TBL ;’

Putting this text string together is pretty simple, save perhaps for the use of CHAR(39) to embed single quotes inside of a single-quoted string. We do that because sometimes you do need to embed quotes and the CHAR() function is a straightforward way to do that.

Note also the use of the WHILE/@nIndex structure – this is a good, lightweight way to loop through a table of “things to do” while avoiding the use of a cursor.

Dynamic SQL can be used for lots of things; from this framework however you can expand the code to do batch operations on lists of tables which can be tremendously useful.

Extra Credit

Make a faster version that just gets the DataRowCount and use it to check that all of the tables you need for your Meaningful Use Stage 2 queries are populated. This gives you a counter-check to the MT process in mt_pr_2014_TableHealthCheck.

More Extra Credit

Review the attached code for the IatricSplit stored procedure as well. It may look a little strange, but it will parse out a very long string of delimited-by-something codes into a table of with each value in the ITEM field. So that this…

SELECT ITEMS.* FROM zcus.dbo.IatricSplit( ‘|’,’2WA|2N|2S’) ITEMS

Gets you:

ITEM

2WA

2N

2S

When used with Microsoft Reporting Services, you can easily build a delimited list of items picked in a parameter in the report, pass the string into the stored procedure and then break the list apart again into a table. And then… use that table in a JOIN or WHEN to limit results.

(end)

Visit our report library at http://www.iatric.com/Information/NPRReportLibrarySearch.aspx to look them up.

You can find additional Report Writing Tips on our website at http://www.iatric.com/Information/NPRTips.aspx, as well as information about our on-site Report Writer Training and Report Writing Services.

To subscribe for email notifications for new Report Writing classes, please follow this link:

http://www.iatric.com/Information/Classes.aspx.

For more information, please contact Karen Roemer at 978.805.3142 or email
karen.roemer@iatric.com
.

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

October 22, 2014, 12:20 pm

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

Joe Cocuzzo, Senior Vice President – Report Writing Services

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 had provided code to loop back through the transactions and get the last “c” type transaction and then get the date, but this would stop on system comments also. MEDITECH also tried to provide code to get the comment itself, but the logic provided was not quite correct.

There are two issues to overcome for this report:

  1. You need to loop backward to the most recent “c” type transaction, but also skip any system transactions.
  2. You need to get the transaction text from a child segment under the transaction, as MEDITECH stores billing comments in multiple lines.

Step one is to take a look in a billing system and see what system comments look like, so we can figure out which transactions to exclude from our logic that will “back up” to the most recent comment made by a human, vs. the comments from automatic stuff in B/AR.

Even those of us that write NPR reports all day don’t exactly recall what system vs. user comments look like, so we write a quick report at the transaction text level to see what things look like; we need to write our quick report here:

NPR Tip

NPR Tip

Our quick report just gets some accounts and shows us all the “c” type transactions:

NPR Tip

NPR Tip

NPR Tip

So, how do we write some computed fields or attributes or macro code to get the last “real” comment date, and the comment text from that comment?

First, the date, we go “backward” (@Prev goes from largest to smallest transaction urn) until we hit a “c” type transaction where the user is anybody but BKG DAEMON.  Hang on to the txn urn in the variable FND, which also serves as a flag to stop our backward looping.

[MAGIC Users Please Note:

In MAGIC, it appears that comments from automatic processes have the user that happened to start the BAR background job, so you’d need to do some more sophisticated screening of system stuff than you need to do in C/S.  Possibly looking at @txn.comment for "NSD" and other automatic comments would work.]

Note that at the end of this loop, FND holds the @txn.urn we want and txn.urn is one less than that transaction, because the @Prev happens one more time before we check FND and stop looping because it has a value (i.e. NOT FND no longer true).

NPR Tip

Now we need to write some code to show all the transaction text for the comment. We could build an MV array and load it with the transaction text, but then you either have to use a utility to keep the field number subscript dynamic and unbreakable (highly recommended) or hardcode a field number and take the risk that an edit could break your report. Instead, lets write one computed field for the first text line, and wrap a DO loop around a second computed field to handle the rest of the text lines.

The first comment line is a simple computed field that just uses the txn.urn from FND and has a hardcoded 1 to print the first line

NPR Tip

For the rest of the lines, we wrap a loop around a second “D” line as follows:

NPR Tip

The field to print line 2 through N is:

NPR Tip

So our report written at the “top” (main) level is now smart enough to go through the transactions in the child segment and find the last comment, then go through the text in the grandchild segment and print the lines out.

I have added a horizontal line between accounts to make output clearer:

NPR Tip

A sample report, in MAGIC and C/S BAR.PAT.zcus.is.last.comment.and.text has been placed in our report library.

Visit our report library at http://www.iatric.com/Information/NPRReportLibrarySearch.aspx to look them up.

You can find additional Report Writing Tips on our website at http://www.iatric.com/Information/NPRTips.aspx, as well as information about our on-site Report Writer Training and Report Writing Services.

To subscribe for email notifications for new Report Writing classes, please follow this link:

http://www.iatric.com/Information/Classes.aspx.

For more information, please contact Karen Roemer at 978.805.3142 or email
karen.roemer@iatric.com
.

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

October 21, 2014, 11:21 am

Cost Justify Vital Sign and Smart Pump Integration with Your EHR

The CAQH® Committee on Operating Rules for Information Exchange (CORE®) today announced that healthcare organizations have voluntarily earned more than 150 CORE Certifications and many additional organizations have pledged to become CORE-certified. These commitments are a promising development in the drive to achieve interoperability through end-to-end adoption of healthcare operating rules.

The CAQH CORE Operating Rules and voluntary Certification program are the result of an ongoing national collaboration among providers, health plans, vendors, associations, government entities, standard-setting organizations and others essential to improving claims-related transactions. Incorporating both data content and infrastructure, the operating rules enable high-quality, uniform data exchange across the healthcare system and support the integration of clinical and administrative data.

Read more at insurancenewsnet.com.

October 21, 2014, 11:02 am

MEDITECH’s Recommendations for Ebola Screening

October 20, 2014 - MEDITECH strongly advises that healthcare organizations follow the guidance provided by the Centers for Disease Control and Prevention (CDC), to have processes and protocols in place for proper Ebola screening and documentation.

The CDC has provided an evaluation algorithm as well as a checklist for thorough screening. While MEDITECH’s Electronic Health Record (EHR) is designed to enable pertinent patient data sharing between care teams, the communication of suspected Ebola exposure must also take place in person between clinicians.

Read more at meditech.com.

October 21, 2014, 11:00 am

MEDITECH: Out with the Old, In with the News

We will soon be starting a whole new chapter in the evolution of MEDITECH.com. Our reenergized website will be easier to use than ever before, and will include a variety of new content and features – including a sortable News page, where you can get all of the latest information, in a format that is even more readable and shareable.

After this month, we will be discontinuing our monthly MEDITECH Magazine and centralizing all of our company announcements and customer success stories on the homepage of MEDITECH.com. For many years, the Magazine has been a wonderful vehicle for us to share our most important stories, however, we are eager to begin a new tradition of more real time content sharing with our streamlined site.

Read more at meditech.com.

October 21, 2014, 10:55 am

MEDITECH: ROI Success

Bristol Hospital’s President and CEO shares how implementing MEDITECH has delivered a strong return on investment and a more engaged medical staff.

Source.