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

Force signature of clinical list changes via SQL?

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

7 Posts

6 Users

0 Reactions

90 Views

RSS

clafty

(@clafty)

Posts: 37

Trusted Member

Topic starter

We placed a ticket in with GE 2 weeks ago about a signed document in chart that has unsigned clinical list changes. I went into the database and marked the document as unsigned so it can be re-signed, but that did not sign the clinical list changes. Does anyone have a SQL script to force these clinical list changes to be signed. I am so tired of waiting for GE support.

Posted : October 10, 2016 7:57 am

clafty

(@clafty)

Posts: 37

Trusted Member

Topic starter

After further research on CHUG, it was suggested that I try the centricity admin toolbox. Bingo, using a tool written 4 years ago, to the rescue. I can't believe I can find the answer in 2 minutes on CHUG and GE can't get back to me with a simple call.

Posted : October 10, 2016 8:13 am

swhite

(@sbrooks)

Posts: 84

Trusted Member

There was an "Unsigned Clinical List" kit released in May.
The kit includes a script to find and sign clinical list changes in the database that didn't get signed with the document.
I kept a copy of the kit. Let me know if you'd like a copy.
[email protected]

Posted : October 10, 2016 8:19 am

caswelljm

(@caswelljm)

Posts: 80

Trusted Member

There is a job that fixes things similar to this issue. Perhaps run that first to see if it resolves your issue.

It's called "FixInconsistentClinicalData" it runs nightly for us. Depending on your version of CPS,

--SQL Query --exec dbo.Exec_ida_FixInconsistentClinicalData

Posted : October 10, 2016 8:19 am

relliott

(@relliott)

Posts: 145

Estimable Member

This sounds like the same thing we have a lot anymore. I finally got a query from GE.

This is the Masterlock Patient clear query to run when this happens. We are on EMR 9.8.

sqlplus ml/ml@emr

set numwidth 16;
set linesize 100;
set pagesize 500;
select masterlock,lastname from person where patientid=' patient id from reg';

update person
set masterlock='0'
where patientid='patientid from reg';

1 row updated.

commit;

Hope this helpls.

Posted : October 11, 2016 2:45 am

jessicaw

(@jessicaw)

Posts: 434

Prominent Member

Was the kit available on the engage website? I am not having any luck finding it there.

Posted : October 18, 2016 4:13 am

denabottoms

(@denabottoms)

Posts: 12

Eminent Member

We are also having issues with Unsigned Clinical Changes that are tied to duplicate documents. This has nothing to do with the Unsigned Clinical List Change script we received already. This is on pdf documents that should not have unsigned clinical list changes. Do you know if your issue is based on duplicate documents? GE is currently reviewing a trace on our DTS to see if there is an issue with certain types of documents. Right now this issue causes a master lock in the chart. Once the lock is removed, the user can document clinical list changes. We normally have to unlock 3-5 charts a day since we upgraded to 9.8.

Posted : October 19, 2016 9:12 am

Share:

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