TalentPersonProfileslanguageSectionslanguageItems
TalentPersonProfileslanguageSectionslanguageItems
Columns
Name | Type | Description |
TalentPersonProfilesProfileId [KEY] | Long | Surrogate identifier for the person profile. |
LanguagesectionsProfileSectionId [KEY] | Long | Surrogate identifier for the language section. |
LanguageId [KEY] | Long | Unique identifier for the language item. |
ContentItemId | Long | Unique identifier for the content item. |
Language | String | Name of the language. Valid values are defined in the contentItemsLOV. |
OtherLanguage | String | Name of the other language. It's free flow text. |
WritingLevelId | Long | Unique identifier for the writing level. |
WritingLevelCode | String | Level of writing the language. Valid values derived from ratingLevelsLOV. |
WritingLevelDescription | String | Description of the writing level of the language. |
SpeakingLevelId | Long | Unique identifier for the speaking level. |
SpeakingLevelCode | String | Level of speaking the language. Valid values derived from ratingLevelsLOV. |
SpeakingLevelDescription | String | Description of the speaking level of the language. |
ReadingLevelId | Long | Unique identifier for the reading level. |
ReadingLevelCode | String | Level of reading the language. Valid values derived from ratingLevelsLOV. |
ReadingLevelDescription | String | Description of the reading level of the language. |
NativeSpeaker | String | Indicates whether the language is the native language of the person. Valid values derived from commonLookupsLOV. |
AbleToTranslate | String | Indicates whether the person can translate the language. Valid values derived from commonLookupsLOV. |
AbleToTeach | String | Indicates whether the person can teach the language. Valid values derived from commonLookupsLOV. |
EvaluatedOn | Date | Date and time of the evaluation. |
EvaluationLocation | String | Location of the evaluation. |
Comments | String | Comments of the language content item. |
CreatedBy | String | User who created the language item. |
CreationDate | Datetime | Date and time when the language item was created. |
LastUpdatedBy | String | User who last updated the language item. |
LastUpdateDate | Datetime | Date and time when the language item was last updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Group | String | Group |
PersonId | Long | PersonId |
ProfileId | Long | ProfileId |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |