Data Audit Maintenance (DAM)

Select the required Business Unit Group or the Domain to display the Data Audit Maintenance form:

Specify this information:

Maintenance Plan Code

An identifying code for the Maintenance Plan.

Status

Description

Short Heading

Lookup Code

Data Access Group Code

This can be used to restrict access to Data Audit Maintenance to a group of users.

Uwaga: To be able to setup and maintain Data Auditing you must be a member of the main Data Access Group on the Maintenance Plan and a member of the Extract and Clear Down Data Access Group.

Audit Insertions

If this box is checked, insertions that have been made to the tables are included in the audit.

Audit Updates

If this box is checked, updates that have been made to the tables are included in the audit.

Audit Deletions

If this box is checked, deletions that have been made to the tables are included in the audit.

Uwaga: Deletion of a parent record may delete all the children records as well, and so return multiple audit lines depending on the number of children records attached.

Retention Unit

The unit of time in which to retain the audit details. Options are: Not Specified, Days, Months or Years.

Retention Value

The amount of time to retain the audit details for. That is, the number of Retention Units. This must be a number in the range 1-999.

File Format

The format for the output file. That is, XLS for Excel spreadsheet.

Extract Data Access Group

This can be used to restrict access to extract Maintenance Plans to a group of users.

Clear Down Data Access Group

This can be used to restrict access to clear down Maintenance Plans to a group of users.

Extract File Protection

Specifies what protection, if any, is placed on the output file. Options are:

No Protection
Write Protect - the Extract password is needed to gain write access to the output file.

Extract Password

The password required for write access to the output file if the Extract File Protection field is set to Write Protect.

Re-Type Password

Retype the password to ensure you have typed it correctly in the Extract Password field.

Uwaga: On clicking Exit the Business Unit Group Selection form is displayed. This is so that another business unit group can be selected if required.