ProjectPlanTasks View

Applies to QAComplete 12.93 SaaS, last modified on November 01, 2021

Description

Contains detailed information on project plan task.

Dependencies

Columns

ActCostExt  :  money, allows null: yes

The actual external cost of work on the task.

ActCostInt  :  money, allows null: yes

The actual internal cost of work on the task.

ActFinish  :  datetime, allows null: yes

The date when the work on the project plan task actually completed.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

ActHrs  :  decimal (max 18 decimal digits), allows null: yes, default: 0

The actual number of hours spent on the project plan task.

ActStart  :  datetime, allows null: yes

The date when the work on the project plan task actually started.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

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 task 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.

DateCreated  :  datetime, allows null: no, default: Current date and time

The date and time the item 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 the item was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

Description  :  varchar (max 8000 chars), allows null: yes

The description of the project plan task.

This column corresponds to a field that can be available for Rich Text Feature.

EstCostExt  :  money, allows null: yes

The estimated external cost of work on the task.

EstCostInt  :  money, allows null: yes

The estimated internal cost of work on the task.

EstFinish  :  datetime, allows null: yes

The date and time the work on the project plan task is estimated to finish.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

EstHrs  :  decimal (max 18 decimal digits), allows null: yes, default: 0

The estimated time the project plan task will take to complete, in hours.

EstHrsRemaining  :  decimal (max 18 decimal digits), allows null: yes, default: 0

The estimated number of hours remaining to complete work on the project plan task.

EstStart  :  datetime, allows null: yes

The date and time the work on the project plan task is estimated to start.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

FunctSpecId  :  int, allows null: yes

This column is not used.

ImportId  :  int, allows null: yes

The column is reserved for system use only.

Indent  :  int, allows null: yes, default: 0

The indentation level of the task.

IsActive  :  char (max 1 char), allows null: no, default: Y

Indicates whether the plan is active.

IsBillable  :  varchar (max 1 char), allows null: no, default: Y

Indicates whether the project plan task is billable.

IsEstFinishOverriden  :  varchar (max 1 char), allows null: yes

Indicates whether the estimated finish date is overridden. By default, the estimated finish date is based on the estimated finish dates of the child tasks.

IsExpanded  :  varchar (max 1 char), allows null: yes, default: N

Indicates whether the task is expanded for viewing.

IsParent  :  varchar (max 1 char), allows null: yes, default: N

Indicates whether the task is a parent.

LinkedItem  :  varchar (max 149 chars), allows null: yes

The linked defect, test case or requirement, in the “<Entity Code> <Item Id> - <Item title>” format.

LinkedItemCode  :  varchar (max 100 chars), allows null: yes

The column is not used.

LinkedItemId  :  int, allows null: yes

The column is not used.

LinkedItemTitle  :  varchar (max 100 chars), allows null: yes

The title of the linked defect, test case, or requirement.

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.

OriginalId  :  int, allows null: yes

The column is reserved for system use only.

OwnerName  :  varchar (max 78 chars), allows null: yes

The name of the user who owns the related project plan.

OwnerUserId  :  int, allows null: no

The ID of the user who created the item.

PctComplete  :  tinyint, allows null: yes, default: 0

The percentage of project plan task 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.

PredNum  :  varchar (max 50 chars), allows null: yes

The ID of the project plan task that should be completed before this one.

PriorityCode  :  varchar (max 100 chars), allows null: yes

The priority of the project plan task 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 ProjectPlanTaskPriority in the ValidationType column.

ProjId  :  int, allows null: no

The ID of the project that contains the item.

ProjPlanId  :  int, allows null: no

The ID of the project plan where the task resides.

ProjPlanName  :  varchar (max 50 chars), allows null: no

The name of the project plan.

RequestedBy  :  varchar (max 30 chars), allows null: yes

The name of the user who requested the item, in the Last name, First name format.

SeqNum  :  int, allows null: no

The ordinal number of the task in the project plan.

TaskId  :  int, allows null: no

The unique numeric identifier of the item.

TaskName  :  varchar (max 100 chars), allows null: no

The name of the project plan task.

UpdateUserId  :  int, allows null: no, default: 0

The ID of the user who last updated the project plan task.

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

ProjectPlanTasks Table
Project Management

Highlight search results