9.2 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:  NavBar > Navigator > Workforce Administration > Workforce Reports > Database Audit

  1. The Database Audit run control search page displays.
  2. Select the Add a New Value tab.
  3. Enter the new Run Control ID.
  4. Select the ADD button.
Add a New Value Tab
  1. The Database Audit page displays.
  2. 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.
  3. Select the Run button.
Report Request Parameters Page
  1. The Process Scheduler Request page displays.
  2. Select the OK button.
Process Scheduler Request Page
  1. The Database Audit page displays.
  2. Make note of the Process Instance number.
  3. Select the Process Monitor link.
Process Instance Number
  1. The Process Monitor page displays.
  2. Select the Refresh button until the Run Status is Success and the Distribution Status is Posted.
  3. Select the Details link.
Process Monitor page
  1. The Process Detail page displays.
  2. Select the View Log/Trace link.
Process Detail page
  1. The View Log/Trace page displays.
  2. To view the report, select the PDF link in the File List section.
View Log/Trace page
  1. The report opens in a separate window.
  2. View results of the report, and close the window when finished.
  3. Note: Expected results are “no data selected from PSAUDIT for this report”.
Database Audit report
  1. You have successfully run the database audit report.
  2. End of procedure.


Add your comment

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