Setting audit flags

You must select the tables and fields you want to audit in SA Administration Audit Processing Program Generation. Be conservative when you select fields to audit. When you create audit records, the size of your database increases and could affect system performance.

Note:  When a new version of Distribution SX.e is released, it often includes database schema changes. These changes represent new tables or fields that were added to the data dictionary. To select new fields for auditing, or to remove the auditing selection data, click Clear Audit Meta Data. This removes the entire list of tables and fields that are presented in the Audit Processing grid. Use care when selecting this option because it removes any previous auditing table/field selections that were previously set up.
  1. Select System Administrator > Administration > Audit Processing.
  2. Specify to audit in the Beginning Table Name field. Leave this field blank to see all tables in the grid.
  3. Select Only Tables With Audit Flag Turned On to display only those tables that are already selected for auditing.
  4. Click Search.
  5. Drill down on a table to view the Audit Table Column Details window.
  6. Select fields, and then click Set Audit Flag to Yes. Select fields, and then click Set Audit Flag to No to remove them from the audit inquiry.
  7. Close the Audit Table Column Details window when you are finished.
  8. Your system administrator can now generate the audit dictionary and audit triggers.

    See the Distribution SX.e Administration Guide.