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)