University of Illinois System

Employee Job/Job Detail Listing

List of employees and job/job detail information for a specific college on a specific campus. The report is grouped by organization and sorted by employee.

Universe

EDW - HR Position and Job Hierarchy

Data Rules Related to this Report

  • This report will include employees with a home department or timesheet organization matching the entered campus/college code. Looking at the report conditions, campus/college code is set-up to match on employee campus/college code OR job detail campus/college code. A match on employee campus/college code will pull employees whose home department is in the specified unit. A match on job detail campus/college code identifies timesheet organization, pulling employees who have a job in the specified unit, but have a different home department.
  • This report is grouped by employee home department organization code. An employee’s home department may be different than their timesheet organization. Therefore, your report may include organization codes outside of your home department.
  • This report includes extra help employees, one time payment employees, student employees, etc.
  • This report includes all employees who are not terminated, including those employees on leave.
  • The job end date column will contain an asterisk (*) when the job has no end date.

Report

JobDetail_Listing