g_iss_ext

Global_Issue_Extension - Local copy of data that will be pushed to master's Global_Issue_Queue table

Column Name Column Datatype Column Null Option Column Comment
id integer not null Unique (to the table) numeric identifier.
remote_id integer not null Regional request 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
ref_num nvarchar(30) not null Issue ref num
status nvarchar(30) not null Status symbol of Issue
priority integer not null Priority of Issue
open_date integer not null Open Date of Issue
close_date integer with null Close Date of Issue
category nvarchar(30) with null Category symbol of Issue
summary nvarchar(240) with null Summary of Issue
product integer with null Product of Issue
impact integer with null Impact of Issue
group_id byte(16) with null Group assigned to Issue
assignee byte(16) with null Assignee of Issue
requestor byte(16) not null Affected End User of CO

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.