When I'm asked who, why, how and when a record was changed, I have a limited way of knowing this. It is incredibly helpful to manage data comprehensively when you can see who updated records and how. I used to have an auditing tool which showed changes made: i.e. <deleted> Primary Phone <deleted> 303-111-1111 and <added> Primary phone <added> 303-555-555. This showed me who removed a phone number and added a new one. This ability to audit is helpful in many ways beyond seeing what changes were made, when and by who but ultimately allows a better ability to monitor data integrity. In advancement, its important to know how and in which ways the database is being enhanced.
It is a pain point for RE database administrator. There is no way to audit or create an audit log of records / changes created/deleted by date/user/specific changes made. If this can be introduced, that will help DB admins a LOT.
I agree. We are able to pull queries to show when and who changed a field, but not all fields have a "Changed by" or "Date changed" option. We especially need one for Constituency Code changes--which is not available.
It is crazy that this is still not implemented, and that the only way to do it is with a third-party plugin that hosted users can't use.