TalentPersonProfilespublicSkillsendorsements
TalentPersonProfilespublicSkillsendorsements
Columns
Name | Type | Description |
TalentPersonProfilesProfileId [KEY] | Long | Surrogate identifier for the person profile. |
PublicskillsSkillId [KEY] | Long | Unique identifier for the public skill. |
EndorsementId [KEY] | Long | Unique identifier for the endorsement. |
RequestorPersonId | Long | Unique identifier of the person who has requested the endorsement. |
EndorserId | Long | Unique identifier of the endorser. |
Status | String | Status of the endorsement. Values can be ORA_COMPLETED or ORA_PENDING or ORA_IGNORE. Valid values are defined in the commonLookupsLOV. |
RequestedDate | Datetime | Date and time when the endorsement was created. |
ProficiencyLevelId | Long | Unique identifier of the proficiency level of the skill. |
ProficiencyLevelCode | String | Code representing the proficiency level of the skill. |
NumericRating | Double | Numeric rating of the skill. |
CreatedBy | String | User who created the endorsement. |
CreationDate | Datetime | Date and time when the endorsement was created. |
LastUpdatedBy | String | User who last updated the endorsement. |
LastUpdateDate | Datetime | Date and time when the endorsement 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 |