HR - Expected Job End Date Query

GENERAL DESCRIPTION:

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 by Department, Division, and Campus staff that have access to Query Viewer.   This will give ample time for the campuses to review the EJED's and make any necessary adjustments to prevent early termination of employees.
  • See HR - Maintaining Expected Job End Date for steps to change the Expected Job End Date.



PROCEDURE STEPS:

  1. Navigate to 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

    92queryviewer.jpg

  5. Enter report parameters:
    • Business Unit (Required)
    • As of Date (Required)
    • 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)

92reportparameters.jpg

View results


ADDITIONAL RESOURCES:

Related KBs:

Related Links:
    • N/A



    Keywords:EJED Expected Job End Date Fixed Terminal termination early termination   Doc ID:19326
    Owner:Tom O.Group:Human Resource System (HRS)
    Created:2011-08-01 19:00 CDTUpdated:2017-10-11 07:27 CDT
    Sites:Human Resource System (HRS)
    Feedback:  0   0