Standard AQ - Get Employee Fed W2

Special Logic

Combination of following parameter is not valid; and will give random results:

Data Source = Compare and Return Type = Results

Shows data for Quarter 4 only and should have data in gs_EmployeeFedW2 for Q4.

 

 

Required Setup

AQ is using Supplier Property: GenerateSeparateGSXMLFile

For the Supplier selected in the parameter, if the supplier property GenerateSeparateGSXMLFile is TRUE, the AQ pulls the results for the selected Supplier in the parameter and its child suppliers whose supplier property GenerateSeparateGSXMLFile is FALSE.

For the Supplier selected in the parameter, if the supplier property GenerateSeparateGSXMLFile is FALSE, the AQ pulls the results only for the selected Supplier in the parameter

 

 

Report Description

This report shows all federal W2 information for an employee.

 

 

Parameters

Parameter Name

Options

Description

Supplier (Reporting to GS)

All available Suppliers

 

Branch (Employee)

All available Branches

 

Year

Pass a Year ID

 

SSN

 

 

Data Source

Avionte, Compare, GShades

If Data Source = Avionte, pull Taxable Gross and Tax Amount from Avionte Tables

If Data Source = GShades, pull Taxable Gross and Tax Amount from GShades Tables

If Data Source = Compare, show comparison between Taxable Gross and Tax Amount between Avionte data and GShades data

Return Type

Results, Summary

If Return Type = Results, Show data in employee level

If Return Type = Summary, show data as Summary for a selected Supplier

Sort By

Name, SSN

 

 

 

Report Fields

Data Source = Avionte and Return Type = Results

Field Name

Description

EmployeeBranch

Employee's Branch

SSN

Employee’s SSN

First Name

Employee’s First Name

Middle Name

Employee’s Middle Name

Last Name

Employee’s Last Name

Full Name

Employee’s full name

Fed Taxable Gross

Total Taxable Amount for Federal Tax

Fed Tax Amount

Total Federal Tax deducted from employee’s paycheck

FICA Taxable Gross

Total Taxable Amount for FICA Tax

FICA Tax Amount

Total FICA Tax deducted from employee’s paycheck

Med Taxable Gross

Total Taxable Amount for MED Tax

Med Tax Amount

Total MED Tax deducted from employee’s paycheck

BoldTalentID

The identifier for the employee in AviontéBOLD (Front Office)

Phone

Primary phone from employee contact method

Street1 Employee’s Street1 Address
Street2 Employee’s Street2 Address
City  Employee’s City
State Employee’s State
Zip Employee’s Zip Code
Email Address Employee’s Email Address
Phone Employee’s Phone
Electronic W2 Employee Interview answer for the question: Electronic W-2
SocialSecurityTips Total Tips amount reported to the Employer to be subjected to Social Security withheld
AllocatedTips  
DependentCareBenefits Total Dependent Care Benefit amount
NonQualifiedPlan457  
Box12TextOne  
Box12TextTwo  
Box12TextThree  
Box12TextFour  
StatutoryEmployeeIndicator Indicates if the Employee is a Statutory Employee

 

 

Data Source = Avionte and Return Type = Summary

Field Name

Description

Payee Count Total Employee Count in selected Year for selected Supplier
Total Gross Total Gross Amount from Check
Avionte Fed Taxable Gross Total Taxable Gross for Federal Tax from Avionte
Avionte Fed Tax Amount Total Fed Tax Amount from Avionte
Avionte FICA Taxable Gross Total Taxable Gross for FICA Tax from Avionte
Avionte FICA Tax Amount Total FICA Tax Amount from Avionte
Avionte Med Taxable Gross Total Taxable Gross Med Tax from Avionte
Avionte Med Tax Amount Total Med Tax Amount from Avionte

 

 

Data Source = Compare and Return Type = Results

Field Name

Description

Employee Branch Employee’s Branch
SSN Employee’s SSN
BoldTalentID The identifier for the employee in AviontéBOLD (Front Office)
Last Name Employee’s First Name
First Name Employee’s Middle Name
Middle Name Employee’s Last Name
Full Name Employee’s full name

