Standard Report - Time Entry Sheet View

Report Description

Shows all time entries in Sheet View. This report is useful to see the total number of hours an employee worked and some details about their pay and bill rates grouped by customer.

Parameters

Parameter Name	Options	Explanation
Branch	All available branches	Transaction’s Branch
Time Entry Batch ID		Filters results by Time Entry Batch ID.
Time Entered/Unentered	Both, Entered Only, Unentered Only	Filters results based upon the Option selected.
Transaction Type	All choice codes present in ConfigTransactionType that have IsTransactional set to True.	Filters results by Pay Code selected.
Start Date
End Date
Order Type	All Temp & DH Order types	Filters results based upon the Order Type selected.
Date Type	Accounting Period Date, Week Worked Date	Transaction’s Accounting Period or Week Worked.
Customer Name		Filters results by Customer Name.
Group By Batch ID	True, False	When True, the report groups the data by Batch ID as well

Report Fields

Field Name	Explanation
W/E Date	Transaction’s week worked date.
Branch	Transaction’s Branch.
Batch ID	Batch ID from the transaction. Visible only when Group By Batch ID = True.
Customer	Customer name from the transaction.
Department	Department name from the transaction.
Employee Name	Employee name from the transaction.
Phone	Employee’s phone number.
Job Title	Employee’s job title associated with the transaction.
Trans.Type	Pay code from Transaction
Pay Unit	Pay Unit from Transaction
Bill Unit	Bill Unit from Transaction
Pay Rate	Pay Rate from Transaction
Bill Rate	Bill Rate from Transaction
Item Pay	Item Pay from the transaction
Item Bill	Item Bill from the transaction
Start Date	Start Date of Active assignment associated with the transaction.
End Date	End Date of Active assignment associated with the transaction.
Paid Date	The latest check date of the Employee associated with the transaction. (Helps to know if was employee paid recently)

Special Logic

1. The page is separated per Supplier.
2. There are two Summary Boxes; Supplier Total and Report Total.
   1. Total shows the Total Number of Employees, Total Pay Unit, Total Item Pay, Total Number of Customers, Total Bill Unit, and Total Item Bill details for the Supplier.
   2. Report Total shows the Total Number of Employees, Total Pay Unit, Total Item Pay, Total Number of Customers, Total Bill Unit, and Total Item Bill details for the whole report.