Paycheck Earn Code Detail - Dept Access

Description

This query will produce a spreadsheet of detail information from paycheck data for your employees based on the selection criteria you enter.  Can be run for specific payrolls, earn codes, or calendar years.

IUIE Path

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. 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.
  3. Department ID(s): leave blank to search across all departments, or enter a value(s) to limit the report to one or more departments.
  4. Earn Code(s): leave blank to search across all earn codes, or enter a value(s) to limit the report to one or more earn codes.
  5. Additional Pay Reason Code(s): leave blank to search across all additional pay earn codes, or enter a value(s) to limit the report to one or more additional pay earn codes.
  6. Paycheck Run Id(s): leave blank to search across all pay runs, or enter a value(s) to limit the report to one or more pay runs.
  7. Paycheck Calendar Year(s): Leave blank if selecting specific Pay Run ID or enter specific year(s).
  8. Paycheck Date Begin Range (MM/DD/YYYY):  Leave blank if selecting specific Pay Run ID or enter specific date in the format shown.

  9. Paycheck Date End Range (MM/DD/YYYY):  Leave blank if selecting specific Pay Run ID or enter specific date in the format shown.

  10. 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.
  11. Report Type: this selection will determine the level of detail provided in the report.
  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.