9.2 Absence Management Custom Reports

Purpose:  Use this document as a reference for how to run the custom Absence Management (custom) reports in ctcLink.

Audience:  Absence Administrators, Payroll Administrators.

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

  • ZD Absence Mngmt Reporting

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

Absentee Time Costs Custom Reports

Navigation:  Menu > Global Payroll & Absence Mgmt > CTC Custom > CTC Reports > Absentee Time Costs

  1. The Absentee Time Costs 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 Planned and Actual Absentee Time Costs page displays.
  5. Five reports are able to be run from one screen, as defined by CEMLI R-222:
    • Accrued Leave Liability By Employee (resembles PS2160 in Legacy)
    • Accrued Leave Liability By Fund, Class ( resembles PS20160B in Legacy)
    • Leave Accounting And Leave Audit Summary
    • Compensable Sick Leave Eligible For Leave Buyout
    • Compensable Sick Leave Eligible For Leave Buyout By Fund, Class, Deptid
  6. In the Report Parameters section, the Company field is required.  
  7. The Fiscal Year (Calendar Year) should be selected as well to run the reports.  
  8. The Pay Group and Plan Type are not required, but may allow the report to process faster if parameters are chosen.
  9. For each report desired a separate run must be requested in the system.  
  10. Select the radio button of the Report Title desired, enter the needed parameters to the right.
  11. Select the Run button.
  12. The Process Scheduler Request page displays.
  13. Select the OK button.
  14. The Planned and Actual Absentee Time Costs page displays.
  15. Select the Process Monitor link.
  16. Select the Refresh button until the process is Success/Posted.
  17. Select the Go Back to Absentee Time Costs link at the bottom of the Process Monitor page.
  18. The Planned and Actual Absentee Time Costs page displays.
  19. Select the Report Manager link.
  20. The Report Manager page displays.  
  21. In the List tab, select the appropriate report name that contains xlsx at the end.
Report Manager List tab
  1. The Report Index page displays.
  2. Select the file name ending in .xlsx and 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 costs custom reports is now complete.
  2. The following subsections describe specific parameters for the five report options listed on the Planned and Actual Absentee Time Costs page.
    1. Accrued Leave Liability By Employee
    2. Accrued Leave Liability By Fund, Class
    3. Leave Accounting And Leave Audit Summary
    4. Compensable Sick Leave Eligible For Leave Buyout
    5. Compensable Sick Leave Eligible For Leave Buyout By Fund, Class, Deptid

NOTE:  For Part time faculty, hourly rate needs to be updated manually based on the Faculty Workload Hourly Rate.

Accrued Leave Liability By Employee

  1. Process Monitor Name: CTC_AUDIT_AE.  
  2. Prompts allowed: Company, Employee Class, Plan Type, Pay End Date.
  3. This report can take a long time to run depending on parameters chosen on the report selection page.
  4. Only employees with HR Active jobs in Job Data will be eligible to show up on this report.
  5. This should be run after the fiscal year (after the June ENT).
Report, distribution details and file list page

Accrued Leave Liability By Fund. Class

  1. Process Monitor Name: CTC_AUDIT_AE.
  2. Prompts allowed: Company, Plan Type, Pay End Date.
  3. Only employees with HR Active jobs in Job Data will be eligible to show up on this report.
  4. This should be run after the fiscal year (after the June ENT).
File List section

Leave Accounting and Leave Audit Summary

  1. Process Monitor Name: CTC_AUDIT_AE.
  2. Prompts allowed: Company, Cal year.
  3. Only employees with HR Active jobs in Job Data will be eligible to show up on this report.
  4. Should be run monthly to reference balances.
File List section

Compensable Sick Leave Eligible For Leave Buyout

  1. Process Monitor Name: CTC_AUDIT_AE
  2. Prompts allowed: Company, Cal Year
    • System will use sysdate if you do not enter anything so choosing a Pay End Date is strongly recommended
  3. Only employees with HR Active jobs in Job Data will be eligible to show up on this report
  4. Should be run prior to the 1st February paycheck
  5. Core fields on this report are:
    • TIME AVAIL: This is TIME ACCRUED  TIME TAKEN
    • TIME PAYABLE: This is TIME AVAIL * 25%
    • RATE: This is the hourly rate (HOURLY_RT from Job Data)
    • LEAVE BUYOUT AMOUNT: This will be RATE * TIME PAYABLE
File List section

Compensable Sick Leave Eligible For Buyout By Fund. Class. DeptID

  1. Process Monitor Name: CTC_AUDIT_AE
  2. Prompts allowed: Company, Employee Class, Cal year.
    • System will use sysdate if no date is chosen so Pay End Date is strongly recommended
  3. Only employees with HR Active jobs in Job Data will be eligible to show up on this report.
  4. Should be run prior to the 1st February paycheck.
  5. Uses similar information to previous Leave Buyout report, but provides separate line items for multiple fund/class/dept id for one employee.
File List section
Absence Time Ordered Reports

Navigation:  Menu > 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
  6. Enter the Company.
  7. 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.
  8. Select the Run button.
  9. The Process Scheduler Request page displays.
  10. Select the OK button.
  11. The Absence Time Order page displays.
  12. Select the Process Monitor link.
  13. The Process Monitor page displays.
  14. Select the Refresh button until the process is Success/Posted.
  15. 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.
  5. The Report Index page displays.
  6. 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. Currently, this report is not performing consistently.  The admin may need to cancel runs if they surpass an hour, or even upon success the report might not pull all active employees.
  4. Send in a service ticket to ERP if the report performs erratically.
File List section

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. For the most part, nothing can be done about these balances other than monitor them at this time.  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.
File List section

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.
File List section

End of procedure.

Video Tutorial

The video below demonstrates the process actions described in steps listed above.  There is no audio included with this video.  Select the play button to start the video.

Video Tutorial via Panopto

View the link to Absence Management Custom Reports. This link will open in a new tab/window.

0 Comments

Add your comment

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