Submit a ticket

Standard AQ - 401K Census AQ

Updated on Follow
0 out of 0 found this helpful

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.

401K_Census_AQ.jpg

 

 

 

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

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

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

 

 

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


Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.