Submit a ticket

Standard AQ - Employee Overview

Updated on Follow
0 out of 0 found this helpful

Report Description

This report enables a search for all Employee Education, Skills, Requirements, Past Jobs, Certifications, Documents, and E_Documents. It also enables a search for Employees missing the same information (education, skills, etc.), which is not possible with Advanced Search functionality.

EmployeeOverview.png 

 

 

 

Parameters

Parameter Name

Options

Description

SSN

All available SSN

 

Search Type

 

List of employees related to a search type. Like Certification, Contact method etc.

Employee Missing

 

Employees who are missing in related search types Like Certification, Contact method etc. It must be matched with choicecode.

Branch

All available branches.

 

Start Date

 

Employee Entered Date

End Date

 

Employee Entered Date

Employee Status

All available status.

 

 

 

 

 

Report Fields

Field Name

Description

Branch Name

Employee Branch

Will be visible for all parameter SearchType

Employee ID

EmployeeID from Employee.

Will be visible for all parameter SearchType

SSN

SSN from Employee.

Will be visible for all parameter SearchType

Last Name

Last Name of employee.

Will be visible for all parameter SearchType

First Name

First Name of employee.

Will be visible for all parameter SearchType

Employee Status

Status of employee.

Will be visible for all parameter SearchType

Primary Contact

Primary contact from employee contact method.

Will be visible for all parameter SearchType

Email

Email from employee contact method.

Will be visible for all parameter SearchType

Full address

Full Address from employee contact method.

Will be visible for all parameter SearchType

OnAssignment

OnAssignment from employee. Check for OnAssignment=1 and uncheck for OnAssignment=0

Will be visible for all parameter SearchType.

 

CertificationCategory

Category of certification from employee.

Will be visible for parameter SearchType=’Certification’

CertificationType

Certification name from certification type of employee.

Will be visible for parameter SearchType=’Certification’

IssuingAuthority

Authority Name from Certification authority of employee.

Will be visible for parameter SearchType=’Certification’

CertificatiionNumber

Certification number from employee certification.

Will be visible for parameter SearchType=’Certification’

IssueDate

Date of issue from employee certification.

Will be visible for parameter SearchType=’Certification’

ExpirationDate

Expiration date of certification from employee certification.

Will be visible for parameter SearchType=’Certification’

ValidatedDate

Validate date of certification from employee certification.

Will be visible for parameter SearchType=’Certification’

Notes

Notes from employee certification when SearchType=’Certification’.

Notes from date type when SearchType='Dates’.

Notes from employee education when SearchType='Education’.

Will be visible for parameter SearchType=’Certification’, SearchType='Dates’, SearchType='Education’

ContactMethodType

Contact method type from employee contact method where Category = 'EmployeeContactmethod'

Will be visible for parameter SearchType=’Contact Method’

ContactMethodValue

Contact method Value from employee contact method

Will be visible for parameter SearchType=’Contact Method’

Description

Description from employee contact method.

Will be visible for parameter SearchType=’Contact Method’

ConvictedNature

Name of nature of employee conviction. Category =’EmployeeConvictionType’. Eg: non-Violent, violent, Drug Related etc.

Will be visible for parameter SearchType=Criminal history’.

ConvictedType

Type of convicted from employee conviction. Eg: Misdemeanor, Felony etc.

Will be visible for parameter SearchType=Criminal history’.

Remarks

Remarks from employee conviction.

Will be visible for parameter SearchType=Criminal history’.

ConvictedDate

Date of convicted from employee conviction.

Will be visible for parameter SearchType=Criminal history’.

UserComments

User comment for conviction from employee conviction.

Will be visible for parameter SearchType=Criminal history’.

VerifiedDate

Date of verified of conviction from employee confiction.

Will be visible for parameter SearchType=Criminal history’.

DateType

Type of Date from date type where Category=’EmployeeDate’. Eg: Date Entered, Interviewed Date etc.

Will be visible for parameter SearchType='Dates’

Date

Date from Date type of employee.

Will be visible for parameter SearchType='Dates’

DocumentType

Type of document from employee document type where category=’EmployeeDocumentType’.

Will be visible for parameter SearchType='Documents’

DocumentFileName

File Name from document.

