Jump to: navigation, search

In the Column List:

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

Table G_IR_ACTIVE


This table contains information regarding the latest state of the interaction, according to the information supplied by a specific provider such as T-Server, Interaction Server, or Outbound Contact Server.

Column List

Legend

Column Data Type P M F Description

ID

BIGINT X X The unique, autonumbered ID of this record. This is the primary key.

IRID

VARCHAR(50) X The Interaction Record ID. This is a unique ID assigned either by ICON for the interaction segment or interaction hierarchy for a single site call, or by a merge procedure for the interaction hierarchy for a multi-site call.

State

INTEGER X The interaction record state. One of the following values:
  • 0—unknown–Reserved.
  • 1—active–The interaction segment corresponds to an active call.
  • 2—terminated–The interaction segment corresponds to a terminated call or an updated interaction hierarchy after a merge.


#DICTIONARY TYPE 7

ParentIRID

VARCHAR(50) A reference to the parent IRID. This is assigned as the result of a call merge operation (for example, a transfer or a conference).

ParentLinkType

INTEGER Reserved. This field holds a value of 0 in the current interaction hierarchy model.


#DICTIONARY TYPE: 11

RootCallID

VARCHAR(50) X This is used for local calls. It is a reference to the call for which this record was initiated. If this is the result of a merge procedure, an interaction record is created where this value refers to the first call in an interaction hierarchy.

RootIRID

VARCHAR(50) A reference to the first record in an interaction hierarchy. The value is updated by a merge procedure.

MergeState

INTEGER This is the result of a merge procedure execution. One of the following values:
  • 1—Not_processed–The record was not processed by a merge procedure.
  • 2—Incomplete–The merge is in a pending state; not all of the data is available for the merge.
  • 3—Complete–The merge is complete; the interaction details hierarchy can be used for analysis.


Note: The Merge procedure does not process records in G_CALL_ACTIVE or G_IR_ACTIVE tables. While the record remains in one of those tables, the MergeState = 1, and GSYS_EXT_INT2 = null.
#DICTIONARY TYPE 23

Created

TIMESTAMP X The GMT-equivalent date and time when the record was initiated.

Created_ts

INTEGER The UTC-equivalent of the value of the CREATED field.

Created_tcode

INTEGER A reference, derived from the value of the CREATED_TS field, to the G_TIMECODE table.

Terminated

TIMESTAMP The GMT-equivalent time when the record was terminated.

Terminated_ts

INTEGER The UTC-equivalent of the value of the TERMINATED field.

Terminated_tcode

INTEGER A reference, derived from the value of the TERMINATED_TS field, to 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

BIGINT Insert Sequence. Not unique.

GSYS_USEQ

BIGINT Update Sequence. Not unique.

GSYS_TS

TIMESTAMP Reserved

GSYS_TC

INTEGER Reserved

GSYS_EXT_VCH1

VARCHAR(255) If the record was created as a result of Multimedia event processing and the information about the parent interaction ID was provided by a Multimedia Interaction Server, but no related record in IDB was detected (for example, because old records were purged), this field contains the parent interaction ID.

GSYS_EXT_VCH2

VARCHAR(255) A flag indicating stuck interactions:
  • 1—Indicates an interaction that is determined to be a stuck interaction.

GSYS_EXT_INT1

BIGINT A flag indicating the source of the interaction:
  • 1—Indicates a multimedia interaction originating from a Genesys Interaction Server.
  • null—Indicates a voice interaction originating from Genesys

T-Server TEvent processing.

GSYS_EXT_INT2

BIGINT Can be set by the gsysIRMerge procedure during interaction merge execution, to one of the following values:
  • null—Interaction has not yet been merged.
  • 0—Single-site interaction.
  • 1—Inter-site interaction, whose parts reside in several IDBs. ICON also places a corresponding record in the GSYS_DNPREMOTELOCATION table.

GSYS_MSEQ

BIGINT The sequence number that is assigned by the merge procedure.

GSYS_MSEQ_TS

TIMESTAMP The timestamp that is assigned by the merge procedure.


Index List

Index Name U C

IDX_G_IR_A_IRID

X

 

 

Feedback

Comment on this article:

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