Denormalized Service Desk Workflow Table.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| wf_uuid | byte(16) | not null | Workflow uuid from Unicenter Service Desk |
| persid | nvarchar(64) | not null | |
| task_type | nvarchar(100) | with null | The type classification of the task |
| rec_uuid | byte(16) | with null | SI Record uuid |
| rec_category | nvarchar(256) | with null | The denormalized value of the owning records Category. This may be a Change category, or Issue Category for Service Desk, or a Catalog Name for Service Delivery, as examples. |
| on_hold | integer | with null | Derrived Boolean indicating that the workflow tasks SLA is in an "On Hold" state or not. |
| start_date | date | with null | Date that the task is actually started |
| completion_date | date | with null | Date that the task actually completed |
| time_open | integer | with null | Value derrived from completion_date - start_date in number of seconds. Duration data type necessary |
| est_cost | money | with null | Estiamted cost of completing the workflow task |
| est_duration | integer | with null | Estimated time it will take to complete the workflow task |
| actual_cost | money | with null | Actual cost for completing the task |
| actual_duration | integer | with null | Actual time spent completing the task |
| rec_end_user_loc | nvarchar(100) | with null | Denormalized value of the si_rec_prop records' end users' location name |
| rec_end_user_org | nvarchar(100) | with null | Denormalized value of the si_rec_prop records' end users' organization name |
| rec_assignee_loc | nvarchar(100) | with null | Denormalized value of the si_rec_prop records' assignees' location name |
| rec_assignee_org | nvarchar(100) | with null | Denormalized value of the si_rec_prop records' assignees' organization name |
| assignee_org | nvarchar(100) | with null | The denormalized workflow tasks owning change orders' or issues' assignees' organization name |
| assignee_loc | nvarchar(100) | with null | The denormalized workflow tasks owning change orders' or issues' assignees' location name |
| assignee_manager | byte(16) | with null | The denormalized combo_name of the workflow tasks assignees manager. |
| group_loc | nvarchar(100) | with null | The location of the group assigned to the workflow task |
| group_org | nvarchar(100) | with null | The organization of the workflow tasks' assigned group. |
| done_by_loc | nvarchar(100) | with null | The denormalized location value for the analyst who completed the workflow task. |
| done_by_group | nvarchar(100) | with null | The denormalized primary group value for the analyst who completed the workflow task. |
| violate_status | integer | with null | Boolean indicating if the workflow tasks' SLA has been violated. Required as the time_to_violate resets based on the number of allowed violations per task. |
| last_update_date | date | with null | Last date/time that the workflow task was updated |
| last_update_by | nvarchar(100) | with null | Denormalized name of the last updater of the workflow task |
| assigned_flag | integer | with null | Derived Boolean indicating that either a group or an assignee, or both are assigned to the owning change order or issue. |
| rec_priority | nvarchar(20) | with null | Denormalized priority value of the owning change ordr or issue. |
| rec_ref_num | nvarchar(16) | with null | Internal ref_num of the owning change order or issue, used for dynamically linking back to the source record in Unicenter Service Desk if uuid fails to work over web in r11. |
| rec_type | char(10) | with null | The denormalized value of the owning change orders' or issues' type value. (C or S) |
| time_to_violate | integer | with null | The time until this workflow task will be violated based on Service Desk SLA definitions. |
| data_source | varchar(256) | not null | Source that the data was received from |
Product Name: Unicenter Service Intelligence
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| wf_uuid persid |