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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Group | String | Group |
| PersonId | Long | PersonId |
| ProfileId | Long | ProfileId |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |