Notifications
Clear all
Topic starter
Hi All,
Has anyone been able to successfully audit who changed a patient contact in registration (there by changing that contact for every patient in the system)? We have this problem pop up fairly regularly and I cannot figure out how to report on it. I thought (since contacts are stored in the person table) I could look at the HISTORICALINFO table for the "new" contact but that appears blank (at least in 9.8.6) - doing this link returns no values for me (since nothing exists in the table for this person).
The best I can do is find out when it was changed but that doesn't help very much. I can't find an audit event related to "changed contacts" either. In the EMR it does warn the user but does it not track this warning in the database for auditing purposes?
I'd be very appreciative if anyone can assist... I find it hard to believe GE would design a system that allows someone with no access to the settings area to change the actual database entry for contact without having at least some auditing around it but, then again, this is GE.
Thanks
Mike
Posted : July 27, 2015 7:54 am
The Activity Log should list when it was changed and who changed it:
While in the Registration click on View>Activity Log. Set the date range to the appropriate time period or make it broad if you don't know. Action = UpdateActivity = Patient Contacts
Component = Registration Click search.
Posted : July 27, 2015 8:11 am
Topic starter
Hi Mike,
Does that work for CEMR? On my registration screen the only "View" option I have is to view all flags associated to the patient (next to the "new" flag icon) - am I missing something obvious?
Thanks
mike
Posted : July 27, 2015 8:28 am
Yeah, I'm not sure if it is available on CEMR. CPS has a table called ActivityLog where it tracks things like this, but it also has the HISTORICALINFO table.
For CEMR, you should be able to get this out of the AUDIT_EVENT, AUDIT_EVENT_DETAIL, and AUDIT_EVENT_TYPE tables. There should be an event called "Change a patient contact" that would contain this, but you have to make sure it is set to log these events within administration.
Posted : July 27, 2015 9:13 am
We have CPS, too, but this may pertain to CEMR. The PatientContacts table contains a LastModifiedBy field that can be seen in a SQL query.
Posted : July 28, 2015 3:18 am
Topic starter
I wish we had a patient contacts table in CEMR (at least I can't find it). The patient contacts store in the person table from what I've seen and we can associate the contact to the actual patient via the RELPERS table. This allows me to see when the change to the contact was made (DB_UPDATE_DATE) of the person table entry that is the contact but I can't pull the HISTORICALINFO for that "person".
We see this happen with pharmacies too, very frustrating that we cannot remove the ability to change a pharmacy/contact without removing a whole bunch of other (necessary) abilities.
Posted : July 30, 2015 6:08 am
