Notifications
Clear all
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
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.
Posted : October 21, 2014 10:27 am
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
