ODBC Driver for Oracle Fusion Cloud HCM

Build 23.0.8839

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839