RecruitingCandidatesexperience
RecruitingCandidatesexperience
Columns
Name | Type | Description |
RecruitingCandidatesCandidateNumber [KEY] | String | Finds recruiting candidate using unique ID and candidate number |
PreviousEmploymentId [KEY] | Long | Previous employment ID in recruiting candidate experience. |
EmployerName | String | Employer name in recruiting candidate experience. |
JobTitle | String | Job title in recruiting candidate experience. |
StartDate | Date | Start date in recruiting candidate experience. |
EndDate | Date | End date in recruiting candidate experience. |
CurrentJobFlag | Bool | Current job indicator in recruiting candidate experience. |
EmployerCountryId | Long | Employer country ID in recruiting candidate experience. |
EmployerCity | String | Employer city in recruiting candidate experience. |
Responsibilities | String | Responsibilities in recruiting candidate experience. |
FullTimeCode | String | Full time code in recruiting candidate experience. |
InternalFlag | Bool | Internal indicator in the recruiting candidate experience. |
BusinessType | String | Business type in recruiting candidate experience. |
EmployerPhone | String | Employer phone in recruiting candidate experience. |
Department | String | Department in recruiting candidate experience. |
JobFamilyId | Long | Job family ID in recruiting candidate experience. |
JobFunction | String | Job function in recruiting candidate experience. |
OtherJobFunction | String | Other job function in recruiting candidate experience. |
Achievements | String | Achievements in recruiting candidate experience. |
DirectReports | Long | Direct reports in recruiting candidate experience. |
StartingPosition | String | Starting position in recruiting candidate experience. |
SupervisorName | String | Supervisor name in recruiting candidate experience. |
SupervisorTitle | String | Supervisor title in recruiting candidate experience. |
SupervisorEmail | String | Supervisor email in recruiting candidate experience. |
SupervisorPhone | String | Supervisor phone in recruiting candidate experience. |
ContactSupervisorFlag | Bool | Contact supervisor indicator in the recruiting candidate experience. |
LeavingReason | String | Leaving reason in recruiting candidate experience. |
AdditionalInformation | String | Additional Information in recruiting candidate experience. |
StartCompensation | Double | Start compensation in recruiting candidate experience. |
EndCompensation | Double | End compensation in recruiting candidate experience. |
OtherCompensation | String | Other compensation in recruiting candidate experience. |
CompanyURL | String | Company URL in recruiting candidate experience. |
SectionId | Long | Section ID in recruiting candidate experience. |
EmployerStateId | Long | Employer state ID in recruiting candidate experience. |
ExperienceInYears | Double | Experience in years in recruiting candidate experience. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
CandidateNumber | String | CandidateNumber |
Finder | String | finder |
Keywords | String | keywords |
PersonId | String | personId |