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 | |
| StatutoryEmployeeIndicator | Indicates if the Employee is a Statutory Employee |
| Box12:<Code> | Dynamically pulls the Value of Box 12 Code |
| Box14:<Code> | Dynamically pulls the Value of Box 14 Code |
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 |
Comments
0 commentsPlease sign in to leave a comment.