ProjectsUsersProjectTasks
The project task resource is used to store values while creating or updating project tasks. A task is a unit of project work assigned or performed as part of a resource's duties. Tasks may be a portion of project work to be performed within a defined period by a specific resource or multiple resources.
Columns
| Name | Type | Description |
| ProjectsUsersResourceId [KEY] | Long | The unique identifier of the resource assigned to the task. |
| ElementVersionId | Long | Element version identifier of the task. |
| ExecutionDisplaySequence | Long | Display sequence of the task in the project |
| ElementType | String | Element Type of a task. |
| FinancialParentTaskName | String | The name of the lowest level financial parent task. |
| FinancialParentTaskId | Long | Unique identifer of the lowest financail parent task. |
| FinancialParentTaskNumber | String | The number of the lowest level financial parent task. |
| MilestoneFlag | Bool | Text that indicates that a particular task is a milestone in the Team Member Dashboard and in Task Management. |
| ObjectType | String | Object type of the task. |
| ParentTaskName | String | The name of the task that will be the parent of the new task. |
| ParentTaskNumber | String | The number of the parent task. If the task is a top task, the parent task number is null. |
| PlanVersionId | Long | Plan version identifier of the proejct task. |
| ProjectStatusCode | String | Code corresponding to the label to display the status of the project. |
| PlanLineId [KEY] | Long | Unique identifier of the plan line of the task. |
| ProjectSystemStatusCode | String | Code of the system status corresponding status of the project. |
| ProjectStatusName | String | Label to display the status of the project. |
| ProjectName | String | Name of the project to which task is associated |
| ProjElementId [KEY] | Long | Project Element Identifier of the task |
| ProjectId | Long | Identifier of the project to which task is associated |
| TaskId | Long | Unique identifier of the task. |
| TaskActualFinishDate | Date | The date on which the work completed on a task |
| TaskActualStartDate | Date | The date on which the work commenced on a task. |
| TaskName | String | The name of the task. |
| TaskActualQuantity | Decimal | The number of hours that the project team member reports working on the task. |
| TaskCurrentActualQuantity | Decimal | Current estimated effort to complete the task. |
| TaskCurrentFinishDate | Date | The date when the task is estimated to end. |
| TaskCurrentStartDate | Date | The date when the task is estimated to start. |
| TaskExceptions | String | The exceptions generated by the progress entry for the task. |
| TaskPlannedFinishDate | Date | Date on which a task is intended to finish. |
| TaskPlannedStartDate | Date | Date on which a task is intended to begin. |
| TaskPriority | Decimal | Priority of the task. |
| TaskPercentComplete | Decimal | The percent of work complete for a particular task. |
| TaskDescription | String | Description of a task. |
| TaskProposedFinishDate | Date | The date that the task is expected to finish on. |
| TaskProposedStartDate | Date | The date that the task is expected to start on. |
| TaskProgressStatus | String | Progress Status of the task. |
| TaskQuantity | Decimal | The number of hours that a resource is assigned to work on a task |
| TaskProposedQuantity | Decimal | The total number of hours estimated to take a particular persoon to complete a particular task. |
| TaskRemainingQuantity | Decimal | The hours the project team member has left to complete the task. |
| TaskResourceAllocationPercent | Decimal | Percentage of time that all resources assigned to the task are planned to work on the task. |
| TaskLevel | Int | Indicates level of the task in the project work plan. |
| TaskProgressStatusCode | String | Code of the progress status of the task. |
| TaskPrimaryResourceId | Long | Identifier of the primary resource assigned to the task. |
| TaskProgressEnteredDate | Date | The date when last progress was entered. |
| TopTaskId | Long | Identifer of the top task to which the task rolls up.if the task is a top task, the number of the top task is same as the number of the task. |
| TopTaskName | String | The name of the top task to which the task rolls up. if the task is a top task, the name of the top task is same as the number of the task. |
| TopTaskNumber | String | The number of the top task to which the task rolls up. if the task is a top task, the number of the top task is same as the number of the task. |
| LastUpdatedBy | String | Unique identifier of the user who last updated the task. |
| LastUpdateDate | Datetime | The date when the task is last updated. |
| CreatedBy | String | Unique identifier of the user who created the task. |
| CreationDate | Datetime | The date when the task is created. |
| OsnSharedTaskFlag | Bool | Indicates whether a task is shared on OSN. If the value is true, then the task is shared. The default value is false. |
| Finder | String | finder |
| ResourceId | Long | resourceid |