How to add fields to an Audit Policy
  • 11 Apr 2023
  • Contributors
  • Dark
    Light
  • PDF

How to add fields to an Audit Policy

  • Dark
    Light
  • PDF

Article summary

Creating an Audit Policy will not automatically begin Auditing all actions taken within FIMS. Tables must be added to the Audit Policy so FIMS knows which areas of the program you want it to audit.

The FIMS Database Auditing Feature

Answer:
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
  1. Click Add Record on the Table Toolbar.
  1. Click the Search button in the Table Name field to choose the table for inclusion in the policy.
  2. For the Audit create level, Audit 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.

Was this article helpful?