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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Group | String | Group |
PersonId | Long | PersonId |
ProfileId | Long | ProfileId |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |