Does anyone know if there is a way to see who marked a constituent deceased?
There is no audit trail for any specific field in RE. All you can see is who last changed the record in some way but you can not see what they changed.
I know there are some VBA/API programmers out there who have come up with some creative ways to keep audit trails but unless you have that module ($$$$$$) I do not think you can do anything. (someone correct me if I am wrong.)
I do believe that the next major redesign for RE has been designed in a way to give you this audit trail. This is likely years from implementation, however. Sorry
There are ways to find it if you really are interested and do not have audit trails set up. There are log readers available for SQL server. These basically allow you to browse through the transaction logs. This is a very slow and tedious project, so I would only do this if you really need to.
It came in very handy at my last job, because one of my clients insisted that the equivalent of the Address Accelerator was mangling some of his records. Invariably, we found that it was his administrative assistant who was incorrectly entering the data, which the program then put into a standardized format.
If you are on SQL 2005, you don't need to wait for BB to release the next version. SQL 2005 has table audits. We're not on SQL 2005, so I can't tell you how to set these up.
Drew
This may not be to the point, but we find it very useful to have a policy that only the Database Administrator can mark a person deceased and she (I mean me) adds a note and if available the obituary to the record, If not the obit, how we found out a person died. This idea won't help tracking the past but can help creat a trail for the future.
We basically do the same thing Nina does. We only have several people that can mark someone deceased. They then add a notepad type of Deceased Notification saying how we learned they were deceased. We usually learn way after the fact so the note date helps us know when we learned of it.