Notifications
Clear all
General Discussion
4
Posts
3
Users
0
Reactions
77
Views
Topic starter
Hello,
This might be an easy one for life of me I am not having success. We have several orders that are being completed randomly by staff members. The only time frame I know is within a month or so and I don't have a clue who could be doing it so I am unable to audit a person. Is there a simple way to see who completed an order in the system? It seems like it should be in the 'view order history' or 'view details' -- there has to be a trail and I am driving a struggle bus trying to find it. Any assistance is appreciated!
Thank you!
Posted : January 11, 2018 4:56 am
I was having an issue with this also so I looked at when the order was last updated in the view history section of the order and then I went to the patient's chart access report and looked for the user who was in the patient chart at the same time. This should tell you who is completing the order. We were having issues with our providers completing all of the referral orders when they signed off on their labs and the box comes up to complete order. They were checking all of them.
Posted : January 11, 2018 5:21 am
Topic starter
That makes sense-- albeit a bit annoying that we don't have an easier way but at least that will get me to what I need! Thank you!
Posted : January 11, 2018 5:36 am
Here's a script that I believe will show you what you want to see. You can change the date range to whatever you wish.
select pp.patientid,usr.loginname,usr.lastname + ' ' + usr.FIRSTNAME as [Name], orders.status,orders.DESCRIPTION
from orders
inner join usr on usr.pvid=orders.PUBUSER
inner join patientprofile pp on pp.pid=orders.pid
where orders.status = 'C' and ordertype = 'T' and orders.orderdate between '01/01/2018' and '02/01/2018' and xid = 1000000000000000000
Posted : January 11, 2018 5:55 am
