Notifications
Clear all
Topic starter
Does anyone know if the repair script GE promised to find locked charts and unlock them is available? Has anyone used this script yet?
Thank you.
Posted : March 8, 2016 10:33 am
I don't know if anything has been released, but I do have this information from GE on how to unlock them:
Just open SQLPLUS and log into your database. Then use these commands:
(it's important to copy and paste all three of these together)
set numwidth 16;
set linesize 100;
set pagesize 500;
SELECT PID,PATIENTID,SEARCHNAME,MASTERLOCK FROM PERSON WHERE PATIENTID = 'xxx-xxx’;
UPDATE PERSON SET MASTERLOCK=0 WHERE PID=xxx;
=== if you see one update, commit
COMMIT;
=== If you see more than 1 update,
ROLLBACK;
Posted : March 8, 2016 11:11 am
Here's a little write up I did for our internal staff:
Clearing Master Lock
Pull patient up in EMR
Identify Patient ID #
Log into EMRSRV
Find the “Clear Master Lock” text document on the desktop and Open
Go to the start menu and type sqlplus
It will open a black box asking for a username enter: ml/ml@cpo
In the text document you will see:
set numwidth 16;
set linesize 100;
set pagesize 500;
Copy all three lines of those from the text document
Go back to the black window, on the title bar right click, hover over edit, then click paste
It will paste those 3 lines into the command prompt, now hit enter and you should see: SQL>
Paste the patient ID into the text document on the next line where it says ‘XXX-XXX’ then copy that entire line.
Go back to the command window, right click on the title bar, hover over edit, click paste
Hit enter
It will now show another string of numbers relating to that patient in the database. We want to copy the long one that will look something like: 1723475703406180
Go back to the text document and paste that number on the next line where it says “WHERE PID=xxx” where the xxx is
Now copy the entire command and paste it in the command window
Hit enter
Then if it shows 1 record to update you will type “COMMIT;” and hit enter
If it shows more than 1 update, type “ROLLBACK;” and you have done something incorrectly.
Posted : March 8, 2016 11:12 am
http://triadt.com/downloads.php
this was something published by fellow CHUG user. Apparently GE does have something for official use but it strangely looks exactly like his. So he changed the name of it and added some more functionality.
Posted : March 8, 2016 11:36 am
Topic starter
Can it be used for Centricity EMR?
Posted : March 9, 2016 3:14 am
Topic starter
Thank you! Apparently they have a script to go out and find them.
Posted : March 9, 2016 3:15 am
good question, you would have to contact the developer for an answer to that one, I only work with CPS
Posted : March 9, 2016 3:30 am
