Previous Topic: Global_Change_Extension TableNext Topic: Global_Contact Table


Global_Change_Queue Table

This table is an accumulation of all of the regional Global_Change_Extension tables.

Field

Data Type

Reference

Remarks

active_flag

INTEGER NOT_NULL

Active_Reverse_ Boolean::enum

1—Active

0—Inactive

affected_ contact

UUID NOT_NULL

 

Specifies the Affected End User of CO.

assignee

UUID

 

Specifies the assignee of CO.

category

STRING 30

 

Specifies the category symbol of CO.

chg_ref_num

STRING 30 NOT_NULL

 

Specifies the change ref num.

close_date

LOCAL_TIME

 

Specifies the close Date of CO.

global_queue_ id

INTEGER

Global_Queue_ Names::id

Specifies the pointer to global queue.

group_id

UUID

 

Specifies the group assigned to CO.

id

INTEGER UNIQUE NOT_NULL KEY

 

Unique (to the table) Numeric ID

impact

INTEGER

Impact::enum

Specifies the impact of change order.

last_mod_dt

LOCAL_TIME NOT_NULL

 

Indicates the timestamp of when this record was last modified.

open_date

LOCAL_TIME NOT_NULL

 

Specifies the open date of CO.

priority

INTEGER NOT_NULL

Priority::enum

Specifies the priority of CO.

remote_id

INTEGER NOT_NULL S_KEY

 

Specifies the regional change id.

remote_sys_id

INTEGER NOT_NULL S_KEY

Global_Servers:: remote_sys_id

Specifies the regional system id.

requestor

UUID NOT_NULL

 

Specifies the requestor of CO.

status

STRING 30 NOT_NULL

Change_Status:: code

Specifies the status sybmol of CO.

summary

STRING 240

 

Specifies the summary of CO.