Workflow task templates. information here is used to build the workflow task.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Primary key of this table |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| del | integer | not null | Deleted flag (0=active 1=inactive/marked as deleted) |
| description | nvarchar(240) | with null | Textual description |
| last_mod_dt | integer | with null | Timestamp of when this record was last modified |
| last_mod_by | byte(16) | with null | Specifies the UUID of the contact who last modified this record |
| object_type | nvarchar(30) | not null | short name of object |
| object_attrname | nvarchar(30) | not null | this template belongs attribute name in object |
| object_attrval | integer | not null | Which drives the template attribute value |
| task | nvarchar(12) | not null | Task template. Foreign key to the code field of the tskty table |
| sequence | integer | not null | The sequence value for this Workflow_Task_Template. |
| assignee | byte(16) | with null | Assignee. Foreign key to the contact_uuid field of the ca_contact table. |
| group_id | byte(16) | with null | Group. Foreign key to the contact_uuid field of the ca_contact table. |
| service_type | nvarchar(30) | with null | Classic Service Type. Foreign key to the code field of the srv_desc table. |
| deleteable | integer | not null | 0=no, 1=yes |
| est_duration | integer | with null | The estimated duration value for this Workflow_Task_Template |
| est_cost | integer | with null | The estimated cost value for this Workflow_Task_Template |
| auto_assign | integer | with null | flag for Auto-Assignment |
Product Name: Unicenter Service Desk
Table Type: Table