TalentPersonProfileshonorSectionshonorItems
TalentPersonProfileshonorSectionshonorItems
Columns
| Name | Type | Description |
| TalentPersonProfilesProfileId [KEY] | Long | Surrogate identifier for the person profile. |
| HonorsectionsProfileSectionId [KEY] | Long | Surrogate identifier for the honor section. |
| HonorId [KEY] | Long | Unique identifier for the honor. |
| ContentItemId | Long | Unique identifier for the content item. |
| HonorOrAward | String | Name of the honor or award. Valid values are defined in the contentItemsLOV. |
| OtherHonorOrAward | String | Name of the other honor or award. |
| AwardDate | Date | Date on which the honor or award was awarded. |
| Organization | String | Name of the organization that issued the honor or award. |
| IssueYear | Long | Year in which the honor or award was issued. |
| CompletionDate | Date | Date on which the honor or award was completed. |
| ExpirationDate | Date | Date on which the honor or award expires. |
| Description | String | Description of the honor item. |
| TypeOfAward | String | Type of honor or award. Valid values are defined in the commonLookupsLOV. |
| EstablishmentId | Long | Unique identifier for the educational establishment. |
| Establishment | String | Name of the establishment. Valid values are defined in the contentItemsLov. |
| OtherEstablishment | String | Other educational establishment. |
| Comments | String | Comments of the content item. |
| Title | String | Title of the honor or award. |
| Grantor | String | Granting authority that awarded the honor or award. |
| HonorURL | String | URL related to the honor or award. |
| CreatedBy | String | User who created the honor item. |
| CreationDate | Datetime | Date and time when the honor item was created. |
| LastUpdatedBy | String | User who last updated the honor item. |
| LastUpdateDate | Datetime | Date and time when the honor item was last updated. |
| TypeOfAwardMeaning | String | Meaning of the type of honor or award. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Group | String | Group |
| PersonId | Long | PersonId |
| ProfileId | Long | ProfileId |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |