Notifications
Clear all
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
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
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
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
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
Was the kit available on the engage website? I am not having any luck finding it there.
Posted : October 18, 2016 4:13 am
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
