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.

Note: The application does not currently provide a tool for comparing XML.

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.

CALC_GROUP_ AUDIT_PERIOD_ CHANGE_ONLY

FALSE

TRUE

FALSE

TRUE

CALC_GROUP_ EFFECTIVE_DATING

FALSE

FALSE

TRUE

TRUE

Result

All changes audited

No auditing (default)

All changes audited

Period changes audited