Description
Contains information on task templates.
Dependencies
Columns
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.
DeptId : int, allows null: no
The ID of the department that owns the task template.
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 Text Feature.
IsCompanyWide : varchar (max 1 char), allows null: no
Indicates whether the task template is company-wide.
IsPublic : char (max 1 char), allows null: yes
Indicates whether the task template is public.
NbrEvents : int, allows null: yes
The number of events attached to the associated item.
NbrFiles : int, allows null: yes
The number of files attached to the associated item.
NbrNotes : int, allows null: yes
The number of notes attached to the associated item.
NbrTasks : int, allows null: yes
The number of tasks attached to the associated item.
ProjId : int, allows null: no
The ID of the project that contains the item.
TaskTemplateId : int, allows null: no
The unique numeric identifier of the task template.
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.
UserName : varchar (max 78 chars), allows null: yes
The name of the user who last updated the associated item, in the Last name, First name format.