9.2 Run Absence Time Ordered Reports

Purpose:  Use this document as a reference for how to run the absence time ordered reports in ctcLink.

Audience:  Absence Administrators, Payroll Administrators.

Run Absence Time Ordered Reports

Navigation:  NavBar > Navigator > Global Payroll & Absence Mgmt > CTC Custom > CTC Reports > Absence Time Ordered Reports

  1. The Absence Time Order run control search page displays.
  2. Enter an existing Run Control ID or select the Add a New Value tab to create a new one.
  3. Select the Search or Add button.
  4. The Absence Time Order page displays.
  5. Three reports are able to be run from one screen as defined by CEMLI R-012:
    • Leave Balance Report
    • Separated Employees with Leave Balances
    • Employees with Leave Balances but no leave accrual plans
  1. Enter the Company.
  2. For each report desired a separate run must be requested in the system.  Select the radio button next to the report name, and enter the needed parameters below.
  3. Select the Run button.
Absence Time Order
  1. The Process Scheduler Request page displays.
  2. Select the OK button.
  3. The Absence Time Order page displays.
  4. Select the Process Monitor link.
  5. The Process Monitor page displays.
  6. Select the Refresh button until the process is Success/Posted.
  7. Select the Go Back to Absence Time Order link.
Process Monitor for Absentee Time Ordered Reports
  1. The Absence Time Order page displays.
  2. Select the Report Manager link.
  3. The Report Manager page displays.
  4. In the List tab, select the name of the report (CTC_LEAVE_AE) that corresponds to your process instance.
List tab from report manager page
  1. The Report Index page displays.
  2. Once inside the report, select the file with xlsx or csv at the end.  It will give you the option to open or download depending on your internet browser settings.
Report Index page
  1. The process to run the absentee time ordered reports is now complete.
  2. The following subsections describe specific parameters for each report.

Leave Balance Report

  1. Process Monitor Name: CTC_LEAVE_AE.
  2. Only employees with HR Active jobs in Job Data will be eligible to show up on this report.
  3. It will display employees even if they have 0 balances in all columns.
  4. The fields that will display in the report are the following:
    • Employee Name
    • Employee ID
    • Empl Rcd
    • Pay Group
    • Leave Accrual Date
    • Leave Max Month
    • VAC Balance
    • CSL Balance
    • NSL Balance
    • Comp Time Balance
    • Personal Holiday Balance
    • Personal Leave Balance
Report index page leave balance report page

Separated Employees with Leave Balances

  1. Process Monitor Name: CTC_LEAVE_AE.
  2. Only employees with an Employment Status of ‘T’ will be eligible to show up on this report (i.e. only terminated employees).
  3. Data is delivered in this report as a CSV, and it can take some time to run.
  4. The fields that will display in the report are the following:
    • Employee Name
    • Employee ID
    • Empl Rcd
    • Probation End Date
    • Separation Date
    • Separation Reason
    • VAC Balance
    • CSL Balance
    • NSL Balance
    • Comp Time Balance
    • Personal Holiday Balance
    • Personal Leave Balance
  5. For the most part nothing can be done about these balances, if the employees have been terminated and are outside the 90 day absence window, other than monitor them.  These balances can be prevented from occurring by making sure to zero out balances on a terminated employee prior to their termination date and movement to Absence System of Other on Job Data.
  6. In some cases, like retaining a record of CSL for certain pay groups at the time of separation, the existence of balances will actually be desirable. This will depend on your college’s business process.
Report Index page for separated employees with leave balances

Employees with Leave Balance but no leave accrual plans

  1. Process Monitor Name: CTC_LEAVE_AE
  2. Only employees who satisfy all the following conditions will show up on this report:
    • HR Active jobs in Job Data,
    • who have positive balances of VAC or CSL,
    • and are not currently enrolled in Absence Management.
  3. Data is delivered in the report as a CSV, and can take some time to run.
  4. These employees represent loose data and should be handled if possible at the college level by an administrator.
  5. The fields that will display in the report are the following:
    • Employee Name
    • Employee ID
    • Empl Rcd
    • Leave Accrual Date
    • Probation End Date
    • Full/Part Time
    • Perm/Temp
    • VAC Balance
    • CSL Balance
    • NSL Balance
    • Comp Time Balance
    • Personal Holiday Balance
    • Personal Leave Balance
Report Index page for Employees with leave balances but no leave accrual plans
  1. The process to run the absence time ordered reports is now complete.
  2. End of procedure.

0 Comments

Add your comment

E-Mail me when someone replies to this comment

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