Data Audit Extract (DAE)

To run the audit:
  1. Select Data Audit Extract (DAE) from SunSystems to open the Business Unit Group Selection form.
    This lists the domain and all live business unit groups, including those that are offline. However, if you select a business unit group that is offline a warning message is displayed.
  2. Select the required business unit group to display the Data Audit Extraction form.
  3. 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 will be placed. This is <SunSystems v6.4 installation folder>/DataAudit/Data by default, but can be defined in this field.
    Note: 
    • If you change the default folder, you must first create the new folder; the system cannot create it for you.
    • If the path contains spaces, it must be enclosed within " quotation marks; if the path does not contain any spaces, it must not be enclosed within " quotation marks. For example, C:\Program Files\Infor\SunSystems\DataAudit\data or C:\Temp\DataAudit\data.
    • To preset a custom default folder, you must create a new Data Audit Extraction form and specify the folder location in Form Designer.
    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.