I've been tasked with putting together some baseline metrics around how much time clinicians actually spend "charting". Now, in SQL I can pull when an update was started, when it is contributed to but nowhere can i link when it was put on hold. The Audit_Event table and DocContb table don't log anything about when a document is put on hold. I've bound these two tables together and have a formidable query that shows me the steps they've taken from the time it is started to the time it is signed but the data is inaccurate unless I can subtract the time the document is on hold. Has anyone tackled anything like this? I've just about decided that it isn't tracked anywhere but figured I'd run it out past the group in case I'm missing something.
Greg Fishback | Director of I.T. for GreenField Health
Audit events changed a bit in CPS 12, but we have an audit event labeled "Place document on hold", what version are you on and do you have that event enabled?
I had completely forgotten about that. Unfortunately when I looked, "Place Document on Hold" is set to be logged but it is not recording in the Audit_Event table. There are no Event_Type_ID's of 118 anywhere in my entire Audit_Event table. Looks like a potential bug in CPS-11. I'll fling it past GE. Thanks for the use of your brain!
Greg Fishback | Director of I.T. for GreenField Health