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

Comprehensive_EmployeeAQ.PNG

 

 

Parameters

mceclip0.png

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

mceclip1.png

mceclip2.png

mceclip3.png

mceclip4.png

 

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. 

 

mceclip0.png

 

 

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.