ProjectPlans Table

Applies to QAComplete 12.84 SaaS, last modified on July 19, 2021

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.

See Also

ProjectPlans View
ProjectPlanTasks Table
Project Management

Highlight search results