Submit a ticket

Standard AQ - Comprehensive Employee

Updated on Follow
0 out of 0 found this helpful

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.

Comprehensive_EmployeeAQ.PNG

 

 

Parameters

Parameter Name

Options

Description

Branch (Employee)

All available branches

Branch of Employee

Start Date

 

 

End Date

 

 

Date Type

Date Entered, Hire Date, First Paycheck Date, Last Paycheck Date, Paycheck 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

LastName

Employee’s Last name

FirstName

Employee’s First name

MiddleName

Employee’s Middle name

SSN

Employee’s SSN

EmployeeStatus

Employee’s Status

OnAssignment

Employee’s On Assignment? (Checkbox)

Street1

Employee’s Primary Address Street 1

Street2

Employee’s Primary Address Street 2

City

Employee’s Primary Address City

State

Employee’s Primary Address State

ZipCode

Employee’s Primary Address Zip Code

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

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’s has W2? (Checkbox)

WebLogin

Employee has 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

Firstly it looks at the Employee Interview section and if there is no value there, it looks at the Employee Extra section.

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)

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 Accruals

Show multiple columns for all active Accrual setup with Balance Amount dynamically.

Employee Contact Methods Show multiple columns for Employee's contact methods dynamically.
Employee Dates Show multiple columns for Employee's Date types dynamically.
Employee User Show multiple columns for Employee's User types dynamically.
Extra Value Pulls a specific Extra value as selected in the Extra Value Parameter. 

 

 

** Need to set up following Config ChoiceCodes: MainCategory = EmployeeInterview and EmployeeExtra, SystemName = Source

 

** Need to set up following Config ChoiceCodes: MainCategory = EmployeeExtra, SystemName = SourceDetail

 

 

 

 

 

 

 

 


Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.