TaskCosts Table

Applies to QAComplete 12.70 SaaS, last modified on January 11, 2021

Description

Contains the costs associated with agile tasks.

Columns

The table contains the following columns:

TaskCostId  :  int, primary key, allows null: no

The unique numeric identifier of the item.

ActualCost  :  money, allows null: yes

The actual cost of the work on the item.

ActualHrs  :  decimal (max 18 decimal digits), allows null: yes

The actual time worked on the item, in hours.

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

The date and time when 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 when 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 1000 chars), allows null: no

The title of the associated agile task.

This column corresponds to a field that can be available for rich editing.

EstCost  :  money, allows null: no

The estimated cost of the work on the item.

EstHrs  :  decimal (max 18 decimal digits), allows null: no

The estimated time the task will take, in hours.

ReferenceNbr  :  varchar (max 30 chars), allows null: no

The column is reserved for system use only.

TaskId  :  int, allows null: no

The numeric identifier of the related agile task.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

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

This column is not used.

See Also

Tasks View
Tasks Table
Agile Tasks

Highlight search results