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 |