Screen flows

• Refresh—Reloads the original data. Any changes made since the last submit are lost.
• New Search—Return to the Search screen and clear the search results and the search criteria.

Auditing Details

The audit rule details associated with the audit event.

• Table Name

  The name of the table associated with the audited event.

• Column Name

  The name of the column within the table containing the specific values associated with the audited event.

• Audited Action

  The action taken by the audited change.

• Created By

  The user or application that created the audit record.

• Created At

  The date and time at which the audit record was logged.

Data Details

The audit data details associated with the audit event.

• Data Key

  The unique key identifier of the record being audited. This can be the identification of the record or concatenated primary codes on the record.

• Before Value

  The value of the data before the action on the record that triggered the audit action.

• After Value

  The value of the data after the action on the record that triggered the audit action.

Column Details

The details on the type of data contained within the audited column.

• Column Type

  The type of data contained within the audited column:

  • binary—Some ID fields

  • string—Other ID, code, date, date-time and Boolean fields

  • integer—Integer fields

  • big_decimal—Non-integer numeric fields

  • time-stamp—Some date-time fields.

• Column Length

  The length of the field associated with the audited data.

• Column Scale

  The scale of the audited data:

  • # if a numeric data field is recorded with scale, or

  • 0 if a numeric data field is not recorded with scale, or if the field does not contain numeric data.

• Column Precision

  The precision of the audited data:

  • # if a numeric data field is recorded with precision, or

  • 0 if a numeric data field is not recorded with precision, or if the field does not contain numeric data.