Standard AQ - Get Employee Local W2

Special Logic

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

Data Source = Compare and Return Type = Results

Required Setup

AQ is using Supplier Property: GenerateSeparateGSXMLFile and UseRootConfigTaxStaffingSupplier

If GenerateSeparateGSXMLFile = True and UseRootConfigTaxStaffingSupplier = False, data is pulled for Root Supplier.

Report Description

This report shows all local W2 information for an employee.

Parameters

Parameter Name	Options	Description
Supplier	All available Suppliers
Year ID	Pass a Year ID
State
Local Tax
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
Sort By	Name / SSN
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

Report Fields

Field Name	Description
Following fields are shown in report for Data Source = Avionte and Return Type = Results
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
Street 1	Street 1 from Employee’s primary address
Street 2	Street 2 from Employee’s primary address
City	City from Employee’s primary address
State	State from Employee’s primary address
Zip Code	Zip Code from Employee’s primary address
Gross Wages	Total Gross Wages
Local Tax Name	Tax Name of Local Tax from Tax master
Local Tax Code	Tax Code of Local Tax from GS Locality Mapping
Local Tax State	Tax State of Local Tax
Avionte Taxable Gross	Total Taxable Gross for Local Tax from Avionte
Avionte Tax Amount	Total Local Tax Amount from Avionte
BoldTalentID	The identifier for the employee in AviontéBOLD (Front Office)
Following fields are shown in report for Data Source = GShades and Return Type = Results
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
Street 1	Street 1 from Employee’s primary address
Street 2	Street 2 from Employee’s primary address
City	City from Employee’s primary address
State	State from Employee’s primary address
Zip Code	Zip Code from Employee’s primary address
Gross Wages	Total Gross Wages
Local Tax Name	Tax Name of Local Tax from Tax master
Local Tax Code	Tax Code of Local Tax from GS Locality Mapping
Local Tax State	Tax State of Local Tax
GShades Taxable Gross	Total Taxable Gross for Local Tax from GShades
GShades Tax Amount	Total Local Tax Amount from GShades
Following fields are shown in report for Data Source = Compare and Return Type = Summary
Local Tax Name	Tax Name of Local Tax from Tax master
Locality Code	Tax Code of Local Tax from GS Locality Mapping
Local Tax State	Tax State of Local Tax
Payee Count	No of Employees with respective Locality Tax
Avionte Taxable Gross	Total Taxable Gross for Local Tax from Avionte
GShades Taxable Gross	Total Taxable Gross for Local Tax from GShades
Avionte Tax Amount	Total Local Tax Amount from Avionte
GShades Tax Amount	Total Local Tax Amount from GShades
Following fields are shown in report for Data Source = GShades and Return Type = Summary
Local Tax Name	Tax Name of Local Tax from Tax master
Local Tax State	Tax State of Local Tax
Payee Count	No of Employees with respective Locality Tax
GShades Taxable Gross	Total Taxable Gross for Local Tax from GShades
GShades Tax Amount	Total Local Tax Amount from GShades
Following fields are shown in report for Data Source = Avionte and Return Type = Summary
Local Tax Name	Tax Name of Local Tax from Tax master
Local Tax State	Tax State of Local Tax
Payee Count	No of Employees with respective Locality Tax
Avionte Taxable Gross	Total Taxable Gross for Local Tax from Avionte
Avionte Tax Amount	Total Local Tax Amount from Avionte
BoldTalentID	The identifier for the employee in AviontéBOLD (Front Office)