Running the Database Audit Report

Purpose: Use this document as a reference for running the database audit report in ctcLink.

Audience: Payroll Administrators.

You must have at least one of these local college managed security roles:

  • <there are no college-grantable roles>

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

Run the Database Audit Report

Navigation: Workforce Administration > Workforce Reports > Database Audit

  1. The Database Audit run control search page displays.
  2. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and click the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and click the Add button.
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_ADM_FYR_5 (Institution, Process).
  3. The Database Audit page displays.
  4. Enter the pay period begin and end dates in the From Date and Thru Date fields. You may select the calendar icon to find a specific date, or manually enter the dates in the following format: XX/XX/XXXX.
  5. Select the Run button.
Database Audit run control page
  1. The Process Scheduler Request page displays.
  2. Please refer to the Process Scheduler Request steps for further instructions.
  3. The report opens in a separate window.
  4. View results of the report, and close the window when finished to complete the process.
    • Note: Expected results are “no data selected from PSAUDIT for this report”.
Database Audit Report

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.