Running the Expected Job End Date (EJED) Query in HRS

Overview

This report should be run on a monthly basis or as needed to look at employees with future dated Expected Job End Dates (EJED's). If an employee's EJED is accurate, no action is required. If an employee’s Job has been approved for extension, then that information will need to be entered into HRS. The query can be run by Department, Division, and Campus staff that have access to Query Viewer.

Process Considerations:

The UW_HR_EXPECTED_JOB_END_DATE query can be run any time. This will give ample time for institutions to review the EJED's and make any necessary adjustments to prevent early termination of employees.
In addition, there is also the UWHRR019 Daily EJED Termination Report that is delivered via Cypress.
An employee's Continuity Code determines whether an EJED is required, optional, or not allowed; for additional information, see Continuity Status in HRS.
See Maintaining the Expected Job End Date in HRS for steps to change the Expected Job End Date.
At least one of the following security roles is needed to run this query:

UW_UNV_AM_REPORTS
UW_UNV_BN_CAMPUS_BN_UPD
UW_UNV_BN_REPORT_MGR
UW_UNV_BN_TSA_ADMINISTRATOR
UW_UNV_HR_QUERY_NS
UW_UNV_TL Camp Div PY Admin
UW_UNV_TL Non Supervisor
UW_UNV_TL Supervisor
UW_UNV_TL_VIEWONLY

You may click on the links below to navigate directly to a section:

Instructions

HRS Navigation: Reporting Tools > Query > Query Viewer.
Enter the Query Name (UW_HR_EXPECTED_JOB_END_DATE) in the "begins with" field
Click on the "Search" button
Click on the Run to HTML link or the Run To Excel link
Enter report parameters:

Business Unit (Required)
As of Date (Required - enter a date in the future; selects employees with an EJED that is on or before the date you enter)
Department (Required - Enter the full Dept ID or partial UDDS: Unit Division, Dept, or Sub Dept / For example A06% for Division)
Empl Class (Required - Enter the entire Empl Class code (AS, FA, SA1, etc), the % sign for all values, or partial (SA% for SA1, SA2, etc)

View results

To the top

Additional Resources

Related KBs:

Related Links:

UWSS Service Operations - HR

Get Help

Click HERE to contact UW Shared Services - Service Operations Department or HERE for the UWSS IT HelpDesk if you have any issues with these instructions.

To the top