TalentPersonProfilescompetencySectionscompetencyItems
TalentPersonProfilescompetencySectionscompetencyItems
Columns
| Name | Type | Description |
| TalentPersonProfilesProfileId [KEY] | Long | Surrogate identifier for the person profile. |
| CompetencysectionsProfileSectionId [KEY] | Long | Surrogate identifier for the language section. |
| CompetencyId [KEY] | Long | Unique identifier for the content type. |
| ContentItemId | Long | Unique identifier for the content section. |
| Competency | String | Name of the competency. Valid values are defined in the contentItemsLOV. |
| OtherCompetency | String | Name of the other competency. It's free text. |
| ReviewDate | Date | Date of review of the competency. |
| ProficiencyRatingId | Long | Unique identifier of the proficiency rating. |
| ProficiencyRatingCode | String | Name of the proficiency rating. Valid values are defined in the ratingLevelsLOV. |
| ProficiencyRatingDescription | String | Description of the proficiency rating. |
| PerformanceRatingId | Long | Unique identifier of the performance rating. |
| PerformanceRatingCode | String | Name of the performance rating. Valid values are defined in the ratingLevelsLOV. |
| PerformanceRatingDescription | String | Description of the performance rating. |
| YearsOfExperience | Double | Years of experience for the competency. |
| InterestLevel | String | Level of interest in the competency. |
| EvaluationType | String | Evaluator of the competency, such as Official, Goal. Valid values are defined in the commonLookupsLOV. |
| ReviewerName | String | Start date of the review. |
| Reviewer | String | Indicates whether the reviewer has approved the competency. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
| YearAcquired | Long | Year the competency was acquired. |
| YearLastUsed | Long | Year the competency was last used. |
| ReviewerApproved | String | Name of the reviewer. |
| ReviewStartDate | Date | Name of the reviewer. It's free flow text. |
| ReviewEndDate | Date | End date of the review. |
| AssessmentYear | Long | Year the competency was last assessed. |
| EvaluationComments | String | Comments on the evaluation. |
| Comments | String | General comments on the competency. |
| ReviewActive | String | Indicates whether the review of the competency is active or not. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
| Description | String | Description of the competency. |
| FromDate | Date | Start date of the competency. |
| ToDate | Date | End date of the competency. |
| CreatedBy | String | User who created the competency item. |
| CreationDate | Datetime | Date and time when the competency item was created. |
| LastUpdatedBy | String | User who last updated the competency item. |
| LastUpdateDate | Datetime | Date and time when the competency 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 |