NOTE: You may have as many tables in a policy as needed. The recommendation is to have a single policy for each module to make it easier to manage.  However, adding additional tables to a single policy might be necessary to capture all the changes required for the project.
  1. Select Tools > System Utilities > Admin Utilities > Audit Utilities > Auditing Policy Maintenance > Audit Table tab
User-added image
  1. Click Add Record on the Table Toolbar.
User-added image
  1. Click the Search button in the Table Name field to choose the table for inclusion in the policy.
  2. For the Audit create levelAudit update level, and Audit delete level fields, select one of the following options: (Use Min, Full, Std as default values respectively.)
  • Do Not Audit This Table (Off) – If you choose this option, no auditing is done for the table.
  • Audit Tables but do not store initial values (Min) – Records the event that took place, but does not save the values related to the event.
  • Audit Tables and store initial values (Std) – Records the event that took place, along with the original values.
  • Audit Table and store old and new values (Full) – Records the event that took place, along with both the original values and the updated values.  This option is only available for Update level.
  1. In the Event ID fields, leave the default values. (These are the most commonly used events).
  2. Save the record by clicking the Save icon on the tool bar.
  3. If you want to track field changes in this audit policy, they must be added on the Audit Fields tab.
  4. Once the table and field selection is complete, Audit Events will need to be added to the policy to delegate creation, update, or deletion of audit records.
  5. Finally, the changes will need to be committed for this Audit Policy to fully take effect.