Employee List of Positions

Query Fields

  1. Campus Code: You can leave blank if you are entering the Department Code and you have employees on multiple campuses.
  2. RC Code(s): Leave blank or enter specific RC codes if you leave the Department code blank.
  3. Department code: Enter your department code or click on the Valid Values button to select from a list.
  4. Appointment Type: Leave blank for ALL or click on the Valid Values button to select from a list.
  5. 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.
  6. Salary Plan: Leave blank for ALL or click on the Valid Values button to select from a list.
  7. Salary Grade: Leave blank for ALL or click on the Valid Values button to select from a list.
  8. Paygroup: Leave blank for ALL or click on the Valid Values button to select from a list.
  9. Employee ID: Leave blank for ALL or enter a specific employee id.
  10. Order By: Choose the sort order (alphabetic name, ID, or Chart).
  11. Include Funding: This will default to blank. If you want funding information included, check the box.
  12. Include Email Address: This will default to blank.
  13. Include Position Description: This will default to blank.
  14. Include Reports to: This will default to blank.
  15. Include Accrual Service: This will default to blank.
  16. Select Output Format: This will default to MS Excel (XLS).
  17. Select Output Destination: You should be able to “Wait for Output” as this report runs fairly quick.
  18. Click the RUN button.

Screenshot of Employee List of Positions Query