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 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.
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||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:
|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:
|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:
|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.|
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.|