Labor Ledger Empl Summary w Fringes

Description

Use this query to generate an employee's wage and fringe information.

IUIE Path

Master Catalog > Departmental Reporting > Payroll Reports - Departmental

Query Fields

  1. Fiscal Year: enter a value(s) to limit the report to one or more fiscal years.
  2. Campus Code(s): leave blank to search across all campuses, or enter a value(s) to limit the report to one or more campuses.
  3. RC Code(s): leave blank to search across all RCs, or enter a value(s) to limit the report to one or more responsibility centers.
  4. Dept Id(s): leave blank to search across all departments, or enter a value(s) to limit the report to one or more departments.
  5. Account Number(s): leave blank to search across all accounts, or enter a value(s) to limit the report to one or more accounts.
  6. 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.
  7. Position Nbr(s): leave blank to search all position numbers, or enter a value(s) to limit the report to one or more position numbers.
  8. Paygroup(s): leave blank to search across all paygroups, or enter a value(s) to limit the report to one or more paygroups.
  9. Salary Plan(s): leave blank to search across all salary plans, or enter a value(s) to limit the report to one or more salary plans.
  10. Salary Grade(s): leave blank to search across all salary grades, or enter a value(s) to limit the report to one or more salary grades.
  11. Report Format: by default, 'Standard Report' will be selected; select 'Account Report' to add additional columns for Account Numbers and Object Codes, as well as an itemized list of fringes.
  12. Select Output Format: MS Excel (XLSX) is the only output option for this report.
  13. Select Output Destination: this report can run slowly; select "Send to Completed Reports." When the report has finished, you will receive an email with a direct link to the results. Alternatively, go to the Completed Reports folder in My Catalog to open the report from within IUIE.