Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Potential Issues with Editing OBS values in a Flowsheet?

General Discussion

Last Post by rwilliams 8 years ago

10 Posts

5 Users

0 Reactions

77 Views

RSS

jbaileysemmesmurp

(@jbaileysemmesmurp)

Posts: 25

Eminent Member

Topic starter

Does anyone know of any potential issues that could arise from manually editing the "PATPORTALPIN" obs term in the flowsheet? We have changed the way we register patients for the portal and use a custom banner to notify the registration staff has an account or not. The issue we have is the patients who already previously had an account don't show in the banner correctly. Our solution is to change the PATPORTALPIN obs term in the flowsheet from the PIN to "secmsg" so the banner will recognize this and display the correct symbol. We have contacted GE and SureScripts about this and both have stated they would not recommend editing a flowsheet. GE stated it would mess up the data in the CQR which didn't make much sense? GE also went as far as saying they would not help us with support if any issues came from us manually editing flowsheets. So again I ask, has anyone encountered any issues or know of any potential risks?

Thanks for any feedback.

Posted : August 23, 2016 6:41 am

Scott Forest

(@sforest)

Posts: 527

Honorable Member

gotta love GE and the confidence they have in their products...

Posted : August 23, 2016 7:11 am

Ty

(@thaulk)

Posts: 131

Estimable Member

That absolutely makes no sense! We edit our flow sheets on a frequent basis for other things why would this be any different? Just FYI we are doing the exact workflow you are doing. Waiting on a script from GE/SureScripts to identify all of our "linked" accounts so we can go in and add that secmsg to those accounts.

Posted : August 23, 2016 7:30 am

Ty

(@thaulk)

Posts: 131

Estimable Member

I should clarify we don't change the PIN obs term we just add the secmsg

Posted : August 23, 2016 7:31 am

jbaileysemmesmurp

(@jbaileysemmesmurp)

Posts: 25

Eminent Member

Topic starter

Yea, we received the script to run the report of Linked & Unlinked accounts. We will be removing all unlinked accounts that are not current... unfortunately it will have to be done manually.

Posted : August 23, 2016 7:35 am

jbaileysemmesmurp

(@jbaileysemmesmurp)

Posts: 25

Eminent Member

Topic starter

Right.. that's what we will doing as well. We won't be overwriting any previous data, we will just be adding the "secmsg" to flowsheets of charts that are currently a MET in the CQR.

Posted : August 23, 2016 7:36 am

jsander

(@jsander)

Posts: 108

Estimable Member

Could someone please post or send me a script to identify linked accounts? I wish there were an API integration into Registration to see link status and when an account was last logged in.

As for the concept of never editing the flowsheet, I can understand saying not to run update scripts in SQL, but not allowing edits of the flowsheet is even more ridiculous than the usual GE garbage! We've done similar stuff with banners showing values based on contents of METHCONTACT and PATPORTALPIN. My understanding is that PATPORTALPIN could have just about anything in it. Those random PIN values mean nothing if you're not using the PIN right then to link to a chart.

Posted : August 23, 2016 10:02 am

Ty

(@thaulk)

Posts: 131

Estimable Member

would you mind sharing the script?

Posted : August 23, 2016 10:23 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

I think there was a MU measuer that had to do with generated PIN numbers but I think it is not valid anymore. That might be what GE was referring to.

That being said I would recommend against changing the patients PIN to secmsg. There is no limit to the number of accounts that can be linked to a patient. If anyone knew this they would be able to go into an account and use "secmsg" to link to anyone's account in the system.

You are better off either using a unique OBS or using the METHOFCONTACT obs.

I started writing an interface that would grab all of the patients out of the database that had linked accounts and check for any patients in EMR that did not have the METHOFCONTACT set, then it generates an HL7 message to create the OBS value in EMR. It is slow and dirty and I have not yet deployed it or even fully tested it. It would probably be easier to implement on CPS as it is just querying 2x SQL databases.

Posted : August 23, 2016 10:33 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

You may need to change the ServiceType=2 to something else. That matches us up with our EMR externalid which is our patient identifier in SMPP. If you change it to =1 i think it returns the PID from the PERSON table.

SELECT KUser.Name, KUser.UserName, KUser.Description, DPartner.ServiceType, KEmailAddress.EmailAddress, KUser.CreationDate, DPartner.Identifier, KEmailAddress.IsDefault FROM Enterprise.dbo.KEmailAddress INNER JOIN Enterprise.dbo.KUser KUser ON KEmailAddress.UserID=KUser.UserID INNER JOIN Enterprise.dbo.DCommunityAccount DCommunityAccount ON DCommunityAccount.UserID=KUser.UserID INNER JOIN Enterprise.dbo.DPartner DPartner ON DCommunityAccount.DCommunityAccountKey=DPartner.DCommunityAccountKey WHERE DPartner.ServiceType=2 AND KEmailAddress.IsDefault=1

Posted : August 23, 2016 10:36 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0