TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems
TalentPersonProfilesworkPreferenceSectionsworkPreferenceItems
Columns
Name | Type | Description |
TalentPersonProfilesProfileId [KEY] | Long | Surrogate identifier for the person profile. |
WorkpreferencesectionsProfileSectionId [KEY] | Long | Surrogate identifier for the work preference section. |
WorkPreferenceId [KEY] | Long | Unique identifier for work preference. |
TravelDomestically | String | Indicates whether the worker prefers domestic travel. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
DomesticTravelFrequency | String | Frequency of domestic travel. Valid values are defined in the commonLookupsLOV. |
TravelInternationally | String | Indicates whether the worker prefers international travel. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
InternationalTravelFrequency | String | Frequency of international travel. Valid values are defined in the commonLookupsLOV. |
WillingToRelocate | String | Indicates whether the person is willing to relocate. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
ConsiderPartTimeWork | String | Indicates whether the person would consider part time work. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
WorkFlexibleSchedule | String | Indicates whether the person has a flexible work schedule. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
MinimumPay | Long | Minimum pay for the work. |
CurrencyCode | String | Code of the currency. |
PayFrequency | String | Frequency for the pay. Valid values are defined in the commonLookupsLOV. |
CreatedBy | String | User who created the work preference item. |
CreationDate | Datetime | Date and time when the work preference item was created. |
LastUpdatedBy | String | User who last updated the work preference item. |
LastUpdateDate | Datetime | Date and time when the work preference item was last update. |
PayFrequencyMeaning | String | Meaning of the pay frequency. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Group | String | Group |
PersonId | Long | PersonId |
ProfileId | Long | ProfileId |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |