Jump to: navigation, search

In the Column List:

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

Table G_IR_HISTORY


This table contains information regarding all states, in chronological order, of the interaction, according to the information supplied by the specific provider, such as T-Server, Interaction Server, or the Outbound Contact Server. Whether ICON writes to this table is determined by the setting of one or more configuration options in the [filter-data] section.

Column List

Legend

Column Data Type P M F Description

IRHID

NUMBER(16) X X The unique ID of the interaction history record. This is the primary key.

IRID

VARCHAR2(50) X The ID of the Interaction record.

XSEQ

NUMBER(19) Reserved

ChangeType

INTEGER The type of change of interaction state. One of the following values:
  • 1—ir_created–Interaction creation.
  • 2—ir_terminated–Interaction termination.
  • 3—ir_merged–Interaction merge (result of a two-step transfer or a two-step conference).


#DICTIONARY TYPE 3

RefID

VARCHAR2(50) Reserved

Added

TIMESTAMP(3) X The GMT-equivalent data and time when the record was added as inherited from the T-Server TEvent.

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


Index List

Index Name U C

IDX_G_IR_H_XID

IDX_X_H_HIRID_SEQ

 

 

Comment on this article:

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