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

Repair Script for Masterlock Issue

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

7 Posts

3 Users

0 Reactions

68 Views

RSS

dorotheatrusty

(@dorotheatrusty)

Posts: 148

Reputable Member

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

codyh3

(@codyh3)

Posts: 61

Trusted Member

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

codyh3

(@codyh3)

Posts: 61

Trusted Member

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

Scott Forest

(@sforest)

Posts: 527

Honorable Member

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

dorotheatrusty

(@dorotheatrusty)

Posts: 148

Reputable Member

Topic starter

Can it be used for Centricity EMR?

Posted : March 9, 2016 3:14 am

dorotheatrusty

(@dorotheatrusty)

Posts: 148

Reputable Member

Topic starter

Thank you! Apparently they have a script to go out and find them.

Posted : March 9, 2016 3:15 am

Scott Forest

(@sforest)

Posts: 527

Honorable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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