ProjectTask
Stores task records that are associated with projects. This table supports task assignment, progress tracking, and project activity management.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The list of team names that are associated with this project task. This value is used for access control, collaboration, and visibility filtering. |
| Acl_Team_Set_Id | String | False |
The identifier (Id) of the set of teams that have access to this project task. This value is used to manage shared ownership and permissions. |
| Actual_Duration | Int | True |
The total amount of time that has already elapsed while working on this project task, measured in the unit specified by the Duration_Unit field. |
| Actual_Effort | Int | True |
The amount of effort that has already been spent on this project task, typically measured in person-hours. This value supports progress and workload evaluation. |
| Assigned_User_Id | String | False |
The Id of the user who is responsible for this project task. This assignment determines ownership and workflow accountability. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to this project task. This value is shown in the user interface for clarity and reporting. |
| Created_By | String | True |
The Id of the user who created this project task record. This value identifies the record author for auditing and lifecycle tracking. |
| Created_By_Name | String | True |
The display name of the user who created this project task record. This value provides readability when reviewing task authorship. |
| Date_Due | Date | False |
The date by which this project task is expected to be completed. This value supports scheduling and deadline tracking. |
| Date_Entered | Datetime | True |
The date and time when this project task record was created. This value provides timeline context for project planning and review. |
| Date_Finish | Date | False |
The date when this project task was actually completed. This value supports performance and timeline variance analysis. |
| Date_Modified | Datetime | True |
The date and time when this project task record was most recently updated. This field helps track ongoing changes and record maintenance. |
| Date_Start | Date | False |
The date when work on this project task is planned to begin. This value supports schedule coordination and resource planning. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this project task record is marked as deleted. It returns a value of 'false' when the record is active and available for use. |
| Description | String | False |
A detailed description of the project task. This field can include instructions, scope details, or contextual information needed to complete the task. |
| Duration | Int | False |
The planned duration for this project task, measured in the unit defined by the Duration_Unit field. This value supports schedule forecasting and work planning. |
| Duration_Unit | String | False |
The time unit that is used to express the Duration and Actual_Duration values (for example, 'minutes', 'hours', or 'days'). This ensures consistent interpretation of work length. |
| Estimated_Effort | Int | True |
The projected amount of effort required to complete this project task, typically measured in person-hours. This value supports resource planning and project estimation. |
| Id [KEY] | String | True |
The unique identifier (Id) for this project task record. This value is used to reference the task across the system and related modules. |
| Milestone_Flag | Bool | False |
A Boolean field that returns a value of 'true' when this project task represents a milestone. It returns a value of 'false' when the task is a standard task in the project timeline. |
| Modified_By_Name | String | True |
The display name of the user who most recently modified this project task record. This field supports audit visibility and version awareness. |
| Modified_User_Id | String | True |
The Id of the user who most recently updated this project task record. This value identifies the source of change activity. |
| Name | String | False |
The name of the project task. This value is used as the primary label throughout the system. |
| Order_Number | Int | True |
The position of this task within the task list or project sequence. This value influences task display and workflow ordering. |
| Parent_Task_Id | Int | True |
The Id of the parent task, if this task is part of a task hierarchy. This relationship supports structured work breakdowns. |
| Percent_Complete | Int | True |
The percentage of work that has been completed for this project task. This value supports progress tracking and reporting. |
| Predecessors | String | False |
The list of task Ids that must be completed before this task can begin. This field supports dependency and timeline management. |
| Priority | String | False |
The priority level that is assigned to this project task. This value indicates the urgency of the work relative to other tasks. |
| Project_Id | String | False |
The Id of the project that this task belongs to. This value establishes the connection between the task and its parent project. |
| Project_Name | String | True |
The display name of the project that this task belongs to. This value is shown for readability and reporting. |
| Project_Task_Id | Int | True |
A numeric sequence value that uniquely distinguishes this task within the project task list. This value is often used for internal referencing and ordering. |
| Resource_Id | String | False |
The Id of the resource that is assigned to work on this task. A resource can be a user or another type of project workload entity. |
| Resource_Name | String | False |
The display name of the resource that is assigned to this task. This value improves readability in reports and planning tools. |
| Status | String | False |
The current status of this project task. This value indicates whether the task is planned, in progress, completed, or on hold. |
| Task_Number | Int | True |
A numbering value that identifies the task within the project's structured task sequence. This value can reflect hierarchical task planning. |
| Team_Count | String | False |
The number of teams that are associated with this project task. This value helps determine collaboration scope and access control. |
| Team_Id | String | False |
The Id of the primary team responsible for this project task. This value establishes core ownership for permissions and visibility. |
| Team_Name | String | False |
The display name of the primary team that is associated with this project task. This value is used for readability and reporting. |
| Team_Set_Id | String | False |
The Id of the set of teams that share access to this project task. This value supports multi-team collaboration and permission configuration. |
| Time_Due | String | True |
The time by which the task is expected to be completed on the Date_Due date. This value provides finer-grained scheduling detail. |
| Time_Finish | Int | True |
The actual time when work on this task was completed, typically stored as a system-calculated time value. This value supports timeline performance comparison. |
| Time_Start | Int | True |
The actual time when work on this task began, typically stored as a system-calculated time value. This value supports audit tracking and schedule accuracy. |
| Utilization | Int | True |
The percentage of the assigned resource's available capacity that is allocated to this project task. This value supports workload balancing and capacity planning. |