Description
Stores the project plans of all the projects.
Columns
The table contains the following columns:
DeptId : int, allows null: no
The ID of the department that owns the project plan.
ProjId : int, allows null: no
The ID of the project that contains the item.
ActPctComplete : tinyint, allows null: yes
The actual percentage of project plan completion.
QAComplete calculates this value automatically when the user specifies how many hours have been spent on that task. To learn more, see Calculation of Percent Complete and Estimated Hours Remaining.
AssigneeUserId : int, allows null: yes
The ID of the user to whom the project plan is assigned.
Custom1..Custom10 : varchar (max 8000 chars), allows null: yes
The values of custom fields 1 - 10.
These columns correspond to fields that can be available for rich editing.
DateBurndownEnd : datetime, allows null: yes
Burndown end date.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateBurndownStart : datetime, allows null: yes
Burndown start date.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateCreated : datetime, allows null: no, default: Current date and time
The date and time when the project plan was created.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateUpdated : datetime, allows null: no, default: Current date and time
The date and time when the project plan was last updated.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
ImportId : int, allows null: yes
The column is reserved for system use only.
IsActive : char (max 1 char), allows null: no, default: Y
Indicates whether the plan is active.
IsAutoAdjustBurndown : varchar (max 1 char), allows null: yes
Indicates whether burndown dates are set automatically.
OwnerUserId : int, allows null: no
The ID of the user who created the item.
ProjPlanId : int, allows null: no
The unique numeric identifier of the project plan.
ProjPlanName : varchar (max 50 chars), allows null: no
The name of the project plan.
StatusCode : varchar (max 30 chars), allows null: yes
The status of the project plan based on the choice list. The values of this choice list are stored in the Validation table. They correspond to the items whose values equal ProjPlanStatus in the ValidationType column.
UpdateUserId : int, allows null: no
The ID of the user who last updated the item.