TaskTemplates Table

Applies to QAComplete 12.70 SaaS, last modified on January 11, 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