Employee List of Positions

Description

Use this query to generate an employee's current job summary list by record number. Alternatively, a user may run this query to generate a list of departmental employees who belong to specific group(s).

IUIE Path

Master Catalog > Human Resource Management System > Payroll > HRMS > Payroll Reports

Or

Master Catalog > Departmental Reporting > Payroll Reports - Departmental

Query Fields

  1. Campus Code(s): leave blank to search across all campuses, or enter a value(s) to limit the report to one or more campuses.
  2. Department Code(s): leave blank to search across all departments, or enter a value(s) to limit the report to one or more departments.
  3. Appointment Type: leave blank to search across all appointment types, or enter a value(s) to limit the report to one or more appointment types.
  4. Employee Status(s): leave blank to search across all employee statuses, or enter a value(s) to limit the report to one or more statuses. A (Active), L (Leave of Absence), and P (Leave With Pay) will be entered by default.
  5. Salary Plan: leave blank to search across all salary plans, or enter a value(s) to limit the report to one or more salary plans.
  6. Salary Grade: leave blank to search across all salary grades, or enter a value(s) to limit the report to one or more salary grades.
  7. Paygroup: leave blank to search across all paygroups, or enter a value(s) to limit the report to one or more paygroups.
  8. Employee Id(s): leave blank to search all employee data, or enter one or more 10-digit ID numbers to limit the report to one or more employees.
  9. Order By: by default, the report will be ordered by the employee names; alternatively, it can be ordered by employee ID numbers or chart codes.
  10. Include Funding? By default, this box will be unchecked. Check this box to add additional columns for the position's chart, department, account, sub-account, object code, fund group, and funding percentage or amount.
  11. Include Email Address? By default, this box will be unchecked. Check this box to add an additional column for the employee's email address.
  12. Include Position Description? By default, this box will be unchecked. Check this box to add an additional column for the employee's job title (not full job description).
  13. Select Output Format: MS Excel (XLSX) is the only output option for this report.
  14. Select Output Destination: this report usually runs quickly; "Wait" is a good option.