Will be visible for parameter SearchType='Documents’

Note

Note from document when SearchType='Documents’.

Note from Skills when SearchType='Skills’

Will be visible for parameter SearchType='Documents’, SearchType='Skills’

DocumentExpirationDate

Ecpiration date of document from document.

Will be visible for parameter SearchType='Documents’

DocumentDateEntered

Entered date of document.

Will be visible for parameter SearchType='Documents’

DocumentEnteredBy

User name of entered document from document.

Will be visible for parameter SearchType='Documents’

edocumentType

Type of eDocument from eDocument. Eg EdocumentType like I-9, W4 2013 etc.

Will be visible for parameter SearchType='EDocuments’

DateSubmitted

Submitted date of edocument.

Will be visible for parameter SearchType='EDocuments’

EdocumentStatus

Status of edocument from from edocumentstatus. Eg Status like Input, Pending Signature etc.

Will be visible for parameter SearchType='EDocuments’

IsVerified

Check if edocument is verified Isverified=1. Uncheck if edocument is not verified Isverified=0.

Will be visible for parameter SearchType='EDocuments’

IsActive

Check for active edocument, IsActive=1. Uncheck for not active edocument, IsActive=0.

Will be visible for parameter SearchType='EDocuments’

EdocumentCompletedDate

Pull the date of completed of edocument.

Will be visible for parameter SearchType='EDocuments’

EdocumentExpirationDate

Pull the expiration date of edocument.

Will be visible for parameter SearchType='EDocuments’

Degree

Education Degree of employee pull from employee education. Category=’EmployeeEducationDegree’

Will be visible for parameter SearchType='Education’

Institution

Name of Institution of employee from employeeEducation.

Will be visible for parameter SearchType='Education’

Specialization

Specialization of employee education. Like Business, Accounting etc.

Will be visible for parameter SearchType='Education’

StartDate

Education start date from employee education.

Will be visible for parameter SearchType='Education’

EndDate

Education completed or end date of employee education.

Will be visible for parameter SearchType='Education’

IsGraduated

Show the completed graduation or not. Check for completed and uncheck for not completed.

Will be visible for parameter SearchType='Education’

DateVerified

Graduation verified date from employee education.

Will be visible for parameter SearchType='Education’

City

City of graduation done from employee education.

Will be visible for parameter SearchType='Education’

State

Sate of graduation done from employee education.

Will be visible for parameter SearchType='Education’

Country

Name of country from employee education.

Will be visible for parameter SearchType='Education’

EmploymentCategory

Category of employment from employment category where category=’EmployeeEmploymentCategory’. Eg: DirectHire, TempToPerm, FT etc.

Will be visible for parameter SearchType='Employment category’

EmploymentCategoryPriority

Number the priority foe mentioned employment category. 1 for first priority,2 for second likewise.

Will be visible for parameter SearchType='Employment category’

EmploymentCategoryNotes

Notes related to that category from EmployeeEmployment category.

Will be visible for parameter SearchType='Employment category’

 

Category

Category from employee extra value. Like Emergency Information, Marketing etc.

Will be visible for parameter SearchType='Extra’

Label

Description related to category from employee extra value. Such as Emergency Contact Name, Referral Source

Will be visible for parameter SearchType='Extra’

Value

Value of the category from employee extra value. Eg ‘Jill Jablonski’ for label:emergency contact, ‘Newspaper’ for label:marketing.

Will be visible for parameter SearchType='Extra’

CustomerName

Employer name from employee past job where they had worked in past.

Will be visible for parameter SearchType='PastJobs’

CustomerPhoneNumber

Employer phone number from employee past jobs.

Will be visible for parameter SearchType='PastJobs’

JobTitle

Title of job that employee worked on past from employee past jobs (e.g. manager, Engineer, etc.)

Will be visible for parameter SearchType='PastJobs’

AgencyName

Name of agency from employee past jobs.

Will be visible for parameter SearchType='PastJobs’

TypeofJob

Types of job from employee past jobs (e.g. Perm, FT etc.)

Will be visible for parameter SearchType='PastJobs’

Supervisor

Name of Supervisor from employee past jobs.

Will be visible for parameter SearchType='PastJobs’

ReferenceComment

