Previous Topic: g_tenant TableNext Topic: Global_Change_Queue Table


Global_Change_Extension Table

Local copy of data that will be pushed to master's Global_Change_Queue table.

Field

Data Type

Reference

Remarks

active_flag

INTEGER NOT_NULL

Active_Reverse_ Boolean::enum

1—Active

0—Inactive

affected_contact

UUID NOT_NULL

ca_contact::uuid

Specifies the Effected End User of CO.

assignee

UUID

ca_contact::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 request id.

requestor

UUID NOT_NULL

ca_contact::uuid

Specifies the requester of CO.

status

STRING 30 NOT_NULL

Change_Status:: code

Specifies the status symbol of CO.

summary

STRING 240

 

Specifies the summary of CO.