Employee Hours by Job report

The Employee Hours by Job report shows hours for each job in which the employees accrued hours within the selected time period. The hours for each job are organized by paycode. The report includes totals for each employee, all employees combined, and grand totals by paycode. A special box at the end of the report includes the names of any employees whose data is out of date and the total number of employees who are not up to date.

Use the Employee Hours by Job (Excel) report if you plan to export results to Excel.

Note: You cannot change this report, but you can copy it and modify the copy.

  1. From your Report Library, click tap Run Report
  2. In the Select Report panel, select Timekeeping > Employee Hours by Job and click tap Select.
  3. From the report panel, select the following parameters:
    • Click Tap Select Timeframe . Then, in the Timeframe panel, select the appropriate timeframe or click tap Select Range to select a range of dates. When finished, click tap .
    • Click Tap Select Hyperfind . Then, in the Locations & Hyperfinds panel, select the appropriate location or Hyperfind. If you have the appropriate access, you can also do the following:
    • Click Tap New Hyperfind to create a new Hyperfind. See Hyperfind queries for more information.
    • Click Tap Select Locations to open the Select locations glancepanel.
    • When finished, click tap .
  4. Paycodes — Click Tap more . In the Paycodes panel, select the applicable paycodes, then click tap Apply
  5. Output Format — Select one of the following:
  6. Click Tap Run report. An In Progress message displays while the report is running.
  7. Click Close to close the panel.
  8. Click OK when the Report is Completed message appears. If you created a PDF or Excel report, a link appears at the bottom of the Report Library. If you created an interactive report, the report opens in a new tab automatically.The report opens in a new window.

The report contains the following columns:

  • Employee Name (ID) — Last name, first name with the employee's ID.
  • Location — The organizational location where the job is performed.
  • Job — The name of a job in which the employee accrued time or money.
  • Paycode — The name of the paycode to which the hours or money for the given job was applied.
  • Employee Status — The current status for the employee (Active, Inactive, or Terminated) and the date on which the current status became effective.
  • Status Date — The applicable date
  • Primary Job — The job to which the employee is assigned.
  • Money — The amount of money applied to the given paycode for the given job.
  • Hours — The number of hours applied to the given paycode for the given job.
  • Days — The number of days applied to the given paycode for the given job.

Grand Total by Paycodes — The total money, hours, and wages for each paycode included in the report, across all employees and jobs.

Total Number of Employees — The total number of employees who are included in the report.

If applicable, the total number of employees who are not totalized also appears as well as the employee's name (last, first) and ID.