RecruitingJobApplicationsexperience
RecruitingJobApplicationsexperience
Columns
Name | Type | Description |
RecruitingJobApplicationsJobApplicationId [KEY] | Long | Finds the job application using a primary key and an application ID |
EmployerName | String | Name of the employer. |
PreviousEmploymentId [KEY] | Long | ID assigned to the previous employer. |
JobTitle | String | Title held in the previous job. |
StartDate | Date | Start date of the previous job. |
EndDate | Date | End date of previous employment. |
CurrentJobFlag | Bool | Indicates if it's the candidate's current job. |
EmployerCountryId | Long | ID assigned to the country where the candidate was employed. |
EmployerCity | String | City of previous employment. |
Responsibilities | String | Responsibilities undertaken in the previous job. |
FullTimeCode | String | Code assigned for full time employment. |
InternalFlag | Bool | Indicates if the job application is internal. |
BusinessType | String | Type of business of the company the candidate worked for. |
EmployerPhone | String | Phone of the employer. |
Department | String | Name of the department the candidate worked in. |
JobFamilyId | Long | ID assigned to the previous job family. |
JobFunction | String | Function of the previous job. |
OtherJobFunction | String | Additional functions assigned in the previous job. |
Achievements | String | Achievements made in |
DirectReports | Long | Details of the direct reports. |
StartingPosition | String | Position held in the previous job. |
SupervisorName | String | Name of the supervisor in the previous job. |
SupervisorTitle | String | Title of the supervisor in the previous job. |
SupervisorEmail | String | Email of the supervisor who can be contacted. |
SupervisorPhone | String | Phone number of the supervisor in the previous job. |
ContactSupervisorFlag | Bool | Indicates if it's the supervisor of the candidate who can be contacted. |
LeavingReason | String | Reason to leave the previous job. |
AdditionalInformation | String | Additional information about previous work experience. |
StartCompensation | Double | Compensation drawn at the beginning of previous job. |
EndCompensation | Double | Compensation last drawn by the candidate. |
OtherCompensation | String | Additional compensation availed from previous job. |
CompanyURL | String | URL of the company. |
SectionId | Long | ID assigned to each section in previous work experience. |
EmployerStateId | Long | State ID of the employer. |
ExperienceInYears | Double | Experience with the previous employer in years. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
EmailAddress | String | EmailAddress |
JobApplicationId | Long | JobApplicationId |
RequisitionNumber | String | RequisitionNumber |
Finder | String | finder |