Turn On Auditing For a Table

In order to tell the system which fields to audit, you must know the name of the table on which the field is located. You must specify the audit table and the audit trail insert program for a table in the table's meta-data.

Note: Most of the system's table names are fairly intuitive. For example, the user table is called SC_​USER, the navigation option table is called CI_​NAV_​OPT, etc. If you cannot find the table using the search facility on the Table portal, please contact customer support.

To enable auditing for a table:

  • Navigate to the Table portal and find the table associated with the field(s) for which you want to capture audit information.
  • Specify the name of the Audit Table.
Note: Specifying the Audit Table. You can use the audit table that comes supplied with the base package ( CI_​AUDIT) to audit multiple tables and fields. All the audit logs are combined in a single table ( CI_​AUDIT). However, you can also have a separate audit table for each audited table. Refer to The Audit Trail File for more information.
  • Specify the name of the Audit Program . The product provides two programs. com.splwg.base.domain.common.audit.DefaultTableAuditor is a standard table audit program. In addition com.splwg.base.domain.common.audit.ModifiedTableAuditoris supplied as an alternative. This program does not audit inserts or deletes of empty string data.
CAUTION: By default, none of a table's fields are marked for audit. Even though you have enabled auditing for a table, you must still specify the fields and actions on those fields to be audited (see below).