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. |
| 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. |
