Active Call and Active Interaction Schema

The tables in this schema contain data regarding calls and interactions that are currently active. When ICON detects a new call or interaction, it adds a new record to the corresponding table. When a call or interaction is terminated by ICON, the record for that call or interaction is deleted from the table.

To resolve stuck calls and interactions efficiently, the data in these tables is read whenever ICON starts. At that time, all calls and interactions still in the tables are marked as terminated, which also removes them from the Active Call and Active Interaction tables.

Active Call and Active Interaction Schema Diagram

Active Call and Active Interaction Data Model Diagram View Large

List of Tables

Table	Description
G_CALL_ACTIVE	This table contains information regarding the latest state of the interaction, according to information received from either the T-Server or Interaction Server applications.
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.

List of Indexes

Table	Index Name	U	C
G_CALL_ACTIVE	IDX_G_CALL_A_CID	X
G_IR_ACTIVE	IDX_G_IR_A_IRID	X

List of References

No references defined.