ProjectPlans View

Applies to QAComplete 12.75 SaaS, last modified on April 01, 2021

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.

See Also

ProjectPlans Table
Project Management

Highlight search results