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.
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 |
BoldTalentID |
EmployeeID from AviontéBOLD (front office) |
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 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’ |
Comments
0 commentsPlease sign in to leave a comment.