Captured Information
When auditing is enabled for a field, the following information is recorded when the field is changed, added and/or deleted (depending on the actions that you are auditing for that field):
• User ID
• Date and time
• Table name
• Row's prime key value
• Field name
• Before image (blank when a row is added)
• After image (blank when a row is deleted)
• Row action (add, change, delete)
Parent topic