Skip to main content

Paycheck Employee Hours - Dept Access

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.

Screenshot of Paycheck Employee Hours Query