Adding Tables to a Policy

Adding Tables to a Policy

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. In Audit Policy Maintenance, click the Audit Tables tab.

2. Click Add Record on the Table Toolbar.

3. The Audit Table screen is displayed with a blank Table Name field as shown below.4. Click the Search button in the Table Name field to choose the table for inclusion in the policy.

5. 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.
• In the Event ID fields, leave the default values. (These are the most commonly used events).
• Save the record by clicking the Save icon on the tool bar.

Example showing Profile table: