TalentPersonProfilescertificationSectionscertificationItems
TalentPersonProfilescertificationSectionscertificationItems
Columns
Name | Type | Description |
TalentPersonProfilesProfileId [KEY] | Long | Surrogate identifier for the person profile. |
CertificationsectionsProfileSectionId [KEY] | Long | Surrogate identifier for the certification section. |
CertificationId [KEY] | Long | Unique identifier of the certification. |
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 | Meaning of the country. |
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 | User who created the content item. |
CreationDate | Datetime | Date and time when the content item was created. |
LastUpdatedBy | String | User who last updated the content item. |
LastUpdateDate | Datetime | Date and time when the content item was last updated. |
StatusMeaning | String | Meaning of status of the certification. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Group | String | Group |
PersonId | Long | PersonId |
ProfileId | Long | ProfileId |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |