Audited Fields

The Audited Fields zone lists the audit trail information of fields for which audit is enabled on various user actions, such as add, update, and/or delete. You can filter the list using various search criteria. This zone contains the following two sections:

  • Search Criteria - The Search Criteria section contains the following fields:

    Field Name Field Description Mandatory (Yes or No)
    Audited Field Name Used to indicate the field whose audit trial information you want to view. No
    <Primary Key Field> Used to indicate the record whose audit trial information you want to view.
    Note: The primary key dynamically changes depending on the table that you have selected. For example, if you have clicked the Broadcast icon corresponding to the CI_​ACCT_​APAY table, the ACCT_​APAY_​ID field appears as the primary key. However, if a combination of two or more fields is used as a primary key for a table, then all those fields appear in this section.
    No
    Creation Start Date/Time Used to search for all changes which were made from a particular date and time onwards. No
    Creation End Date/Time Used to search for all changes which were made till a particular date and time. No
  • Search Results - On clicking the Refresh button, the search results appear based on the specified search criteria. The Search Results section contains the following columns:

    Column Name Column Description
    Create Date/Time Displays the date and time when the change was made.
    User Name Indicates the user who has made the change.
    Primary Key Indicates the record in which the change was made
    Audited Field Name Indicates the field for which the change was made.
    Audit Action Indicates the action performed by the user. The valid values are:
    • Add

    • Update

    • Delete

    Value Before Update Displays the value of the field before the user action.
    Value After Update Displays the value of the field after the user action.
    Note: By default, the Audited Fields zone does not appear in the Audit Trail Summary screen. It appears when you click the Broadcast (The Broadcast Icon) icon corresponding to the audited table in the Search Results section.

Related Topics

For more information on... See...
How to view the audit trail information of a table Viewing Audit Trail Information of a Table