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 |