Enabling rule auditing

You can configure the application to audit all rule changes that are made using the Quick Rule Editor. Audit information includes the user that made the changes and the details of the rule changes. When a rule change occurs with date effectiveness turned on, the same calculation group remains assigned to the employee and the history is automatically remembered.

Auditing information is stored in the CALC_GROUP_AUDIT and CALC_GROUP_VERSION tables. To see the changes made between two versions of a rule, you must compare the XML in the CGV_XML field of the CALC_GROUP_VERSION table.

These details are stored in the CALC_GROUP_AUDIT table:

• CGA_ID: ID of the calculation group audit
• CALCGRP_ID: ID of the calculation group that changed
• CGA_CREATE_DATE: Date the change was made
• WBU_NAME: User who made the change
• CGA_EFF_START_DATE: Date the change is effective
• CGA_EFF_END_DATE: Date the change is no longer effective
• CGA_NEW_VER_ID: New calculation group version ID (references the CALC_GROUP_VERSION table)
• CGA_OLD_VER_ID: Old calculation group version ID (references the CALC_GROUP_VERSION table)
• CGA_STATUS: Calculation group status
• CGA_COMMENT: Optional comment that is captured at the time of change

These details are stored in the CALC_GROUP_VERSION table:

• CGV_ID: Calculation group version ID
• CALCGRP_ID: ID of the calculation group that changed
• CGV_XML: Calculation group revised XML

You can enable rule auditing for all changes or for period changes only (only those changes with new effective dates). This table summarizes the relevant registry parameters and their settings.