ODBC Driver for Oracle Fusion Cloud HCM

Build 23.0.8839

RecruitingCandidatesworkPreferences

RecruitingCandidatesworkPreferences

Columns

Name Type Description
RecruitingCandidatesCandidateNumber [KEY] String Finds recruiting candidate using unique ID and candidate number
WorkPreferenceId [KEY] Long Work preference ID in recruiting candidate work preferences.
AllLocationsFlag Bool All locations preferred indicator in recruiting candidate work preferences.
Comments String Comments in recruiting candidate work preferences.
ContentItemId Long Content item ID in recruiting candidate work preferences.
CurrencyCode String Currency code in recruiting candidate work preferences.
DateFrom Date Date from in recruiting candidate work preferences.
DateTo Date Date to in recruiting candidate work preferences.
FlexibleWorkFlag Bool Flexible work required indicator in recruiting candidate work preferences.
MinimumPay Long Minimum pay in recruiting candidate work preferences.
IntlTravelFlag Bool International travel required indicator in recruiting candidate work preferences.
NatTravelFrequency String National travel frequency in recruiting candidate work preferences.
NatTravelFlag Bool Domestic travel required indicator in the recruiting candidate work preferences.
FullTimeEquivalent Double Full time equivalent in recruiting candidate work preferences.
IntlTravelRequiredFlag Bool International travel required indicator in the recruiting candidate work preferences.
IntlTravelFrequency String International travel frequency in recruiting candidate work preferences.
NatTravelRequiredFlag Bool Domestic travel required indicator in recruiting candidate work preferences.
PartAssignFlag Bool Part assign indicator in the recruiting candidate work preferences.
PayFrequency String Pay frequency in recruiting candidate work preferences.
PayRange String Pay range in recruiting candidate work preferences.
RelocateDuration Long Relocate duration in recruiting candidate work preferences.
RelocateFlag Bool Relocate indicator in the recruiting candidate work preferences.
RelocationReason String Relocation reason in recruiting candidate work preferences.
SectionId Long Section ID in recruiting candidate work preferences.
TempAssignFlag Bool Temp assign indicator in recruiting candidate work preferences.
WorkDays String Work days in recruiting candidate work preferences.
WorkHours String Work hours in recruiting candidate work preferences.
WorkMonths Long Work months in recruiting candidate work preferences.
WorkYears Long Work years in recruiting candidate work preferences.
ExcludedLocationOneId Long Excluded location one ID in recruiting candidate work preferences.
ExcludedLocationTwoId Long Excluded location two ID in recruiting candidate work preferences.
ExcludedLocationThreeId Long Excluded location three ID in recruiting candidate work preferences.
ExcludedLocationFourId Long Excluded location four ID in recruiting candidate work preferences.
PreferredLocationOneId Long Preferred location one ID in recruiting candidate work preferences.
PreferredLocationTwoId Long Preferred location two ID in recruiting candidate work preferences.
PreferredLocationThreeId Long Preferred location three ID in recruiting candidate work preferences.
PreferredLocationFourId Long Preferred location four ID in recruiting candidate work preferences.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
CandidateNumber String CandidateNumber
Finder String finder
Keywords String keywords
PersonId String personId

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839