Data Audit Extract (DAE)

Complete the required information for the audit:

Audit Operator: If this is completed, the data extract contains audit information specific to this operator ID. The list of audit operators available is determined by those operators who have performed actions on 'audit activated' tables. It is not the full list of available SunSystems operators.
Maintenance Plan Code: If this is completed, the data extract contains audit information specific to this maintenance plan. This enables you to track changes to tables using a maintenance plan.
Business Unit Code: If this is completed, the data extract only contains audit information specific to this business unit. This option is disabled when extracting data from the domain tables.
Audit Insertions: If this box is checked, the data extract contains audit information where the specified Action to Audit field in the associated maintenance plan is set to Insertions.
Audit Updates: If this box is checked, the data extract contains audit information where the specified Action to Audit field in the associated maintenance plan is set to Updates.
Audit Deletions: If this box is checked, the data extract contains audit information where the specified Action to Audit field in the associated maintenance plan is set to Deletions.; Note: You must select at least one of the audit actions, that is, Audit Insertions, Audit Updates and Audit Deletions. If you do not enter any other selection information, the output file contains all audit data for that chosen action.
Audit Date From and To: The date range to be audited. If only the Audit Date From field is completed, the range covers up to the current login date. If only the Audit Date To field is completed, the range covers from the start of the data to the Audit Date To date.
Table Name From and To: The range of tables to be audited. If only the Table Name From field is completed, only that table is used and the Table Name To field is populated with the same table name. If only the Table Name To field is completed, you are forced to complete the Table Name From field. You can further define the audit by specifying the parts of the table to be included in the Auditable Key field as described below.; Note: The available audit tables displayed by the query functions are restricted by those existing data audit records. It is not the full list of available audit tables.
Work Folder: This is the folder where the output file is stored: storage://Application/Data Audit; Note: The ouptut folder location cannot be customized.
Auditable Key Part 1 - 8 From and To: To activate the auditable key part fields available on the form select Action > Activate Lookup Keys. You can only use this if the Table Name From and Table Name To fields are the same. Each table contains a key part which is used to find specific data. For example, the Item table contains only one key field. If you enter Item in the Table Name From and Table Name To fields and select Activate Lookup Keys, the key part Item Code is displayed in the Auditable Key fields.; There are 16 available key parts although only 8 are displayed on this form.; On clicking Exit the Business Unit Group Selection form is displayed. This is so that another business unit group can be selected if required.