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:
- 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.
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
- The Query Viewer page displays.
- Navigate to Query Viewer.
- Search for AP_EES_WITH_YRS_SRVS_ALL_USE, which is a public query.
- 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.
- Select HTML (under Run to HTML) to initiate the query.
- Use the lookup (magnifying glass) to select the school code.
- 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.
0 Comments
Add your comment