Power BI Connector for SugarCRM

Build 25.0.9454

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.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454