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 |