TalentPersonProfilescareerPreferenceSectionscareerPreferenceItems
TalentPersonProfilescareerPreferenceSectionscareerPreferenceItems
Columns
| Name | Type | Description |
| TalentPersonProfilesProfileId [KEY] | Long | Surrogate identifier for the person profile. |
| CareerpreferencesectionsProfileSectionId [KEY] | Long | Surrogate identifier for the career preference section. |
| CareerPreferenceId [KEY] | Long | Surrogate identifier for the person career preference. |
| NextCareerMove | String | Probable time frame in which the next career move could happen. Valid values are defined in the commonLookupsLOV. |
| PreferredJobFunction | String | Job function preferred by the worker. Valid values are defined in the commonLookupsLOV. |
| PreferredJobFamilyId | Long | Unique identifier of the preferred job family. |
| PreferredJobFamilyCode | String | Job family code of the job family preferred by the worker. Valid values are defined in the jobFamiliesLov. |
| PreferredRegionId | Long | Unique identifier of the preferred region. |
| PreferredRegionCode | String | Location code of the region preferred by the worker. Valid values are defined in the locationsLov. |
| OtherPreferredRegionId | String | Unique identifier of the other preferred region. |
| OtherPreferredRegionCode | String | Location code of the other region preferred by the worker. Valid values are defined in the locationsLov. |
| PreferredJobDescr | String | Description of the preferred job. |
| Comments | String | Comments for the career preference. |
| ShortPeriodAspiration | String | Short term career aspirations of the worker. |
| LongPeriodAspiration | String | Long term career aspirations of the worker. |
| CreatedBy | String | User who created the content item. |
| CreationDate | Datetime | Date and time when the content item was created. |
| LastUpdatedBy | String | Date and time when the content item was last updated. |
| LastUpdateDate | Datetime | User who last updated the content item. |
| NextCareerMoveMeaning | String | Meaning of the next career move. |
| PreferredJobFunctionMeaning | String | Meaning of the job function preferred by worker. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Group | String | Group |
| PersonId | Long | PersonId |
| ProfileId | Long | ProfileId |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |