Employee List of Positions

Description

This query can be used to create a list of any combination of your active employees.  Use the selection criteria to specify the exact group you want to select.  Use the check boxes to include additional data fields in the output.

IUIE Path

Master Catalog > Departmental Reporting > Payroll Reports - Departmental

Query Fields

  1. Campus Code:  You can leave blank if you are entering the Department Code and you have employees on multiple campuses.

  2. Department code:  Enter your department code or click on the Valid Values button to select from a list.
  3. Appointment Type:  Leave blank for ALL or click on the Valid Values button to select from a list.
  4. Employee Status:  This will default to A,L,P (active, leave, partial leave) or click on the Valid Values button to select from a list.
  5. Salary Plan: Leave blank for ALL or click on the Valid Values button to select from a list.
  6. Salary Grade: Leave blank for ALL or click on the Valid Values button to select from a list.
  7. Paygroup: Leave blank for ALL or click on the Valid Values button to select from a list.
  8. Employee ID: Leave blank for ALL or enter a specific employee id.
  9. Order By:  Choose the sort order (alphabetic name, ID, or Chart).
  10. Include Funding: This will default to blank. If you want funding information included, check the box.
  11. Include Email Address:  This will default to blank. 
  12. Include Position Description:  This will default to blank.
  13. Include Reports to Data:  This will default to blank.
  14. Include Accrual Service Data:  This will default to blank.
  15. Select Output Format: This will default to MS Excel (XLS).
  16. Select Output Destination: You should be able to “Wait for Output” as this report runs fairly quick.
  17. Click the RUN button.