Project
Stores project records representing structured work initiatives. This table supports project planning, resource scheduling, and execution oversight.
Columns
| Name | Type | ReadOnly | Description |
| Acl_Team_Names | String | True |
The list of team names that are associated with this project. 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. This value is used to manage multi-team ownership and permissions. |
| Assigned_User_Id | String | False |
The Id of the user who is responsible for managing or completing work on this project. This assignment determines ownership and workflow accountability. |
| Assigned_User_Name | String | True |
The display name of the user who is assigned to this project. 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 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 record. This field provides readability when reviewing project authorship. |
| Date_Entered | Datetime | True |
The date and time when this project record was created. This value provides timeline context for project planning and review. |
| Date_Modified | Datetime | True |
The date and time when this project record was most recently updated. This field helps track ongoing changes and record maintenance. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this project 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. This field can include scope details, objectives, background context, or collaboration notes. |
| Estimated_End_Date | Date | False |
The planned end date for the project. This value supports project scheduling, forecasting, and timeline management. |
| Estimated_Start_Date | Date | False |
The planned start date for the project. This value indicates when work is expected to begin. |
| Id [KEY] | String | True |
The unique Id for this project record. This value is used to reference the project across the system and related modules. |
| Is_Template | Bool | False |
A Boolean field that returns a value of 'true' when this project is designated as a reusable template. It returns a value of 'false' when the project is a unique instance. |
| Modified_By_Name | String | True |
The display name of the user who most recently modified this project 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 record. This value identifies the source of change activity. |
| Name | String | False |
The name of the project. This value is used as the primary label throughout the system. |
| Priority | String | False |
The priority level that is assigned to this project. This value helps determine scheduling order and resource allocation. |
| Status | String | False |
The current status of the project. This value indicates whether the project is planned, in progress, completed, or on hold. |
| Team_Count | String | False |
The number of teams that are associated with this project. This value helps determine the scale of collaboration and access control. |
| Team_Id | String | False |
The Id of the primary team responsible for this project. 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. 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. This value supports multi-team collaboration and permission configuration. |
| Total_Actual_Effort | Int | True |
The amount of time that has already been spent working on this project, typically measured in person-hours. This value helps evaluate progress and cost. |
| Total_Estimated_Effort | Int | True |
The projected amount of work that is expected to be required to complete this project, typically measured in person-hours. This value supports planning and budgeting. |