Notifications
Clear all
Topic starter
Hi All,
Has anyone ever successfully created an audit that would track if a patients demographic data was updated and, if so, who was the user that made the change? I can track the last time a patient's information was updated from the Person table itself but I want to know if, for example, the patient's last name no longer matches (from the old to new value) who the user was that made that change.
The audit types have "patient data changed" but I'm looking for a way to compare the previous value in the person table with the current version. As an example because I know how hard it is to explain what you are looking for in a report something like:
if person.pid = previous(person.pid) and
person.lastname <> previous(person.lastname) then
person.usrid
I tried the syntax above but it was pulling the person table from the group(I grouped on PID) above it not the previous data associated to the same PID.
Thanks!
Posted : September 16, 2014 5:55 am
