Notifications
Clear all
Topic starter
I have inadvertantly created an inifinite / unending IF statement. woops. Or at least I think that's the problem. It does not occur when one indifidual form is loaded but when a certain combination of forms is loaded.
Does anyone know of a way to get rid of this document? Every time I try to join the update, EMR basically stops responding and I have to close it in task manager. I can't sign it or discard it. It's just sitting on my desktop. Any help would be greatly appreciated!!!
Posted : August 19, 2015 1:30 pm
Download Centricity Administration Toolbox. You will need help from your IT support to supply the necessary information: database host IP, database name, database admin user, database admin password. You also need the Doc ID. Good luck.
Posted : August 19, 2015 1:54 pm
Topic starter
Thanks!
Posted : August 20, 2015 4:54 am
You may also be able to just contact GE for a quick fix. In the past when I've encountered this, they've hopped on the phone and just used the SQL Command Line to change the status of the document from "On Hold" to "Unsigned" which allows you to use the EMR "Actions->Documents->Remove" option to clear the document, rather than trying to open and encountering the buggy code.
Posted : August 20, 2015 5:32 am
Topic starter
ok great idea. That would be ideal
Posted : August 20, 2015 5:44 am
I have a sql script that you can use to remove the forms from an update. It is a multi step process but it will remove the forms from the note and it will allow you to then open the note and either load new forms or discard or file it in error.
Here it is.
-- Step 1: Find the SDID, PID, and chart by date using patientid from patients chart
select d.sdid, pp.pid, db_create_date,d.NOTETEXT
from patientprofile as pp join document as d on (pp.pid = d.pid)
where pp.patientid ='194012' and not(d.NOTETEXT = '' or d.NOTETEXT is null)-- Step 2: To see NOTETEXT, enter SDID and PID from Step 1 for correct date to verify correct chart document
select db_create_date, notetext, * from document where pid = xxxxxx and sdid = xxxxx-- Step 3: To clear NOTETEXT, enter SDID and PID from Step 2, execute begin tran, execute update document set before executing commit
begin tran
update document set notetext = null where pid = xxxxxxxxxx and sdid = xxxxxxxxcommit
-- If wrong chart document, select rollback before executing commit
rollback
Posted : August 20, 2015 11:29 am
