Paycheck Employee Hours

Description

Use this query to generate a list of an employee's paycheck earn code details, broken down by hours worked and amount earned.

IUIE Path

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

Query Fields

  1. 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.
  2. Look at records for the last 12 months? By default, this box will be unchecked. Check this box to run a report on the last year.
  3. Or Range Beginning Date (MM/DD/YYYY): leave blank to search all years on record, or enter a specific date at which to begin the search.
  4. Run ID: leave blank to search across all pay runs, or enter a value(s) to limit the report to one or more pay runs.
  5. Calendar Year (Paycheck Date): leave blank to search across all calendar years on record, or enter a value(s) to limit the report to one or more calendar years.
  6. Paygroup: leave blank to search across all paygroups, or enter a value(s) to limit the report to one or more paygroups.
  7. Chart: leave blank to search across all charts, or enter a value(s) to limit the report to one or more charts.
  8. Department: leave blank to search across all departments, or enter a value(s) to limit the report to one or more departments.
  9. Summary by Earn Code? By default, this box will be unchecked. Check this box to consolidate the data in the report by hours worked and amount earned based on earn code.
  10. Select Output Format: MS Excel (XLSX) is the only output option for this report.
  11. Select Output Destination: this report usually runs quickly; "Wait" is a good option.