Paycheck Employee Hours - Dept Access

Description

Use this query to create a detailed list of paycheck information for either a specific ID or for your department. This report is especially useful to determine eligibility for FMLA based on hours worked.

IUIE Path

Master Catalog > Departmental Reporting > Payroll Reports - Departmental

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. Paygroup: leave blank to search across all paygroups, or enter a value(s) to limit the report to one or more paygroups.
  6. Chart: leave blank to search across all charts, or enter a value(s) to limit the report to one or more charts.
  7. Department: leave blank to search across all departments, or enter a value(s) to limit the report to one or more departments.
  8. 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.
  9. Select Output Format: MS Excel (XLSX) is the only output option for this report.
  10. Select Output Destination: this report usually runs quickly; "Wait" is a good option.