Reference comment from previous jobs from employee past jobs. Eg: Good etc.

Will be visible for parameter SearchType='PastJobs’

IsContactSupervisor

Check if contact supervisor where IsContactSupervisor=1, uncheck for no contact with supervisor where IsContactSupervisor=0.

Will be visible for parameter SearchType='PastJobs’

StartDate

Date of employee started work in past jobs.

Will be visible for parameter SearchType='PastJobs’

EndDate

Date of employee last worked in past jobs.

Will be visible for parameter SearchType='PastJobs’

DateEntered

Entered date of past jobs.

Will be visible for parameter SearchType='PastJobs’

DateVerified

Date an employee's last job was verified.

Will be visible for parameter SearchType='PastJobs’

LastPay

Last paid amount on past jobs from employee past jobs.

Will be visible for parameter SearchType='PastJobs’

ReasonForLeaving

The reasons of leaving past job from employee past jobs.

Will be visible for parameter SearchType='PastJobs’

Country

Name of country worked in past jobs.

Will be visible for parameter SearchType='PastJobs’

Street1

Name of Street1 worked in past jobs.

Will be visible for parameter SearchType='PastJobs’

Street2

Name of Street2 worked in past jobs.

Will be visible for parameter SearchType='PastJobs’

City

Name of City worked in past jobs.

Will be visible for parameter SearchType='PastJobs’

State

Name of State worked in past jobs.

Will be visible for parameter SearchType='PastJobs’

ZipCode

Name of ZipCode worked in past jobs.

Will be visible for parameter SearchType='PastJobs’

ReferenceType1

Type of reference from employee past job reference. Eg Supervisor, Personal etc.

Reference type may be many according to the employee filled (e.g. ReferenceType1, ReferenceType2, ReferenceType3 etc.)

Will be visible for parameter SearchType='PastJobs’

ReferenceDate1

Date of reference from employee past job reference.

Reference Date may be many according to the employee filled (e.g. ReferenceDate1, ReferenceDate2, ReferenceDate3 etc.)

Will be visible for parameter SearchType='PastJobs’

ReferenceNote1

Note of reference from employee past job reference. Eg Called supervisor,

Reference Note may be many according to the employee filled (e.g. ReferenceNote1, ReferenceNote2, ReferenceNote3 etc.)

Will be visible for parameter SearchType='PastJobs’

RequirementType

Type of requirement for employee from employee requirement where category=’Requirement’ (e.g. Drug Tested, safety Googles, Background Check etc.)

Will be visible for parameter SearchType='Requirement’

RequirementValue

Value related to requirement type (e.g. True for tested, False for not tested. Also Date of tested date.)

Will be visible for parameter SearchType='Requirement’

RequirementNote

Notes about requirement test from employee requirement. It may be failed or problem according to result.

Will be visible for parameter SearchType='Requirement’

RequirementDateEntered

Entered date of requirement from employee requirement.

Will be visible for parameter SearchType='Requirement’

SkillCode

Code of employee skills from employeeskills (e.g. Speak English, Write English, Overtime etc.)

Will be visible for parameter SearchType='Skills’

SkillStrength

Strength of the employee on related skills.

Will be visible for parameter SearchType='Skills’

SkillValidateDate

Validate date of the skill code from employee skills.

Will be visible for parameter SearchType='Skills’

Unit

Unit from employee skills (e.g. ‘1’ in  Unit type:year, ‘2’ in  Unit type:year etc.)

Will be visible for parameter SearchType='Skills’

UnitType

Type of unit from employee skills. (e.g. year, etc.)

Will be visible for parameter SearchType='Skills’

EmployeeDNACustomer

Name of customer from employee customer DNA where category=’EmployeeCustomerDNA’ and value=’EmployeeDNACustomer’.

Will be visible for parameter SearchType='Skills’

CustomerDNAEmployee

Name of customer from Customer Employee DNA where category=’EmployeeCustomerDNA’ and value=’CustomerDNAEmployee’.

Will be visible for parameter SearchType='Skills’

UserType

Type of employee from employeeuser where category=’EmployeeUser’.

Will be visible for parameter SearchType='Users’’

UserName

Name of the user from employee user.

Will be visible for parameter SearchType='Users’

 


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.