g_tbl_rule

Global_Table_Rule - Contains list of extract rules for global data transport.

Column Name Column Datatype Column Null Option Column Comment
id integer not null Unique (to the table) numeric identifier.
del integer not null Deleted flag (0=active 1=inactive/marked as deleted)
last_mod_dt integer with null Timestamp of when this record was last modified
last_mod_by byte(16) with null Specifies the uuid of the contact who last modified this record
sym nvarchar(30) not null Name for rule
description nvarchar(100) with null Comments field
sched nvarchar(30) with null Valid run schedule
reoccur_interv integer with null How often to re-query
table_map integer with null Table map
last_sync_dt integer with null What was the last sync date
addl_query nvarchar(240) with null Additional query

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.