RecruitingJobApplicationsworkPreferences
RecruitingJobApplicationsworkPreferences
Columns
| Name | Type | Description |
| RecruitingJobApplicationsJobApplicationId [KEY] | Long | Finds the job application using a primary key and an application ID |
| AllLocationsFlag | Bool | Indicates candidate is ready to work from any location. |
| WorkPreferenceId [KEY] | Long | ID assigned to the candidate's work preference. |
| Comments | String | Additional comments for work preferences. |
| ContentItemId | Long | ID assigned to each content item of work preference. |
| CurrencyCode | String | Currency code of the preferred location. |
| DateFrom | Date | Start date of the work preference. |
| DateTo | Date | End date of the work preference. |
| FlexibleWorkFlag | Bool | Indicates if flexible work option is available for the job. |
| MinimumPay | Long | Minimum pay allocated to the job. |
| IntlTravelFlag | Bool | Indicates if international travel is required for the job. |
| NatTravelFrequency | String | Frequency of the domestic travel. |
| NatTravelFlag | Bool | Indicates if domestic travel is required for the job. |
| FullTimeEquivalent | Double | Indicates if full time is required. |
| IntlTravelRequiredFlag | Bool | Indicates if international travel is mandatory for the job. |
| IntlTravelFrequency | String | Frequency of the international travel. |
| NatTravelRequiredFlag | Bool | Indicates if domestic travel is mandatory for the job. |
| PartAssignFlag | Bool | Indicates if the candidate has opted for a part time job assignment. |
| PayFrequency | String | Frequency of payment for the part time assignment. |
| PayRange | String | Candidate's pay range. |
| RelocateDuration | Long | Duration for which candidate wants to be relocated. |
| RelocateFlag | Bool | Indicates that candidate has opted for relocation. |
| RelocationReason | String | Reason why the candidate has opted for relocation. |
| SectionId | Long | ID assigned to each section of work preferences. |
| TempAssignFlag | Bool | Indicates if the job assignment is for a temporary period. |
| WorkDays | String | Number of work days for the temporary work period. |
| WorkHours | String | Number of work hours for the temporary work period. |
| WorkMonths | Long | Number of work months for the temporary work period. |
| WorkYears | Long | Number of work years for the temporary work period. |
| ExcludedLocationOneId | Long | ID for the first option for excluded location. |
| ExcludedLocationTwoId | Long | ID for the second option for excluded location. |
| ExcludedLocationThreeId | Long | ID for the third option for excluded location. |
| ExcludedLocationFourId | Long | ID for the fourth option for excluded location. |
| PreferredLocationOneId | Long | First option for the preferred location. |
| PreferredLocationTwoId | Long | Second option for the preferred location. |
| PreferredLocationThreeId | Long | Third option for the preferred location |
| PreferredLocationFourId | Long | Fourth option for the preferred location. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| EmailAddress | String | EmailAddress |
| JobApplicationId | Long | JobApplicationId |
| RequisitionNumber | String | RequisitionNumber |
| Finder | String | finder |