TaskTemplates Table

Applies to QAComplete 12.31 On-Premises, last modified on April 22, 2021

Description

The table stores task templates that allow users to create sets of tasks to be easily imported into a project plan.

Columns

The table contains the following columns:

TaskTemplateId  :  int, primary key, allows null: no

The unique numeric identifier of the task template.

DeptId  :  int, allows null: no

The ID of the department that owns the task template.

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.

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

The description of the task template.

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

IsPublic  :  char (max 1 char), allows null: yes

Indicates whether the task template is public.

ProjId  :  int, allows null: no

The ID of the project that contains the item.

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

The name of the task template.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

See Also

TaskTemplates View
Project Management

Highlight search results