Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key

Table G_CUSTOM_STATES


This table contains detailed information about an agent's state changes during his or her login session. The records inserted into this table include:

  • changes to the agent's state
  • changes to the agent's pending state
  • changes to the agent's workmode
  • changes to the agent's hardware reason code
  • the fact that the agent connects or disconnects to a call
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 NUMBER(16) X X The unique, autonumbered ID of this record. This is the primary key.
CallID VARCHAR2(50) This field points to the record in the G_CALL table that represents the call with which the data is associated. This field may be NULL.
PartyID VARCHAR2(50) This field points to the record in the G_PARTY table that represents the party with which the data is associated. This field may be NULL.
PSEQ INTEGER X The sequence that corresponds to the G_PARTY_HISTORY.
EndPointID INTEGER This field contains the DBID of the endpoint that added, changed, or deleted the data. If the data was taken from the event that caused the creation of the respective call, then this is the first party created in the call. If the data was taken from the AttachedDataChangedEvent, then the party is defined by the ThirdPartyDN attribute, if any exists. Otherwise, this is the party that is defined by the ThisDN attribute (if any). For other changes, the party is defined by the ThisDN attribute.
EndPointDN VARCHAR2(255) The device number that is associated with the data.
AgentID INTEGER This field contains the DBID of the agent object that represents the person who changed the data. This is the agent who logged in to the endpoint that is associated with the data change (if this information is available during run time).
SwitchID INTEGER This field contains the DBID of the Switch object that owns the endpoint that is associated with the change. If the EndPointID field is NULL, then so is the field SwitchID, and vice versa.
TenantID INTEGER The DBID of the Tenant that is associated with the Switch.
StateCode INTEGER X 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 is available to indicate 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 the agent's state (due to a disconnection from T-Server, for example).


#DICTIONARY TYPE 16

CUST_DATA_1 VARCHAR2(128) The value of the cust-data-1 attribute of userdata.
CUST_DATA_2 VARCHAR2(128) The value of the cust-data-2 attribute of userdata.
CUST_DATA_3 VARCHAR2(128) The value of the cust-data-3 attribute of userdata.
CUST_DATA_4 VARCHAR2(128) The value of the cust-data-4 attribute of userdata.
CUST_DATA_5 VARCHAR2(128) The value of the cust-data-5 attribute of userdata.
CUST_DATA_6 VARCHAR2(128) The value of the cust-data-6 attribute of userdata.
CUST_DATA_7 VARCHAR2(128) The value of the cust-data-7 attribute of userdata.
CUST_DATA_8 VARCHAR2(128) The value of the cust-data-8 attribute of userdata.
CUST_DATA_9 VARCHAR2(128) The value of the cust-data-9 attribute of userdata.
CUST_DATA_10 VARCHAR2(128) The value of the cust-data-10 attribute of userdata.
CUST_DATA_11 VARCHAR2(128) The value of the cust-data-11 attribute of userdata.
CUST_DATA_12 VARCHAR2(128) The value of the cust-data-12 attribute of userdata.
CUST_DATA_13 VARCHAR2(128) The value of the cust-data-13 attribute of userdata.
CUST_DATA_14 VARCHAR2(128) The value of the cust-data-14 attribute of userdata.
CUST_DATA_15 VARCHAR2(128) The value of the cust-data-15 attribute of userdata.
CUST_DATA_16 VARCHAR2(128) The value of the cust-data-16 attribute of userdata.
CUST_DATA_17 VARCHAR2(128) The value of the cust-data-17 attribute of userdata.
CUST_DATA_18 VARCHAR2(128) The value of the cust-data-18 attribute of userdata.
CUST_DATA_19 VARCHAR2(128) The value of the cust-data-19 attribute of userdata.
Added TIMESTAMP(3) X The GMT-equivalent date and time when information about an agent's change of agent's state was detected.
Added_ts INTEGER The UTC-equivalent value of the ADDED field.
Added_tcode INTEGER A reference, derived from the value in the ADDED_TS field, to a record in the G_TIMECODE table.
Terminated TIMESTAMP(3) The GMT-equivalent date and time when the party was released from the call.
Terminated_ts INTEGER The UTC-equivalent value of the TERMINATED field.
Terminated_tcode INTEGER A reference, derived from the value in the TERMINATED_TS field, to a record in the G_TIMECODE table.
GSYS_DOMAIN INTEGER Reserved
GSYS_PARTITION INTEGER A key that is used for partitioning.
GSYS_SYS_ID INTEGER System ID. Reserved for future use.
GSYS_SEQ INTEGER Insert Sequence. Not unique.
GSYS_USEQ INTEGER Update Sequence. Not unique.
GSYS_TS TIMESTAMP(3) Reserved
GSYS_TC INTEGER Reserved
GSYS_EXT_VCH1 VARCHAR2(255) Reserved
GSYS_EXT_VCH2 VARCHAR2(255) Reserved
GSYS_EXT_INT1 INTEGER Reserved
GSYS_EXT_INT2 INTEGER Reserved
This page was last edited on January 10, 2020, at 15:27.
Comments or questions about this documentation? Contact us for support!