Global_Issue_Queue - This table is an accumulation of all of the regional Global_Issue_Extension tables
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) numeric identifier. |
| remote_id | integer | not null | Regional Issue id |
| remote_sys_id | integer | not null | Regional system id |
| active_flag | integer | not null | (1=Active, 0=not active) |
| last_mod_dt | integer | not null | Timestamp of when this record was last modified |
| global_queue_id | integer | with null | Pointer to global queue |
| ref_num | nvarchar(30) | not null | Issue ref num |
| status | nvarchar(30) | not null | Status symbol of Issue |
| priority | integer | not null | Priority of Issue |
| open_date | integer | not null | Open Date of Issue |
| close_date | integer | with null | Close Date of Issue |
| category | nvarchar(30) | with null | Category symbol of Issue |
| summary | nvarchar(240) | with null | Summary of Issue |
| product | integer | with null | Product of Issue |
| impact | integer | with null | Impact of Issue |
| group_id | byte(16) | with null | Group assigned to Issue |
| assignee | byte(16) | with null | Assignee of Issue |
| requestor | byte(16) | not null | Affected User of Issue |
Product Name: Unicenter Service Desk
Table Type: Table