TalentPersonProfilesspecialProjectSectionsspecialProjectItems
TalentPersonProfilesspecialProjectSectionsspecialProjectItems
Columns
| Name | Type | Description |
| TalentPersonProfilesProfileId [KEY] | Long | Surrogate identifier for the person profile. |
| SpecialprojectsectionsProfileSectionId [KEY] | Long | Surrogate identifier for the special project section. |
| ProjectId [KEY] | Long | Identifier for the project. |
| ContentItemId | Long | Unique identifier for the content item. |
| ProjectName | String | Name of the special project. Valid values are defined in the contentItemsLOV. |
| OtherProjectName | String | Name of the other special project. |
| Role | String | Role in the previous project. |
| StartDate | Date | Date when project starts. |
| CompletionDate | Date | Date when project is completed. |
| Description | String | Description of the special project item. |
| Employer | String | Name of the employer. |
| ContactPersonId | Long | Unique identifier of the contact provided on the special project. |
| ContactPersonNumber | String | Number for the contact person provided on the special project. |
| Contact | String | Contact provided on the special project. |
| BusinessUnit | String | Name of the business unit. |
| Manager | String | Name of the project manager. |
| Category | String | Category of the special project. |
| CustomerName | String | Name of the customer. |
| Billable | String | Indicates whether the special project is billable. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
| Comments | String | Comments on the project. |
| ProjectURL | String | URL linked to the project. |
| CreatedBy | String | User who created the special project item. |
| CreationDate | Datetime | Date and time when the special project item was created. |
| LastUpdatedBy | String | User who last updated the special project item. |
| LastUpdateDate | Datetime | Date and time when the special project item was last updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Group | String | Group |
| PersonId | Long | PersonId |
| ProfileId | Long | ProfileId |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |