Previous Topic: Global_Issue_Queue TableNext Topic: Global_Organization Table


Global_Location Table

Contains all Location names for all regions.

Field

Data Type

Reference

Remarks

del

INTEGER NOT_NULL

Active_Boolean_ Table::enum

Deleted flag

0—Active

1—Inactive/marked as deleted

id

INTEGER UNIQUE NOT_NULL KEY

 

Unique (to the table) Numeric ID

last_mod_dt

LOCAL_TIME

 

Indicates the timestamp of when this record was last modified.

loc_name

STRING 100

 

Location Name

remote_id

UUID NOT_NULL S_KEY

 

Regional location id

remote_sys_id

INTEGER NOT_NULL S_KEY

Global_Servers:: remote_sys_id

Regional system id