TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems

Columns


Name	Type	Description
TalentPersonProfilesProfileId [KEY]	Long	TalentPersonProfilesProfileId of TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems
WorkpreferencesectionsProfileSectionId [KEY]	Long	WorkpreferencesectionsProfileSectionId of TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems
WorkPreferenceId [KEY]	Long	WorkPreferenceId of TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems
TravelDomestically	String	Indicates whether the worker prefers domestic travel. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
TravelDomesticallyMeaning	String	Represent whether domestic travel is required for the workforce structure.
DomesticTravelFrequency	String	Frequency of domestic travel. Valid values are defined in the commonLookupsLOV.
DomesticTravelFrequencyMeaning	String	Indicate the frequency of domestic travel.
TravelInternationally	String	Indicates whether the worker prefers international travel. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
TravelInternationallyMeaning	String	Represent whether international travel is required for the workforce structure.
InternationalTravelFrequency	String	Frequency of international travel. Valid values are defined in the commonLookupsLOV.
InternationalTravelFrequencyMeaning	String	Indicate the frequency of international travel.
WillingToRelocate	String	Indicates whether the person is willing to relocate. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
WillingToRelocateMeaning	String	Represent whether the user is willing to relocate as part of workforce structure.
AllLocations	String	Indicates whether the person is willing to relocate to any location. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
AllLocationsMeaning	String	Represent whether the user preferred to work at any location.
FirstPreferredLocationId	Long	Identifier of the first location to be preferred from user work preferences.
FirstPreferredLocationCode	String	First location to be preferred from user work preferences. Valid values are defined in the locationsLOV.
FirstPreferredLocation	String	First location to be preferred from user work preferences.
SecondPreferredLocationId	Long	Identifier of the second preferred location.
SecondPreferredLocationCode	String	Second location to be preferred from the user work preferences. Valid values are defined in the locationsLOV.
SecondPreferredLocation	String	Second location to be preferred from user work preferences.
ThirdPreferredLocationId	Long	Identifier of the third preferred location.
ThirdPreferredLocationCode	String	Third location to be preferred from the user work preferences. Valid values are defined in the locationsLOV.
ThirdPreferredLocation	String	Third location to be preferred from user work preferences.
FourthPreferredLocationId	Long	Identifier of the fourth preferred location.
FourthPreferredLocationCode	String	Fourth location to be preferred from the user work preferences. Valid values are defined in the locationsLOV.
FourthPreferredLocation	String	Fourth location to be preferred from user work preferences.
FirstExcludedLocationId	Long	Identifier of the first location to be excluded from user work preferences.
FirstExcludedLocationCode	String	First location to be excluded from user work preferences. Valid values are defined in the locationsLOV.
FirstExcludedLocation	String	First location to be excluded from user work preferences.
SecondExcludedLocationId	Long	Identifier of the second location to be excluded from user work preferences.
SecondExcludedLocationCode	String	Second location to be excluded from user work preferences. Valid values are defined in the locationsLOV.
SecondExcludedLocation	String	Second location to be excluded from user work preferences.
ThirdExcludedLocationId	Long	Identifier of the third location to be excluded from the user work preferences.
ThirdExcludedLocationCode	String	Third location to be excluded from the user work preferences. Valid values are defined in the locationsLOV.
ThirdExcludedLocation	String	Third location to be excluded from user work preferences.
FourthExcludedLocationId	Long	Identifier of the fourth location to be excluded from the user work preferences.
FourthExcludedLocationCode	String	Fourth location to be excluded from the user work preferences. Valid values are defined in the locationsLOV.
FourthExcludedLocation	String	Fourth location to be excluded from user work preferences.
LengthOfWillingToRelocate	Long	Time duration for the relocation.
RelocationReason	String	Reason for relocation.
Comments	String	Comments of the content item.
ConsiderTemporaryAssignment	String	Indicates whether the person would consider temporary assignment. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
ConsiderTemporaryAssignmentMeaning	String	Represent whether the user is willing to consider temporary assignments.
ConsiderPartTimeWork	String	Indicates whether the person would consider part time work. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
ConsiderPartTimeWorkMeaning	String	Represent whether the user is preferred to as a part time employee.
WorkFlexibleSchedule	String	Indicates whether the person has a flexible work schedule. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
WorkFlexibleScheduleMeaning	String	Represent whether the user is willing to work in a flexible schedule.
MinimumPay	Long	Minimum pay for the work.
CurrencyCode	String	Code of the currency.
Currency	String	Name of the currency.
PayFrequency	String	Frequency for the pay. Valid values are defined in the commonLookupsLOV.
PayFrequencyMeaning	String	Meaning of the pay frequency.
CreatedBy	String	CreatedBy of TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems
CreationDate	Datetime	CreationDate of TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems
LastUpdatedBy	String	LastUpdatedBy of TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems
LastUpdateDate	Datetime	LastUpdateDate of TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems
ProfileId	Long	Surrogate identifier for the person profile.
SectionId	Long	Unique identifier of the content section.
SourceType	String	Code representing the source of work preference item.
Finder	String	Finder of TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems
Group	String	Group of TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems
PersonId	Long	PersonId of TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems
SysEffectiveDate	String	SysEffectiveDate of TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems

ODBC Driver for Oracle Fusion Cloud HCM

TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems

Columns