Notifications
Clear all
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
gotta love GE and the confidence they have in their products...
Posted : August 23, 2016 7:11 am
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
I should clarify we don't change the PIN obs term we just add the secmsg
Posted : August 23, 2016 7:31 am
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
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
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
would you mind sharing the script?
Posted : August 23, 2016 10:23 am
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
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
