Notifications
Clear all
Topic starter
We are experiencing an insane amount of locked documents since our upgrade to 9.8. We have 20-25 documents a day that are signed, but when trying to start a new update, we get a message that there are unsigned clinical list changes. the document referenced in the popup is a signed document. We use the admin tool to unlock and move on, but it is extremely frustrating for our providers and although GE has been trying to help, they really have no idea what is going on. They have told us they think we have an extra "]" in one of our forms. I have searched and searched...there are none. Any thoughts???
Posted : December 11, 2014 5:40 pm
This is something GE changed, what it is, is that the document may have all clinical list changes signed but is stuck on locked. You have to run a script to unlock them, under the PatientProfile, it will have a MasterLock, if the masterlock is = to a signed document's SDID, you will get this issue...
Email me at [email protected] and I can send you the script that will unlock all documents that are already signed off and should resolve your issue since I cannot post it on here as it will not allow me to post script.
Posted : December 12, 2014 4:09 am
So Arnold, do you know what is causing the document to get stuck on locked? Is there a sequence of events or just random, no particular reason? Also, the script, is it a sql script that can be used on CPS12?
Posted : December 12, 2014 4:28 am
I believe it's a glitch, not sure what exactly is telling it that it has clinical list changes still, even when signed, but there must be some sort of job that runs sometime during the up-time of the server to take the MasterLock back to locked. Not sure.
The script I have will work with Both CPS and EMR (MS SQL and Oracel)
Posted : December 12, 2014 5:06 am
We have had an issue with the ] and located it in our document templates, it shows up at the very bottom of the list of forms, the last form in the list has ]] after it. I click into them and remove the additional ]. The problem with this work around though is any time you import a new form and it updates that document template the ] will come back. Good luck, Stacy
Posted : December 12, 2014 5:45 am
Not sure if that is what is causing the issue Stacy as that is just text in the text field. When you sign the document off it is broken off into DOCDATA. This should not effect the Clinical List Changes.
Posted : December 12, 2014 5:48 am
Stacy,
I too have gotten that for years. Every time I load a new form I go through all the document templates and remove the ].
Posted : December 16, 2014 10:45 am
NateK Test - ignore
UPDATE PATIENTPROFILE SET MASTERLOCK = 0 WHERE MASTERLOCK IN (SELECT SDID FROM DOCUMENT WHERE STATUS = 'S')
Posted : December 19, 2014 10:43 am
<>
Arnold, Could you post that script now, or send me the script ? I have some locked documents and we just upgraded to 9.8, so want to be able to deal with any further locked documents.
Thank you 🙂
- Beverly
Posted : December 23, 2014 12:10 pm
UPDATE PATIENTPROFILE
SET MASTERLOCK = 0
WHERE MASTERLOCK IN (SELECT SDID FROM DOCUMENT WHERE STATUS = 'S')
Posted : December 23, 2014 12:13 pm
This happens most frequently to us when our providers log into the encounter on two computers, signs the encounter on one, and then makes a change to the document on the other.
Posted : February 1, 2015 10:31 am
