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:  Reporting Tools > Query > Query Viewer

  1. The Query Viewer page displays.
  2. Select the Advanced Search link. Additional search fields will display.
  3. The Query Viewer page displays.
  4. Enter "QHC_AB_SICK_LEAVE_BUYOUT_YE" in the Query Name field.
  5. Select the Search button. A list of queries will display at the bottom of the page.
  6. Locate the row for the Year end Sick Leave Buyout query and select the HTML or Excel link.
  7. The QHC_AB_SICK_LEAVE_BUYOUT_YE  Year end sick leave buyout page displays.
  8. Enter or select the Original Calendar Group ID (This should be last run Absence Calendar; ex. GLBL 2023 DEC ENT).
  9. Select View Results. The QHC_AB_SICK_LEAVE_BUYOUT_YE  Year end sick leave buyout report will display.
  10. You can view results in ctcLink or download to Excel to utilize information as needed for Year-end Sick Leave Buyouts.

Video Tutorial

The video below demonstrates the process actions described in the 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 external link to Year End Sick Leave Buyouts - Query. 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.