Paycheck Employee Hours - Dept Access

Description

You can use the query to create a detailed spreadsheet of paycheck information for a specific ID or your department based on the selection criteria you enter.  It is helpful for providing an employee a detailed payroll record report.  It can be used to determine eligibility for FMLA based on hours worked.

IUIE Path

Master Catalog > Departmental Reporting > Payroll Reports - Departmental

Query Fields

  1. Employee ID(s): Enter ID number(s) or leave blank if you want to include ALL 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 in the format shown.
  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 click on the Valid Values button to select from a list to limit the report to one or more paygroups.
  6. Chart: leave blank to search across all charts, or click on the Valid Values button to select from a list to limit the report to one or more charts.
  7. Department: leave blank to search across all departments, click on the Valid Values button to select from a list 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 (totals) based on earn code (unusual).
  9. Select Output Format: MS Excel (XLSX) is the only output option for this report.
  10. 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.
  11. Click the RUN button.