Capturing the Controlled Drug Report Button Press

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

1 Posts

1 Users

0 Reactions

67 Views

RSS

bhoover

(@bhoover)

Posts: 360

Honorable Member

Topic starter

Hello All,

I was curious if anyone has tried to capture when their providers press the "Controlled Drug Report" button on the Prescriptions form. Our doctors have asked for a heads up to let them know they have looked at it during the visit. The form as provided doesn't give any visual cue if the button has been pressed.

I looked and it seems that when you press the button it writes to the AUDIT_EVENT table a value of '10024' in the EVENT_TYPE_ID. Other than using Dr. Fitzgerald's process for pulling data (see below), any thoughts on how to grab this to prompt the providers?

https://centricityusers.com/wp-content/uploads/2014/11/GETTING-THE-DATA-YOU-CAN%E2%80%99T-GET-When-MEL-just-isnt-enough.pdf

Thanks,

Brad

Posted : December 11, 2018 8:34 am

24 Forums
9,943 Topics
39.9 K Posts
5 Online
6,472 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed