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


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:

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


  1. HRS Navigation: Reporting Tools > Query > Query Viewer.

  2. Enter the Query Name (UW_HR_EXPECTED_JOB_END_DATE) in the "begins with" field

  3. Click on the "Search" button

  4. Click on the Run to HTML link or the Run To Excel link


  5. 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)


  6. View results

Additional Resources

Related KBs:

Related Links:

    Get Help

    • Click HERE to contact UW Shared Services or HERE for the Office of Technology Services (OTS) Helpdesk if you have any issues with these instructions.

    To the top