9.2 Running Service Years Query

Purpose:  Use this document as a reference for viewing the query AP_EES_WITH_YRS_SRVS_ALL_USE in ctcLink.

Audience:  Benefits Administrator.

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


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

NOTE:  If you do not have the menu option Query Viewer, you have not been granted the security to run queries.

Run the Service Years Query

Navigation: Menu > Reporting Tools > Query > Query Viewer

  1. The Query Viewer page displays.
  2. Navigate to Query Viewer.
  3. Search for AP_EES_WITH_YRS_SRVS_ALL_USE, which is a public query.  
  4. Using the % allows you to search using a "wildcard" - for instance, %YRS will allow you to search for all queries with YRS in the name.
  5. Select HTML (under Run to HTML) to initiate the query.
Query Viewer page
  1. Use the lookup (magnifying glass) to select the school code.
  2. Select View Results.

The following fields will display in the query for every active employee's Primary job in Job Data:

  • Co (Company)
  • Last
  • First Name
  • ID
  • Empl Record
  • Emple Class
  • Dept ID
  • Dept Name
  • Job Title
  • Start Date
  • Yrs Srv
  • Company Dt

Yrs Srv is a calculation based off the EMPLOYMENT-EE "Company Seniority Date" which then calculates years until the current run date that someone has been in the company.

It will not display Secondary jobs from Job Data.

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 _______________.  This link will open in a new tab/window.


Add your comment

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