TaskTemplateItems Table

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

Description

The table stores task template items.

Columns

The table contains the following columns:

TaskTemplateItemId  :  int, primary key, allows null: no

The unique identifier of the task template item.

TaskTemplateId  :  int, allows null: no

The ID of the task template that contains the item.

DateCreated  :  datetime, allows null: no

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

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.

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

The estimated time of work on the task template item, in hours.

Predecessor  :  int, allows null: yes

The ID of the task template item that should be finished before this one.

Seq  :  int, allows null: no

The ordinal number of the task in the task template.

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

The name of the task template item.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

TaskTemplateItems View
Project Management

Highlight search results