Jump to: navigation, search

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.

Table G_DND_HISTORY


This table stores information about the activation of the Do Not Disturb (DND) feature within an agent's session. The T-Server model registers DND events against individual DNs. For the Multimedia model, the DND feature can be activated or deactivated only for the agent's overall place, which may consist of more than one DN. As such, the ENDPOINTID field will always hold a value of 0 for interactions originating from Interaction Server. Whether ICON writes to this table is determined by the setting of one or more configuration options in the [filter-data] section.

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 numeric(16) X X The unique, autonumbered ID of this record. This is the primary key.
LoginSessionID varchar(50) X The agent's login session ID (GUID). The same value as stored in G_LOGIN_SESSION.LOGINSESSIONID.
AgentState int The state of the agent on the device (endpointid) against a queue (queueid), or the previous state in G_AGENT_STATE_HISTORY table. One of the following values:
  • 0—null–Agent is logged off.
  • 1—login–Agent is logged in, but no information whether the agent is ready to receive calls.
  • 2—notready–Agent is not ready to receive calls.
  • 3—ready–Agent is ready to receive calls.
  • 4—acw–Agent is in after call work state.
  • 5—busy–Agent is on the call.
  • 6—unknown–Agent's login session is present, but ICON has no information about agent's state (due to a disconnection from T-Server, for example).


#DICTIONARY TYPE 16

EndPointID int X The DBID of the DN object that is associated with this record. This value is 0 for interactions originating from an Interaction Server. In a SIP Cluster environment, the value for this field is 0.
State int X Do-not-disturb feature state. One of the following values:
  • 0—clear–Do not disturb flag is not set.
  • 1—set–Do not disturb flag is set.


#DICTIONARY TYPE 80

PrevState int State of the agent on device (endpointid) against queue (queueid), or previous state in G_AGENT_STATE_HISTORY table. One of the following values:
  • 0—null–Agent is logged off.
  • 1—login–Agent is logged in, but no information whether the agent is ready to receive calls.
  • 2—notready–Agent is not ready to receive calls.
  • 3—ready–Agent is ready to receive calls.
  • 4—acw–Agent is in after call work state.
  • 5—busy–Agent is on the call.
  • 6—unknown–Agent's login session is present, but ICON has no information about agent's state (due to a disconnection from T-Server, for example).


#DICTIONARY TYPE 16

PrevSEnter datetime The GMT-equivalent date and time when the previous agent state was detected.
PrevSEnter_ts int The UTC-equivalent value of the PREVSENTER field.
PrevSEnter_tcode int A reference, derived from the value of the PREVSENTER_TS field, to a record in the G_TIMECODE table.
Added datetime X The GMT-equivalent date and time when information about an agent's change of agent's state was detected.
Added_ts int The UTC-equivalent value of the ADDED field.
Added_tcode int A reference, derived from the value of the ADDED_TS field, to a record in 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_TS datetime Reserved
GSYS_TC int Reserved
GSYS_EXT_VCH1 varchar(255) Reserved

In a SIP Cluster environment, records the DN name.

GSYS_EXT_VCH2 varchar(255) If the gls-store-event-seq configuration option is set to 1, then this field stores the event sequence number, as a string, from the triggering event for this record. Otherwise, this field is null.
GSYS_EXT_INT1 int Reserved
GSYS_EXT_INT2 int Reserved
This page was last edited on January 10, 2020, at 15:27.
Comments or questions about this documentation? Contact us for support!