In the Column List:
- P = Primary key
- M = Mandatory field
- F = Foreign key
- In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar.
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.
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.
|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||int||X||The interaction record state. One of the following values:
|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||int||Reserved. This field holds a value of 0 in the current interaction hierarchy model.
|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||int||This is the result of a merge procedure execution. One of the following values:
|Created||datetime||X||The GMT-equivalent date and time when the record was initiated.|
|Created_ts||int||The UTC-equivalent of the value of the CREATED field.|
|Created_tcode||int||A reference, derived from the value of the CREATED_TS field, to the G_TIMECODE table.|
|Terminated||datetime||The GMT-equivalent time when the record was terminated.|
|Terminated_ts||int||The UTC-equivalent of the value of the TERMINATED field.|
|Terminated_tcode||int||A reference, derived from the value of the TERMINATED_TS field, to the G_TIMECODE table.|
|GSYS_DOMAIN||int||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||int||A key that is used for partitioning.|
|GSYS_SYS_ID||int||System ID. Reserved for future use.|
|GSYS_SEQ||bigint||Insert Sequence. Not unique.|
|GSYS_USEQ||bigint||Update Sequence. Not unique.|
|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:
|GSYS_EXT_INT1||bigint||A flag indicating the source of the interaction:
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:
|GSYS_MSEQ||bigint||The sequence number that is assigned by the merge procedure.|
|GSYS_MSEQ_TS||datetime||The timestamp that is assigned by the merge procedure.|