Description
Contains detailed information on project plans.
Dependencies
Columns
ActCostExternal : money, allows null: no
The actual external cost of work on all the tasks of the project plan.
ActCostInternal : money, allows null: no
The actual internal cost of work on all the tasks of the project plan.
ActHrs : decimal (max 38 digits, including up to 3 digits after the decimal point), allows null: no
The sum of the actual number of hours spent on all the project plan tasks.
ActPctComplete : int, allows null: yes
The percentage of project plan completion based on the values of child tasks.
AssignedToName : varchar (max 78 chars), allows null: yes
The name of the user to whom the associated item is assigned, in the Last name, First name format.
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 Text Feature.
Custom11..Custom90 : varchar (max 100 chars), allows null: yes
The values of custom fields 11 through 90.
DateActFinish : datetime, allows null: yes
The date when the work on the project plan actually completed. The actual date of plan completion will be the completion date of the last task of this plan.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
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.
DeptId : int, allows null: no
The ID of the department that owns the project plan.
EstCostExternal : money, allows null: no
The estimated external cost of work on all the tasks of the project plan.
EstCostInternal : money, allows null: no
The estimated internal cost of work on all the tasks of the project plan.
EstHrs : decimal (max 38 digits, including up to 3 digits after the decimal point), allows null: no
The sum of the estimated number of hours spent on all the project plan tasks.
EstHrsRemaining : decimal (max 38 digits, including up to 3 digits after the decimal point), allows null: no
The total number of estimated hours remaining to complete work on the project plan tasks.
EstPctComplete : int, allows null: yes
The estimated percentage of project plan completion based on the values of child tasks.
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.
NbrEvents : int, allows null: yes
The number of events attached to the associated item.
NbrFiles : int, allows null: yes
The number of files attached to the associated item.
NbrNotes : int, allows null: yes
The number of notes attached to the associated item.
NotesDescription : varchar (max), allows null: yes
An alias for the LatestNotes column of the ExtendedAttributes table.
A description of the latest note attached to the associated item.
OwnerUserId : int, allows null: no
The ID of the user who created the item.
OwnerUserName : varchar (max 78 chars), allows null: yes
An alias for the OwnerName column of the ExtendedAttributes table.
The name of the user who owns the associated item, in the Last name, First name format.
ProjId : int, allows null: no
The ID of the project that contains 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 Validations Table 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.
UserName : varchar (max 78 chars), allows null: yes
The name of the user who last updated the associated item, in the Last name, First name format.