assignee

byte(16)

ca_contact::uuid

Foreign key to the contact_uuid field of the ca_contact table, this is the Assignee.

auto_assign

INTEGER

Indicates the flag that enables Auto Assignment.

del

INTEGER

Active_Boolean_
Table::enum

Specifies the Deleted flag, as follows:
0—Active
1—Inactive/marked as deleted

deleteable

INTEGER

Specifies the Deleteable flag, as follows:
0—No
1—Yes

description

nvarchar(240)

Specifies the textual description.

est_cost

INTEGER

Specifies the estimated cost value for this Workflow_Task_Template.

est_duration

INTEGER

Specifies the estimated duration value for this Workflow_Task_Template.

group_id

byte(16)

Foreign key to the contact_uuid field of the ca_contact table, this is the Group.

id

INTEGER

Primary key of this table

last_mod_by

byte(16)

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

Indicates the timestamp of when this record was last modified.

object_
attrname

nvarchar(30)

Specifies that this template belongs to the attribute name in the object.

object_attrval

INTEGER

Specifies the object attribute value which drives the template attribute value.

object_type

nvarchar(30)

Identifies the short name of the object.

persid

nvarchar(30)

Persistent ID (SystemObjectName:id).

sequence

INTEGER

Identifies the sequence value for this Workflow_Task_Template.

service_type

nvarchar(30)

Service_Desc ::code

Foreign key to the code field of the srv_desc table, this is the Classic Service Type.

task

nvarchar(12)

Task_Type::code

Foreign key to the code field of the tskty table, this is the Task template.