Standard AQ - Get Employee State W2

Running the Greenshades Feed and XML for the applicable quarter is required for the form to generate data.

 

Required Setup

AQ is using Supplier Property: GenerateSeparateGSXMLFile and UseRootConfigTaxStaffingSupplier

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

 

Special Logic

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

Data Source = Compare and Return Type = Results

 

Report Description

This report shows all State W2 information for an employee.

GetEmployeeStateW2.png

 

Parameters

Parameter Name

Options

Description

Supplier

All available Suppliers

 

Year ID

Pass a Year ID

 

State

 

 

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

Gross Wages

Total Gross Wages

Tax State

Tax State of State Tax

Avionte Taxable Gross

Total Taxable Gross for State Tax from Avionte

Avionte Tax Amount

Total State 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

Gross Wages

Total Gross Wages

Tax State

Tax State of State Tax

GShades Taxable Gross

Total Taxable Gross for State Tax from GShades

GShades Tax Amount

Total State Tax Amount from GShades

 

Following fields are shown in report for Data Source = Compare and Return Type = Summary

Tax State

Tax State of State Tax

Payee Count

No of Employees with respective State Tax

Avionte Taxable Gross

Total Taxable Gross for State Tax from Avionte

GShades Taxable Gross

Total Taxable Gross for State Tax from GShades

Avionte Tax Amount

Total State Tax Amount from Avionte

GShades Tax Amount

Total State Tax Amount from GShades

 

Following fields are shown in report for Data Source = GShades and Return Type = Summary

Tax State

Tax State of State Tax

Payee Count

No of Employees with respective State Tax

GShades Taxable Gross

Total Taxable Gross for State Tax from GShades

GShades Tax Amount

Total State Tax Amount from GShades

 

Following fields are shown in report for Data Source = Avionte and Return Type = Summary

Tax State

Tax State of State Tax

Payee Count

No of Employees with respective State Tax

Avionte Taxable Gross

Total Taxable Gross for State Tax from Avionté

Avionte Tax Amount

Total State Tax Amount from Avionté

BoldTalentID

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

 

 

Articles in this section

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

Comments

0 comments

Please sign in to leave a comment.