9.2 Year End Sick Leave Buyouts - Query

Purpose:  Use this document to process sick leave buyouts on an annual basis or periodically within ctcLink.

Audience:  Payroll Specialist/Absence Management.

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

  • ZD_DS_QUERY_VIEWER

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

Year End Sick Leave Buyouts - Query

Navigation:  NavBar > Navigator > Reporting Tools > Query > Query Viewer

  1. The Query Viewer page displays.
  2. Select the Advanced Search link. Additional search fields will display.
Query Viewer window
  1. The Query Viewer page displays.
  2. Enter "QHC_AB_SICK_LEAVE_BUYOUT_YE" in the Query Name field.
  3. Select the Search button. A list of queries will display at the bottom of the page.
Query Viewer page
  1. Locate the row for the Year end Sick Leave Buyout query and select the HTML or Excel link. (Excel was selected in this example).
Search results page
  1. The QHC_AB_SICK_LEAVE_BUYOUT_YE  Year end sick leave buyout page displays.
  2. Enter or select the Original Calendar Group ID (This should be last run Absence Calendar).
  3. Select View Results. The QHC_AB_SICK_LEAVE_BUYOUT_YE  Year end sick leave buyout report will display.
View results page
  1. You can view results in ctcLink or download to Excel to utilize information as needed for Year-end Sick Leave Buyouts.
Example of Excel spreadsheet report
  1. The process is complete.
  2. End of procedure.

0 Comments

Add your comment

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