actual_
duration

INTEGER

Identifies the time spent on the task by the user.

asset

byte(16)

ca_owned_
resource::uuid

Foreign key to the id field of the ca_owned_resource table, this is the Asset.

assignee

byte(16)

ca_contact::uuid

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

comments

STRING

Save comments for the Task.

completion
_date

INTEGER

Specifies the date of the task.

cost

INTEGER

Identifies the cost value for this Workflow task.

creator

byte(16)

ca_contact::uuid

Foreign key to the contact_uuid field of the ca_contact table, this identifies the person who created the Workflow task.

date_
created

INTEGER

Identifies the date and time of when the record was created.

del

INTEGER

Active_Boolean
_Table::enum

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

description

nvarchar(1000)

Contains the Workflow task notes.

done_by

byte(16)

ca_contact::uuid

Foreign key to the contact_uuid field of the ca_contact table, this identifies who created the Workflow task.

est_comp_
date

INTEGER

Identifies the estimated completion date value for this Workflow task.

est_cost

INTEGER

Identifies the estimated cost value for this Workflow task.

est_duration

INTEGER

Specifies the estimated duration value for this Workflow task.

group_id

byte(16)

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

group_task

INTEGER

Sets the flag for group_task, as follows:
0—No
1—Yes

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_id

INTEGER

chg id

Identifies the id of the object to which this Workflow task belongs.

object_type

nvarchar(30)

Identifies the short name of the object to which this Workflow task belongs.

persid

nvarchar(30)

Persistent ID (SystemObjectName:id).

sequence

INTEGER

Specifies the sequence value for this Workflow task.

start_date

INTEGER

Identifies the date that the status changed to pending.

status

nvarchar(12)

Task_Status::
code

Indicates the non-editable key for the status.

support_lev

nvarchar(30)

Service_Desc::
code

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

support_level

nvarchar(30)

Deprecated.

task

nvarchar(12)

Task_Type::
code

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

wf_template

INTEGER

Workflow_Task_
Template::id

Foreign key to the id field of the wftpl table, this is the Workflow Task Template.