Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key

Table G_IS_LINK_HISTORY


This table contains information regarding all of the states of the intersite link, in chronological order as derived from data supplied by T-Server.

Column List

Legend

Column Data Type P M F Description

ID

NUMBER(16) X X This unique, autonumbered ID of this record. This is the primary key.

LinkID

VARCHAR2(50) X X This is the intersite link ID, which identifies the association between two calls.

Seq

INTEGER X The sequence number of the changes in this link history.

ChangeType

INTEGER X IS-Link history record type: added, moved, or deleted. One of the following:
  • 0—unknown–Reserved.
  • 1—added–IS-Link addition.
  • 2—moved–IS-Link move.
  • 3—deleted–IS-Link deletion.


#DICTIONARY TYPE 22

State

INTEGER The link state of the history record. One of the following values:
  • 0—unknown–Reserved.
  • 1—active–IS-Link is active.
  • 2—terminated–IS-Link is terminated.
  • 3—failed–IS-Link has failed; no pair is expected on the other site.


#DICTIONARY TYPE 21

CallID

VARCHAR2(50) A reference to the call that is currently associated with this history.

PrevCallID

VARCHAR2(50) A reference to the call that was previously associated with this history.

Added

TIMESTAMP(3) X The GMT-equivalent date and time when the history record was added.

Added_ts

INTEGER The UTC-equivalent value of the ADDED field.

Added_tcode

INTEGER A reference, derived from the value of the ADDED_TS field, to a record in the G_TIMECODE table.

GSYS_DOMAIN

INTEGER Contains the data source session ID (DSS_ID) for the session that was active when the data was processed by ICON. For more information, see the description in System Fields.

GSYS_PARTITION

INTEGER A key that is used for partitioning.

GSYS_SYS_ID

INTEGER System ID. Reserved for future use.

GSYS_SEQ

INTEGER Insert Sequence. Not unique.

GSYS_USEQ

INTEGER Update Sequence. Not unique.

GSYS_TS

TIMESTAMP(3) Reserved

GSYS_TC

INTEGER Reserved

GSYS_EXT_VCH1

VARCHAR2(255) Reserved

GSYS_EXT_VCH2

VARCHAR2(255) Reserved

GSYS_EXT_INT1

INTEGER Reserved

GSYS_EXT_INT2

INTEGER Reserved

   

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 31 October 2016, at 15:34.