The Sys Audit table

The system tracks inserts and changes to audited records in the Sys Audit [sys_audit] table.

The system audits tables in which the Audit check box is selected on the Dictionary record. By default, the system does not audit records from system tables, such as update sets tables.

Note: To prevent performance issues and infinite loops, the system skips any business rule or workflow triggered by inserts to the Sys Audit table.

Sys Audit table columns

Records in the Sys Audit table display these columns:
Field Description
Table Name Table that the audit record is for (for example, "incident")
Field Name Column in the table that the audit record is for (for example, "assigned_to")
Document Key The Sys ID (Unique Record Identifier) of the record the audit record is for.
Old Value

Old value of the field change represented by this sys_audit record.

  • Reference fields: Displays the unique sys_id value of the changed record.
  • Date and time fields: Displays the value in Coordinated Universal Time (UTC) as stored in the database.
New Value

New value of the field change represented by this sys_audit record.

  • Reference fields: Displays the unique sys_id value of the changed record.
  • Date and time fields: Displays the value in Coordinated Universal Time (UTC) as stored in the database.