Standard AQ - 401K Census AQ

The 401K Census AQ is a standard Advanced Query report in Avionté Classic that provides detailed 401K deduction and contribution data for each employee. Use it to compile employee-level or paycheck-level data for census submissions to your 401K plan administrator.

Standard AQ — Overview

On This Page

Report Description

Parameters

Report Fields

Report Description

The 401K Census AQ provides details of 401K deductions and contributions for each employee. You can view results at the employee level (summarized totals) or at the individual payment check level, giving you the flexibility to match your plan administrator's reporting requirements.

Note: The Date of Termination field reflects the most recent assignment End Date for employees whose status has ImpliesActive set to False. Employees with any other status will display a termination date.

Parameters

Use the parameters below to filter report results before running the query.

Parameter Name	Options	Description
Branch (Employee)	All available branches	Filter results by the employee's assigned branch.
Start Date (Check Date)		Beginning of the check date range for the report.
End Date (Check Date)		End of the check date range for the report.
Show Summary	Yes / No	Yes — displays hours and wages per employee. No — displays hours and wages per individual paycheck.
401K Deductions List	All 401K-related deduction pay codes	Filter for one or more specific 401K deduction pay codes.
401K Contributions List	All 401K-related contribution pay codes	Filter for one or more specific 401K contribution pay codes.

Report Fields

The table below describes each field returned in the 401K Census AQ. Dynamic deduction and contribution columns appear based on the pay codes selected in the parameters.

Field Name	Description
Staffing Supplier Desc	The employee's staffing supplier name.
Branch	The employee's assigned branch.
Employee ID	The employee's ID from Classic Back Office.
BOLD Talent ID	The talent's ID from the AviontéBOLD front end.
Last Name	The employee's last name.
First Name	The employee's first name.
Middle Name	The employee's middle name.
SSN	The employee's Social Security Number.
Gender	The employee's gender.
Street 1	Street line 1 from the employee's primary address.
Street 2	Street line 2 from the employee's primary address.
City	City from the employee's primary address.
State	State from the employee's primary address.
Zip	Zip code from the employee's primary address.
Date of Birth	The employee's date of birth.
Date of Hire	The employee's first assignment start date.
Rehire Date	The employee's most recent rehire date.
Status	The employee's current status.
Date of Termination	The last assignment end date from the employee's most recently ended assignment. The employee's status must have ImpliesActive = False for this date to display; otherwise the field is blank.
Phone	The employee's primary phone number.
Email	The employee's email address.
Check Number	The check number from the employee's paycheck within the date range. Only visible when Show Summary = No.
Check Date	The date of the employee's paycheck. Only visible when Show Summary = No.
Accounting Period Date	The accounting period date of the employee's check. Only visible when Show Summary = No.
Hours	Total hours from the employee's paychecks within the selected date range. Salary hours are included by multiplying against the hourly equivalent multiplier for the pay period. Show Summary = Yes — total hours per employee across all checks in the date range. Show Summary = No — total hours per individual paycheck.
Wages	Total wages from the employee's paychecks within the selected date range. Show Summary = Yes — total wages per employee across all checks in the date range. Show Summary = No — total wages per individual paycheck.

Dynamic Deduction and Contribution Fields

The following columns appear dynamically based on the deduction and contribution pay codes included in the report. Each pay code generates its own set of columns.

Field Name	Description
Deduction Amount	Column header format: [Ded – Deduction Pay Code – Amount] Total deduction amount for the specified pay code. Show Summary = Yes — total per employee across all checks in the date range. Show Summary = No — total per individual paycheck.
Deduction Amount YTD	Column header format: [Ded – Deduction Pay Code – YTD] Total year-to-date deduction amount for the specified pay code. Only shown when Show Summary = Yes.
Deduction Amount LTD	Column header format: [Ded – Deduction Pay Code – LTD] Total lifetime-to-date deduction amount for the specified pay code. Only shown when Show Summary = Yes.
Contribution Amount	Column header format: [Cont – Contribution Pay Code – Amount] Total contribution amount for the specified pay code. Show Summary = Yes — total per employee across all checks in the date range. Show Summary = No — total per individual paycheck.
Contribution Amount YTD	Column header format: [Cont – Contribution Pay Code – YTD] Total year-to-date contribution amount for the specified pay code. Only shown when Show Summary = Yes.
Contribution Amount LTD	Column header format: [Cont – Contribution Pay Code – LTD] Total lifetime-to-date contribution amount for the specified pay code. Only shown when Show Summary = Yes.