Change Log Trigger

The following function creates a Database Trigger that logs changes made to selected fields. Values from the selected fields are stored the log in the Payroll Audit Trail table.

  1. In the Tools window, select Change Log Trigger from the ribbon bar.

  2. In the Create Change Log Trigger window, check the table on the left pane and then navigate to the Monitor Column on the right pane.

  3. In the Monitor Column, select the required change fields to log into the Payroll Audit Trail table and then navigate to the Acc ID Column tab.

  4. In the Acc ID Column tab, select the field to write into Payroll Contract Account ID.

  5. Click Create Change Log Trigger at the ribbon bar to create the trigger.

  6. Repeat the above steps to add more table field.

Delete Log Trigger

This function creates a Database Trigger that logs data deletion activities of the selected fields. Values deleted from the selected fields are logged into the Audit Trail Deletion table.

  1. In OHC Tools, select Delete Log Trigger from the ribbon bar.

  2. From the Create Deletion Log Trigger window, navigate to the the Description column

  3. Under the Description column, select all the fields so that their changes are logged into the SDR table

  4. Navigate to the Acc ID column tab.

  5. In the Acc ID Column tab, select the fields that will be written into the SDR_ACC_ID

  6. Click Create Deletion Log Trigger on the ribbon bar to create the database trigger.

  7. The system prompts a number of database triggers that track created/deleted/uploaded fields. Click OK to continue.

  8. Repeat the steps above to add more table fields.

Insert Log Trigger

This function creates a Database Trigger that logs the data insertion activities of the selected fields. Values added from the selected fields are logged into the Audit Trail Insertion table.

  1. In the Tools window, select Insertion Log Trigger from the ribbon bar.

  2. In the Create Insertion Log Trigger window, select the table on the left pane by selecting the checkbox and then navigate to the Description Column on the right pane.

  3. In the Description Column, select the fields logged into the Audit Trail Insertion table.

  4. Navigate to the Acc ID Column tab, and select the field to write into the Audit Trail Insertion Account ID.

  5. Click Create Insertion Log Trigger on the ribbon bar.

  6. The system prompts a number of database triggers that tracks created/deleted/uploaded fields. Click OK to continue.

  7. Repeat the above steps to add more table fields.