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 |