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 |