Global_Change_Queue - This table is an accumulation of all of the regional Global_Change_Extension tables
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) numeric identifier. |
| remote_sys_id | integer | not null | Regional system id |
| remote_id | integer | not null | Regional change 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 |
| chg_ref_num | nvarchar(30) | not null | Change ref num |
| status | nvarchar(30) | not null | Status sybmol of CO |
| priority | integer | not null | Priority of CO |
| impact | integer | with null | Impact of Change order |
| open_date | integer | not null | Open Date of CO |
| close_date | integer | with null | Close Date of CO |
| category | nvarchar(30) | with null | Category symbol of CO |
| summary | nvarchar(240) | with null | Summary of CO |
| group_id | byte(16) | with null | Group assigned to CO |
| assignee | byte(16) | with null | Assignee of CO |
| requestor | byte(16) | not null | Requestor of CO |
| affected_contact | byte(16) | not null | Affected End User of CO |
Product Name: Unicenter Service Desk
Table Type: Table