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 |