Street 1

Employee’s Street1 Address

Street 2

Employee’s Street2 Address

City

Employee’s City

State

Employee’s State

Zip

Employee’s Zip Code

Email Address

Employee’s Email Address

Phone

Employee’s Phone

Electronic W2

Employee Interview answer for the question: Electronic W-2

Gross Wages

 

Fed Taxable Gross

Total Taxable Amount for Federal Tax

Fed Taxable Gross 1

 

Fed Tax Amount

Total Federal Tax deducted from employee’s paycheck
Fed Tax Amount 1  
FICA Taxable Gross Total Taxable Amount for FICA Tax
FICA Taxable Gross 1  
FICA Tax Amount Total FICA Tax deducted from employee’s paycheck
FICA Tax Amount 1  
Med Taxable Gross  Total Taxable Amount for MED Tax
Med Taxable Gross 1  
Med Tax Amount Total MED Tax deducted from employee’s paycheck
Med Tax Amount 1  

 

 

Data Source = Compare and Return Type = Summary

Field Name

Description

Payee Count

Total Employee Count in selected Year for selected Supplier

Total Gross

Total Gross Amount from Check

GShades Fed Taxable Gross

Total Taxable Gross for Federal Tax from GShades

Avionte Fed Taxable Gross

Total Taxable Gross for Federal Tax from Avionte

GShades Fed Tax Amount

Total Fed Tax Amount from GShades

Avionte Fed Tax Amount Total Fed Tax Amount from Avionte
GShades FICA Taxable Gross Total Taxable Gross for FICA Tax from GShades
Avionte FICA Taxable Gross Total Taxable Gross for FICA Tax from Avionte
GShades FICA Tax Amount Total FICA Tax Amount from GShades
GShades Med Taxable Gross Total Taxable Gross for Med Tax from GShades
Avionte Med Taxable Gross Total Taxable Gross Med Tax from Avionte
GShades Med Tax Amount Total Med Tax Amount from GShades
Avionte Med Tax Amount Total Med Tax Amount from Avionte

 

 

Data Source = GShades and Return Type = Results

Field Name

Description

EmployeeBranch Employee’s Branch
SSN Employee’s SSN
First Name Employee’s First Name
Middle Name Employee’s Middle Name
Last Name Employee’s Last Name
Full Name Employee’s full name
Street1 Employee’s Street1 Address
Street2 Employee’s Street2 Address
City  Employee’s City
State Employee’s State
Zip Employee’s Zip Code
Email Address Employee’s Email Address
Phone Employee’s Phone
Electronic W2 Employee Interview answer for the question: Electronic W-2
Gross Wages Employee’s Gross Wages
Fed Taxable Gross Total Taxable Amount for Federal Tax
Fed Tax Amount Total Federal Tax deducted from employee’s paycheck
FICA Taxable Gross Total Taxable Amount for FICA Tax
FICA Tax Amount Total FICA Tax deducted from employee’s paycheck
Med Taxable Gross  Total Taxable Amount for MED Tax
Med Tax Amount Total MED Tax deducted from employee’s paycheck
BoldTalentID The identifier for the employee in AviontéBOLD (Front Office)
Phone Primary phone from employee contact method

 

 

Data Source = GShades and Return Type = Summary

Field Name

Description

Payee Count Total Employee Count in selected Year for selected Supplier
Total Gross Total Gross Amount from Check
GShades Fed Taxable Gross Total Taxable Gross for Federal Tax from GShades
GShades Fed Tax Amount Total Fed Tax Amount from GShades
GShades FICA Taxable Gross Total Taxable Gross for FICA Tax from GShades
GShades FICA Tax Amount Total FICA Tax Amount from GShades
GShades Med Taxable Gross Total Taxable Gross for Med Tax from GShades
GShades Med Tax Amount Total Med Tax Amount from GShades

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share