Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Patient Contact Change in Registration

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

65 Views

RSS

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

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

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

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 = Update
Activity = Patient Contacts
Component = Registration

Click search.

Posted : July 27, 2015 8:11 am

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

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

mikeseale

(@mikeseale)

Posts: 344

Reputable Member

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

jsander

(@jsander)

Posts: 108

Estimable Member

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

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

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

Share:

24 Forums
9,940 Topics
39.9 K Posts
2 Online
6,470 Members

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

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

Powered by wpForo Powered by wpForo version 2.4.0