Previous Topic: Task_Status TableNext Topic: Timespan Table

Data Element Dictionary › Task_Type Table

Task_Type Table

This table contains the list of task types used in the workflow used by CA SDM, not those used by CA Workflow.

Field

Data Type

Reference

Remarks

code

nvarchar(12)

 

Primary key of this table.

del

INTEGER

Active_Boolean_
Table::enum

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

description

nvarchar(500)

 

Identifies the text description of the task.

id

INTEGER

 

Identifies the numeric ID, which is unique to the 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 for when this record was last modified.

persid

nvarchar(30)

 

Identifies the Persistent ID: (SystemObjectName:id).

sym

nvarchar(30)

 

Identifies the name of task.