Object workflow tasks. task is in here because tasks can be added from a change request which means there is no task template to get the task from...
| 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) |
| object_type | nvarchar(30) | not null | short name of object which this workflow task belongs |
| object_id | integer | not null | Id of object which this workflow task belongs |
| task | nvarchar(12) | not null | Task template. Foreign key to the code field of the tskty table |
| wf_template | integer | with null | Workflow Task Template. Foreign key to the id field of the wftpl table |
| sequence | integer | not null | The sequence value for this Workflow_Task. |
| status | nvarchar(12) | with null | Noneditable key for status |
| group_task | integer | not null | 0=no,1=yes |
| asset | byte(16) | with null | Asset. Foreign key to the id field of the ca_owned_resource table |
| creator | byte(16) | with null | Created By. Foreign key to the contact_uuid field of the ca_contact table |
| date_created | integer | with null | Datetime of record creation |
| 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. |
| support_lev | nvarchar(30) | with null | Classic Service Type. Foreign key to the code field of the srv_desc table. |
| done_by | byte(16) | with null | Completed By. Foreign key to the contact_uuid field of the ca_contact table |
| start_date | integer | with null | Date status went to pending |
| est_comp_date | integer | with null | The estimated completion date value for this Workflow_Task. |
| completion_date | integer | with null | Date of the task |
| est_duration | integer | with null | The estimated duration value for this Workflow_Task. |
| actual_duration | integer | with null | Time spent on task (user) |
| est_cost | integer | with null | The estimated cost value for this Workflow_Task. |
| cost | integer | with null | The cost value for this Workflow_Task. |
| description | nvarchar(1000) | with null | Workflow task notes |
| 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 |
Product Name: Unicenter Service Desk
Table Type: Table