Standard AQ - 401K Census AQ

Report Description

This AQ gives the details of 401K Deduction and 401K Contribution for Employee. The user can view the report at the Employee level or at the Payment Check level.

Note: The DateOfTermination is the most recent assignment EndDate for those employees who have Employee Status with ImpliesActive set to False.  All the employees with a status other than ImpliesActive=TRUE will have the termination date. 

Parameters

Parameter Name	Options	Explanation
Branch (Employee)	All available branches.	Employee’s Branch.
Start Date (Check Date)
End Date (End Date)
Show Summary	Yes/No	For Show Summary = Yes, show hour and Wages per Employee For Show Summary = No, show hour and wages per check
401K Deductions List	Lists all 401K related Deduction type Pay codes	Filter for any selected 401K Deduction pay codes
401K Contributions List	Lists all 401K related Contribution type Pay codes	Filter for any selected 401K Contribution pay codes

Report Fields

Field Name	Description
Staffing Supplier Desc	Employee’s Supplier Name.
Branch	Employee’s Branch
Employee ID	Employee ID from Employee
BOLD Talent ID	Talent ID from Front End (BOLD)
Last Name	Employee’s Last Name
First Name	Employee’s First Name
Middle Name	Employee’s Middle Name
SSN	Employee’s Social Security number
Gender	Employee’s Gender
Street1	Street 1 from Employee’s Primary Address
Street2	Street 2 from Employee’s Primary Address
City	City from Employee’s Primary Address
State	State from Employee’s Primary Address
Zip	Zip code 1 from Employee’s Primary Address
Date of Birth	Employee’s Date of Birth
Date of Hire	First Assignment Start Date for Employee
Status	Employee’s current status
Date of Termination	Last Assignment End Date from recently ended Assignment for Employee.  The status of the employee must be ImpliesActive = False; otherwise, the date won't display.
Phone	Employee’s primary Phone number
Email	Employee’s Email ID
Check Number	Check Number from Employee’s PayCheck in Date Range. (This field is only visible for Show Summary = No)
Check Date	Check Date from Employee’s Check. (This field is only visible for Show Summary = No)
Accounting Period Date	Accounting Period Date of Employee’s Check. (This field is only visible for Show Summary = No)
Hours	Total Hours from the Employee’s PayCheck in date range. Salary Hours is included by Multiplying it with Hourly equivalent Multiplier based on the Pay Period. For Show Summary = No, this field shows total Hours per Payment Check For Show Summary = Yes, this field shows total Hours per Employee from all the checks in date range
Wages	Total Wages from the Employee’s PayCheck in date range For Show Summary = No, this field shows total Wages per Payment Check For Show Summary = Yes, this field shows total Wages per Employee from all the checks in date range
The Following Dynamic fields are shown for different Deduction and Contribution pay codes:
Deduction Amount	Column header is shown as [Ded – Deduction Pay code - Amount] ·        This is Total Deduction Amount for particular Deduction Pay code For Show Summary = No, this field shows total Deduction Amount for particular Deduction Pay code per Payment Check For Show Summary = Yes, this field shows total Deduction Amount per Employee from all the checks in date range
Deduction Amount YTD	Column header is shown as [Ded – Deduction Pay code - YTD] **Only shown for Show Summary = Yes ** ·        This is Total Year-To-Date Deduction Amount for particular Deduction Pay code
Deduction Amount LTD	Column header is shown as [Ded – Deduction Pay code - LTD] **Only shown for Show Summary = Yes ** ·        This is Total Life Time-To-Date Deduction Amount for particular Deduction Pay code
Contribution Amount	Column header is shown as [Cont – Contribution Pay code - Amount] ·        This is Total Contribution Amount for particular Contribution Pay code For Show Summary = No, this field shows total Contribution Amount for particular Contribution Pay code per Payment Check For Show Summary = Yes, this field shows total Contribution Amount per Employee from all the checks in date range
Contribution Amount YTD	Column header is shown as [Cont – Contribution Pay code - YTD] **Only shown for Show Summary = Yes ** ·        This is Total Year-To-Date Contribution Amount for particular Contribution Pay code
Contribution Amount LTD	Column header is shown as [Cont – Contribution Pay code - LTD] **Only shown for Show Summary = Yes ** ·        This is Total Life Time-To-Date Contribution Amount for particular Contribution Pay code