Each time users add, delete, or modify the value of an
attribute using a system application and save the change, an audit
record is written to the audit object corresponding to the regular
database object. Electronic audit records must first be enabled for
the database attribute.
The audit record includes the following items:
- The user name of the user who changed the data
- A copy of the changed data for each attribute that is electronic
audit enabled
- The identifier indicating whether the change was an insert, update,
or delete
- The current date and time of the transaction
- The rowstamp
- The unique electronic audit transaction ID
- The unique e-Sig transaction ID if electronic signature is enabled
- The key values columns for the record, even if those columns are
not electronic audit enabled. For example, the work order number is
recorded even when another attribute in the WORKORDER object triggers
the electronic audit.