Previous Topic: Global_Issue_Extension TableNext Topic: Global_Location Table


Global_Issue_Queue Table

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

Field

Data Type

Reference

Remarks

active_flag

INTEGER NOT_NULL

Active_Reverse_ Boolean::enum

1—Active

0—Inactive

assignee

UUID

 

Assignee of Issue

category

STRING 30

 

Category symbol of Issue

close_date

LOCAL_TIME

 

Close Date of Issue

global_queue_ id

INTEGER

Global_Queue_ Names::id

Pointer to global queue

group_id

UUID

 

Group assigned to Issue

id

INTEGER UNIQUE NOT_NULL KEY

 

Unique (to the table) Numeric ID

impact

INTEGER

Impact::enum

Impact of Issue

last_mod_dt

LOCAL_TIME NOT_NULL

 

Indicates the timestamp of when this record was last modified.

open_date

LOCAL_TIME NOT_NULL

 

Open Date of Issue

priority

INTEGER NOT_NULL

Priority::enum

Priority of Issue

product

INTEGER

 

Product of Issue

ref_num

STRING 30 NOT_NULL

 

Issue ref num

remote_id

INTEGER NOT_NULL S_KEY

 

Regional Issue id

remote_sys_id

INTEGER NOT_NULL S_KEY

Global_Servers:: remote_sys_id

Regional system id

requestor

UUID NOT_NULL

 

Affected User of Issue

status

STRING 30 NOT_NULL

Issue_Status::code

Status symbol of Issue

summary

STRING 240

 

Summary of Issue