Does anyone have a script and/or approach they took to Complete In Process orders?
We currently do not have a bi-directional interface with our lab system. This is causing thousands of orders remaining "In Process" because the order is originated in CPS which sends a paper requisition to lab, it is then electronically entered in the lab system and results back via interface back to CPS.
This is one that works on EMR. I am not sure if the orders table is the same in CPS.
Just a word of caution about cancelling these - you must consider the impact it will have on your MU reporting for CPOE orders.
This cancels any order type that is a test and places a reason so you could later report on the ones that were cancelled for your maintenance- which might help you for an MU audit.
update orders set status ='X', cancelreason ='Cancelled-Maintenance task' where ordertype = 'T'and orderdate < TO_DATE('2015-01-01','yyyy-mm-dd') and status ='S';
commit:
Our clinic does not have orders auto complete either. We use this as a check and balance system to ensure our patients receive results. Each week we run a report out of GE (Chart Report > Report > MedicaLogic > Order Status). This report is sent to the staff and they review if patients have had a return appointment, were called or sent a letter with results. If results were given, they complete the orders. If not the patient stays on the list. However, if you have a back log, this may be a time consuming approach.
We currently send orders out via CPS and the order comes back to the Physicians as an unsigned document to their desktop. Once they open the document to sign they have the option to select those orders to complete. We are on CPS 12.0.10.
Since you do have the result going back into emr automatically, it might be possible to have the return result close out the order if you populate the order number information in the lab system when you enter the order.
For our radiology orders, our outbound interface sends the order number but the radiology system ignores it and just stores the number. For the return result it passes that number back in the correct field which tells emr to close out the order. As long as there was a place to store the order number in your lab system (even if it was a manual data entry) and you pass it back in the correct field, it should close out the order. (I am no expert when it comes to HL7 so I could be completely off on this)
We use a free script written by Arnold Cantu:
https://www.aphoenixtech.com/estore/cps/p-79-cps-close-orders-script
The script can be customized to cancel or complete orders. Very handy for closing a lab order from an outside lab.
JJC