We have a situation where 2 patients were marked as deceased by someone in the db and do not know how to audit this information. Patients are not deceased. This apparently comes from the DATEOFDEATH column in the PERSON table and we need to figure out who did this. Any help is greatly appreciated.
There may be a clue in the activity log in the patient's registration form. Look either under the "Historical Data" tab or select VIEW > Activity Log. I can see who last changed the registration data, but in my system I don't know if it was the person who clicked "Deceased" in the patient status field in the patient's registration.
Tim
Thanks Tim. We are not on CPS. I am familiar with this in that version. We are on EMR only 9.8.12.
I marked a patient deceased in my CEMR Evaluation install and the only thing that showed up in the Audit report was accessing a normal chart. I looked at the PERSON table for the patient and in this case, the DATEOFDEATH field was the same as DB_UPDATED_DATE, so I know it probably wasn't updated after I had done the update by marking the patient's status as Deceased. The USRID field in the PERSON table is the person who last updated the record. It is the PVID from the USRINFO view, if that helps any.