Audit Fields by Table (ttaud3125m000)

Use this session to to define which fields must be audited, and when they must be audited.

Note
  • It is not required to define the fields that must be audited. Only if not all fields in a table must be audited, you must specify the fields that must be audited. You can only specify fields for a table for which you selected Specified in the Field Selection field in the Audit Tables by Profile (ttaud3120m000) session. If you selected All in that field, all fields in the table are audited, and no fields can be specified.
  • For a detailed explanation of the relation between audit type and field specification, refer to the section How to determine the net result of the audit configuration in the Audit Configuration Management online manual topic.
  • The audit functionality uses the positive approach, which means that you can only specify which tables and fields must be audited, but not which tables and fields must not be audited. Therefore, through the appropriate menu commands are available to load all (key) fields. You can then delete the fields you do not require.

Related topics

 

Profile

The audit profile you configure or view in this session.

Table

The package code of the table.

Table

The module code of the table.

Table

The number of the table.

Key Field

If this check box is selected, the field is part of the primary key of the table.

Field

The field for which you define the audit type.

If Customer Defined Fields (CDF) are defined for this table, they can also be used in the audit process. The CDF name must be prefixed by the string cdf_ to be accepted by the session. Zooming on this field offers the choice between zooming for normal or CDF fields.

Audit Type

The setting that defines when a field is audited.

You can choose to audit a field 'always', or only when it is 'changed':

  • If a field is audited 'always', the field is logged each time when the content of the field, or the content of any other audited field, changes.
  • If a field is audited when it is 'changed', the field is logged only when the content of the field itself changes.
Active

If this check box is selected, and the profile that is selected in the Profile field is also active, the next time you run the Create Runtime Audit Definitions (ttaud3200s000) session the settings for this field are converted to run time .

 

Print Profiles

Click to zoom to the Print Profiles (ttaud3410m000) session.

Load All Fields

Click to load all fields of the selected table. A message prompts you to select the audit type that you want to apply to these fields.

Load Key Fields

Click to load all key fields of the selected table. A key field is part of the primary key of the table. A message prompts you to select the audit type that you want to apply to these fields.

All key fields are loaded by default, when you start to specify the fields you want to audit. You can delete the key fields, but note that missing key fields can make an audit trail unusable.