Register Tables and Columns to be Audited in dspConduct

A Designer configures which Content WebApp tables and columns are audited in dspConduct. Changes to requests based on the data in these tables and columns is then tracked and displayed for a user with the Review role.

Before performing this task, Enable Auditing for the Content WebApp Tables.

NOTE: Data that was updated before auditing was enabled is not included in the audited changes.

To register tables and columns to be audited:

  1. Click dspConduct > Design in the Navigation pane.
  2. Click Vertical View for a category.
  3. Click the Rules and Actions tab.
  4. Click the Table Registration icon.

    NOTE: The Audit Table Registration page displays any tables that have had auditing enabled for the Default WebApp ID (the Content WebApp) in System Administration.

  5. Click the ENABLED check box to disable it if a table should not be audited.

    NOTE: By default, all tables are audited.

    NOTE: If tables are not audited, updates to this table’s data for a request do not display for the Review role on the Review Role Audit Details page.

  6. Click the Columns icon for a table.

    NOTE: All columns in the table selected on the Audit Table Registration page display. These columns are enabled for auditing by default.

  7. Click the ENABLED check box to uncheck it if changes to a column’s data must not be audited.  
  8. Click the PRIMARY KEY check box.

    NOTE: This check box must be checked for the Key to Record field to display on the Review Role Audit Details page.

  9. Click the INCLUDE IN RECORD KEY check box to display the column name in the Key to Record field on the Review Role Audit Details page.

Adding additional columns can provide more information to the Review role when evaluating updates in a request.

Key fields are not affected by this setting, with the exception of the RequestID. Key fields display in the Key to Record field, even if this check box is unchecked. However, the display of the RequestID column can be controlled using this option. For example, the user disables this option for the key fields DATE_FROM and RequestID. In the Key to Record field, the DATE_FROM field still displays. The RequestID field does not.

Audit data for tables or columns that were updated is loaded into staging tables, and can then be viewed by the Review role for requests based on the data in the table(s) or column(s).

Audit data is automatically loaded to the staging tables when table or column registrations are updated. If the audit data must be loaded immediately, click the Load Audit Data icon.

After this task is complete a user with the Review role can view changes for a request.