ProjectPlanTasks Table

Applies to QAComplete 14.3, last modified on February 19, 2024

Description

Stores the tasks related to project plans.

Columns

The table contains the following columns:

TaskId  :  int, primary key, allows null: no

The unique numeric identifier of the item.

ProjPlanId  :  int, allows null: no

The ID of the project plan where the task resides.

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.

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

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

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.

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.

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

The column is not used.

LinkedItemId  :  int, allows null: yes

The column is not used.

OriginalId  :  int, allows null: yes

The column is reserved for system use only.

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 Validation table. They correspond to the items whose values equal ProjectPlanTaskPriority in the ValidationType column.

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.

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.

See Also

ProjectPlanTasks View
Project Management

Highlight search results