Topics Map > Human Resource System (HRS) > HRS Human Resources Administration

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 (EJEDs). 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 at any time. This allows ample time for institutions to review the EJEDs 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

  1. HRS Navigation: Reporting Tools > Query > Query Viewer.
  2. Enter the Query Name, UW_HR_EXPECTED_JOB_END_DATE, in the blank box next to "Query Name begins with."
  3. Click Search.
  4. Click HTML link to view results in your browser, or Excel link to generate an Excel spreadsheet.

    92queryviewer.jpg
  5. Enter report parameters:
    • Business Unit - Required; click magnifying glass to select from valid values
    • 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 a full Dept ID or enter a partial Dept ID followed by the percent sign as a wildcard; example B06%
    • Empl Class  - Required; enter the full Empl Class code (i.e., AS, FA, SA1), the % sign for all values, or partial Empl Class, i.e., SA% for SA1, SA2.

    92reportparameters.jpg

  6. View results


Additional Resources

Related KBs:

Related Links:




    Keywords:EJED Expected Job End Date Fixed Terminal termination early termination HR Human Resources   Doc ID:19326
    Owner:tami e.Group:UW–Shared Services
    Created:2011-08-01 19:00 CDTUpdated:2021-10-12 12:32 CDT
    Sites:UW–Shared Services
    Feedback:  0   0