actual_duration

INTEGER

Specifies 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.

completion_date

INTEGER

Indicates the timestamp of when this task was completed.

cost

INTEGER

Specifies the cost value for this Issue Workflow task.

creator

byte(16)

ca_contact
::uuid

Foreign key to the contact_uuid field of the ca_contact table, this identifies the creator of the Issue Workflow tast.

date_created

INTEGER

Specifies the date and time that the record was created.

del

INTEGER

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

description

nvarchar(1000)

Specifies workflow task notes.

done_by

byte(16)

ca_contact
::uuid

Foreign key to the contact_uuid field of the ca_contact table, this provides the Completed by information.

est_comp_date

INTEGER

The estimated completion date value for this Issue Workflow task.

est_cost

INTEGER

The estimated cost value for this Issue Workflow task.

est_duration

INTEGER

The estimated duration value for this Issue 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

Defines the Group task flag, 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

Identifies the timestamp of when this record was last modified

object_id

nvarchar(30)

Persistent ID (SystemObjectName:id)

object_type

nvarchar(30)

Indicates the short name of the object to which this workflow task belongs.

persid

nvarchar(30)

Specifies the Persistent ID (SystemObjectName:id).

sequence

INTEGER

Specifies the sequence value for this Issue Workflow task.

start_date

INTEGER

Indicates the timestamp of when the status went to pending.

status

nvarchar(12)

Task_Status
::code

Foreign key to the code field of the tskstat table, this is the Task status.

support_lev

nvarchar(30)

Service_
Desc::code

Foreign key to the code field of the srv_desc table, this identifies 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.

wf_template

INTEGER

Workflow_Task_
Template::id

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