TalentPersonProfilesaccomplishmentSectionsaccomplishmentItems
TalentPersonProfilesaccomplishmentSectionsaccomplishmentItems
Columns
| Name | Type | Description |
| TalentPersonProfilesProfileId [KEY] | Long | Surrogate identifier for the person profile. |
| AccomplishmentsectionsProfileSectionId [KEY] | Long | Surrogate identifier for the accomplishment section. |
| AccomplishmentId [KEY] | Long | Surrogate identifier for the person accomplishment. |
| Accomplishment | String | Accomplishment of a person. |
| DateAccomplished | Date | Date on which the accomplishment was achieved. |
| Organization | String | Name of the organization. |
| ExpirationDate | Date | Date on which the accomplishment expires. |
| Description | String | Description of the accomplishment. |
| AccomplishmentType | String | Type of accomplishment, such as proficiency or performance. Valid values are defined in the commonLookupsLOV. |
| EstablishmentId | Long | Unique identifier of the establishment. |
| Establishment | String | Name of the establishment. Valid values are defined in the contentItemsLov. |
| OtherEstablishment | String | Name of the other establishment. |
| Comments | String | Comments on the accomplishment. |
| PublisherOrPublication | String | Publisher or publication of the accomplishment. |
| AuthorOrInventor | String | Author or inventor of the accomplishment. |
| PatentOrApplicationNumber | String | Patent or application number associated with the accomplishment. |
| PatentIssued | String | Indicates whether the patent is issued. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
| PatentPending | String | Indicates whether the patent is pending approval. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
| PatentURL | String | URL that directs to the patent. |
| AccomplishmentLocation | String | Location of the accomplishment of a person. |
| PrimaryAuthor | String | Primary author of the accomplishment. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
| 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. |
| AccomplishmentTypeMeaning | String | Meaning of the accomplishment type. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Group | String | Group |
| PersonId | Long | PersonId |
| ProfileId | Long | ProfileId |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |