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.

Tip

To assist you in preparing supplementary documentation, click the following link to download a comma-separated text file containing information such as the data types and descriptions for all columns in this table: Download a CSV file.

Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.

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 (for DB2, Microsoft SQL Server, Oracle, or PostgreSQL, respectively).
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.