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

Users changing Registration Contacts

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

3 Posts

3 Users

0 Reactions

59 Views

RSS

bruins1986

(@bruins1986)

Posts: 233

Reputable Member

Topic starter

Hi All,

Has anyone ever created a crystal report that can determine the when/if/who related to the changing of patient contacts? I have been able to figure out how to reproduce the contacts piece via crystal reports (the RELPERS table) but I am unable to determine the when and the who for the changes. Our issue is that occassionally a user will change a contact for a person instead of removing and adding a new one. As I'm sure others have found that changes the contact for everyone that shares said contact. A referring provider has ended up on the contact list for a lot of patients that shouldn't be there so I'd like to be able to figure out how that happened. It is too bad the HISTORICALINFO table doesn't store contact information...

We are EMR 9.8.3 and I am very proficient with Crystal Reports - I'm just looking to be pointed in the right direction for tables (or to find out if it is ever possible so I don't waste me time continuing a futile effort).

Thanks!
Mike

Posted : October 21, 2014 4:02 am

jamesedward

(@jamesedward)

Posts: 257

Reputable Member

Truly this is a never-ending expense of time; new permissions would make life so much easier. Someone blows up a pharmacy every few months.

Two general report classes, one for Pharmacies and one for Referring Doctors.

Particularly for Pharmacies, these won't tell you who made a change but you will know a change was made and that you can run an Inquiry>Documents to see which documents have the 'new' contact. You can usually then infer the source.

I also have a separate SQL set to run automatically off-hours each AM to save off a copy of the full Pharmacy Master and Patient>Pharmacy lists. When someone changes a pharmacy with thousands of patients, these come in handy. Whomever is managing the eRx console is responsible for running the Crystal Reports to see what has changed or what new Pharmacies have been added.

I can't get these uploaded so feel free to email me or post your address.

[email protected]

Posted : October 21, 2014 10:27 am

justinbelcher

(@justinbelcher)

Posts: 130

Estimable Member

Patient contacts are stored in the PatientRelationship table. Would the LastModified and LastModifiedBy columns of that table work for you?

Posted : October 27, 2014 8:41 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
0 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