Find Static Data Audits

  1. Click Audit in the CCLAS EL menu or run the Audit.exe application in the Exe folder to display the AuditEdit Form.
  2. To apply simple criteria:
    1. Click Criteria on the main menu to open the AUDIT—Criteria Form which displays the audit search criteria.
    2. Enter the search criteria: Staff, Dates, Actions, Programs, Tables and/or Values.
    3. To apply the search criteria, click Apply to close the form and display the records matching the search criteria in the AUDIT—AuditEdit Form.
  3. To apply advanced criteria:
    1. Click Advanced on the main menu to open the AUDIT—Criteria Form.
    2. Build the SQL string:
      1. Double-click a Custom form field to add it to the SQL string.
      2. Double-click an Operator to add it to the SQL string.
      3. Double-click a SQL component to add it to the SQL string.
    3. Make required adjustments to the SQL string.
    4. To test the SQL string, click Test SQL. » The test result displays.
    5. To clear the SQL string, click Clear. » The SQL string clears.
    6. To cancel the search, click Cancel.
    7. To apply the search criteria, click OK to close the form and display the records matching the search criteria in the AUDIT—AuditEdit Form.

  4. To sort the records ascending for a column, select the column and click Sort asc.

  5. To sort the records descending for a column, select the column and click Sort desc.