Standard AQ - Comprehensive Employee AQ

Report Description

This report provides a summary of an employee or employees by pulling basic information as well as work and pay history for the previous three years.

You may need to set up following Config ChoiceCodes:

• MainCategory = EmployeeInterview and EmployeeExtra, SystemName = Source
• MainCategory = EmployeeExtra, SystemName = SourceDetail

To see the EEO information (provide access):

•  Config Option>> EEOviewPermission else these columns will display 'XXX'.

Parameters

Parameter Name	Options	Description
Branch (Employee)	All available branches	Branch of Employee
Date Type	Date Entered, Hire Date, First Paycheck Date, Last Paycheck Date, Paycheck Date
Start Date
End Date
Employee Status	All, Active, Applicant etc.	List outs all Employee Status; All choice codes with category EmployeeStatus
Extra Value		Value list of all Employee Extra. If Selected, the AQ will display the value of that particular extra.

Report Fields

Field	Description
Branch	Employee’s Branch
Employee ID	Employee’s ID
BoldTalentID	Employee's ID in AvionteBOLD
LastName	Employee’s Last name
FirstName	Employee’s First name
MiddleName	Employee’s Middle name
Nickname	Employee's Nickname
SSN	Employee’s SSN
EmployeeStatus	Employee’s Status
OnAssignment	Employee’s On Assignment? (Checkbox)
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
ZipCode	Zip code from Employee’s Primary Address
GeoCode	Geocode calculated from Employee's Primary Address
CountryCode	The 2 letter abbreviation for the Country
EmployeeOrigin	Shows how the employee was added to the system. WizardEntry, OnlineApplication, ResumeParsed, Contact, OutlookEmail, AeroEntry, AeroOnlineApplication
EmployeeRecordType	Shows Employee Record type:  Processed, Unprocessed, Purged
User_EEOPermission	Displays if the user running the report has access to view EEO info.
DateofBirth	Employee’s Date of Birth
Gender	Employee’s Gender
Race
Veteran
Disability
CheckDelivery	Employee’s Check Delivery
Payee Name	Payee Name associated with the Address with IsPaymentCheckAddress=1
AgencyName	Employee’s Agency Name
TaxCreditQualified	Employee’s Tax Credit Qualified? (Checkbox)
FirstPaycheckDate	Employee’s First Paycheck Date
LastPaycheckDate	Employee’s Last Paycheck Date
FirstAssignmentStartDate	Employee's first Assignment's Start Date
LastAssignmentEndDate	Employee's Last Assignment's End Date
IsW2	Employee is a W2 employee (not subagency or 1099)
US Withholding Type	Employee's Withholding Type
WebLogin	Employee has Web Login?
WebLoginName	Login name of the web login
Resume	Employee’s has Resume? (Checkbox)
I9	Employee’s has I9? (Checkbox)
Direct Deposit	Employee’s has direct deposit? (Checkbox)
ACAEligible	Employee’s ACA Eligible?
ReferralSource	Employee’s Referral Source; ChoiceCode = Source In order for data to be pulled for this field, the system name needs to be set up accordingly with the name "Source" for the employee interview configuration. Firstly it looks at the Employee Interview section and if there is no value there, it looks at the Employee Extra section. Note: Only one EmployeeInterview ChoiceCode that is mapped with SystemName "source" will pull into the reports. Multiple choice codes with SystemName "source" mapping will not be reflected in the report.
ReferralDetail	Employee’s Referral Detail; ChoiceCode = SourceDetail Firstly it looks at the Employee Interview section and if there is no value there, it looks at the Employee Extra section.
EVerifyStatus	Employee’s E-Verify Status
Tag	Show Employee Tag in Comma separated format. (Tags added in Aero)
TaxCreditStatus	Employee's WOTC Tax Credit Status
Total Wages (Current Year)	Total Gross Wages of an Employee in current year
Total Wages (Current Year – 1)	Total Gross Wages of an Employee in last year
Total Wages (Current Year – 2)	Total Gross Wages of an Employee in year before last year
Total Hours (Current Year)	Total Pay Hours of an Employee in current year
Total Hours ((Current Year – 1)	Total Pay Hours of an Employee in last year
Total Hours (Current Year – 2)	Total Pay Hours of an Employee in year before last year
Employee Contact Methods	Show multiple columns for Employee's contact methods dynamically.
Employee Dates	Show multiple columns for Employee's Date types dynamically.
Extra Value	Pulls a specific Extra value as selected in the Extra Value Parameter.
Electronic1095C	Classic/Back Office: the Config Choice system name is Electronic1095C and the choice code is Electronic 1095-C for  Category, EmployeeInterview.  Integrated/BOLD: There are new fields on the Employee record in BOLD on the Tax tab.  The data will go there and then flow into back office in the employee interview question.  Electronic 1095-c
ElectronicW2Consent	Classic/Back Office: The Config Choice name is Electronic W-2 for Category, EmployeeInterview Integrated/BOLD: There are new fields on the Employee record in BOLD on the Tax tab.  The data will go there and then flow into back office in the employee interview question.