Standard AQ - Daily Hours

Report Description

Details daily hours for employees. This report shows specific time clock information, as well as associated assignment, customer, pay, and bill information for each employee.

Parameters

Parameter Name	Options	Description
Branch (Transaction)	All available branches.	Transaction’s Branch.
Date Type	Accounting Period Date, Week Worked, Date Worked	Transaction’s Accounting Period or Week Worked or Date Worked.
Start Date
End Date
Customer Name	Free Text Field	Use this filter to refine the records by customer name

Report Fields

Field Name	Description
StaffingSupplier	Supplier Name from Transaction.
BranchName	Transaction’s Branch
AccountingPeriodDate	Transaction’s Accounting Period Date
WeekWorked	Transaction’s Week Worked Date
BatchID	Batch ID from Transaction.
CustomerName	BillToName from Transaction.
DepartmentName	DepartmentName from Transaction.
OrderID	StaffingOrderID  associated with Transaction.
Jobtitle	JobPosition from Transaction.
WcCode	Worker Comp code from Transaction
AssignmentID	Assignment ID associated with Transaction
StartDate	Assignment’s Start Date
EndDate	Assignment’s End Date
EmployeeID	Employee ID of Employee from Transaction
BOLD Talent ID	Employee ID from BOLD (Front Office)
EmployeeName	Employee Name from Transaction
SSN	Social Security Number of Employee
DayName	Day of the date worked.
Date Worked	Date of the worked date.
Type	Pay Code from Transaction
PayUnit	Daily Pay Total hours
PayRate	Pay Rate from Transaction
ItemPay	Pay Unit multiplied by Pay Rate Formula: Pay Unit * Pay Rate
BillUnit	Daily Bill Total hours
BillRate	Bill Rate from Transaction
ItemBill	Bill Unit multiplied by Bill Rate Formula: Bill Unit * Bill Rate
TimeIn	Time In from TimePunch
LunchOut	Lunch Out from TimePunch
LunchIN	Lunch In from TimePunch
Time Out	Time Out from TimePunch
BoldTimeSheetApprovedBy	Name of the user who has approved the Timesheet from AviontéBOLD
BoldTimeSheetApprovedDate	Date on which the Timesheet was approved from AviontéBOLD
BoldSavedBy	Name of the user who has saved the Timesheet from AviontéBOLD
BoldSaveTime	Date on which the Timesheet was saved from AviontéBOLD
BoldSubmittedBy	Name of the user who has submitted the Timesheet from AviontéBOLD
BoldSubmittedTime	Date on which the Timesheet was submitted from AviontéBOLD