TalentPersonProfilescertificationSectionscertificationItems

Columns


Name	Type	Description
TalentPersonProfilesProfileId [KEY]	Long	TalentPersonProfilesProfileId of TalentPersonProfilescertificationSectionscertificationItems
CertificationsectionsProfileSectionId [KEY]	Long	CertificationsectionsProfileSectionId of TalentPersonProfilescertificationSectionscertificationItems
CertificationId [KEY]	Long	CertificationId of TalentPersonProfilescertificationSectionscertificationItems
ContentItemId	Long	Unique identifier for the content item.
LicenseOrCertificate	String	Name of the license or certificate, such as Certified Accountant. Valid values are defined in the contentItemsLov.
OtherLicenseOrCertificate	String	Name of other license or certification, such as Certified Accountant.
Country	String	Country where certification was issued. Valid values are defined in the hcmCountriesLOV.
CountryMeaning	String	CountryMeaning of TalentPersonProfilescertificationSectionscertificationItems
State	String	State where the certification was issued. Valid values are defined in the hcmAddressesLOV.
IssuedBy	String	Issuing authority of the license or certification.
CertificateNumber	String	Number of the certification.
IssueDate	Date	Date when the certification is issued.
OriginalIssueYear	Long	Original year in which the license or certificate was issued.
ExpirationDate	Date	Date when the certification expires.
Title	String	Title of the certification.
RenewalDate	Date	Renewal date of the certification.
LastRenewalDate	Date	Last renewal date of the certification.
RenewalInprogress	String	Indicates whether the renewal of the license or certification is in progress. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
RenewalRequired	String	Indicates whether the license or certification requires renewing. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
ActualCompletionDate	Date	Date on which the license or certification was obtained.
Status	String	Status of the certification. Valid values are defined in the commonLookupsLOV.
Verified	String	Indicates whether the license or certification is verified. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
Comments	String	Comments on the certification.
EstablishmentId	Long	Unique identifier of the educational establishment.
Establishment	String	Name of the establishment. Valid values are defined in the contentItemsLov.
OtherEstablishment	String	Name of the educational establishment.
TrainingCompletedUnits	String	Completed training units of the certification.
Restrictions	String	Restrictions on renewal of the certification.
TotalAmount	Long	Total cost of the certification.
CompletedAmount	Long	Completed amount of the certification.
CertificationURL	String	URL linked to the certification.
CreatedBy	String	CreatedBy of TalentPersonProfilescertificationSectionscertificationItems
CreationDate	Datetime	CreationDate of TalentPersonProfilescertificationSectionscertificationItems
LastUpdatedBy	String	LastUpdatedBy of TalentPersonProfilescertificationSectionscertificationItems
LastUpdateDate	Datetime	LastUpdateDate of TalentPersonProfilescertificationSectionscertificationItems
ProfileId	Long	Surrogate identifier for the person profile.
SectionId	Long	Unique identifier of the content section.
StatusMeaning	String	Meaning of status of the certification.
Source	String	Source of TalentPersonProfilescertificationSectionscertificationItems
RenewalInprogressMeaning	String	Meaning of renewalInProgress of the certification.
VerifiedMeaning	String	Meaning of Verified flag of the certification.
RenewalRequiredMeaning	String	Meaning of RenewalRequired of the certification.
SourceType	String	Code representing the source of certification item.
RelatedItemFlag	Bool	Attribute specific to learning outcome. Indicates whether the certification item doesn't need to be copied to the learner's talent profiles after completion of the course or specialization. Valid values are Y and N.
ExternalPartyVerifyBy	String	ExternalPartyVerifyBy of TalentPersonProfilescertificationSectionscertificationItems
ExternalPartyVerifyDate	Date	ExternalPartyVerifyDate of TalentPersonProfilescertificationSectionscertificationItems
Finder	String	Finder of TalentPersonProfilescertificationSectionscertificationItems
Group	String	Group of TalentPersonProfilescertificationSectionscertificationItems
PersonId	Long	PersonId of TalentPersonProfilescertificationSectionscertificationItems
SysEffectiveDate	String	SysEffectiveDate of TalentPersonProfilescertificationSectionscertificationItems

JDBC Driver for Oracle Fusion Cloud HCM

TalentPersonProfilescertificationSectionscertificationItems

Columns