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 party involved in an interaction according to information received from T-Server or 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 the party record. This is the primary key.|
|PartyID||varchar(50)||X||The unique ID of the association between the party and the call, generated by ICON. This is changed when the party moves from one call to a different call.|
|PartyGUID||varchar(50)||X||The unique ID of the party instance, generated by ICON. This ID remains unchanged during the lifetime of the party.|
|Type||int||X||The party type. One of the following values:
#DICTIONARY TYPE 9
|PRole||int||X||Party role. One of the following values:
#DICTIONARY TYPE 10
|ParentPartyID||varchar(50)||The ID of the associated party.|
|ParentLinkType||int||The type of association with the other party (identified by ParentPartyID) established as result of different call scenarios. One of the following values:
#DICTIONARY TYPE 11
|CallID||varchar(50)||X||X||The current ID as inherited from T-Server or Interaction Server.|
|State||int||X||The current state of party. (The previous party state is recorded in the PREVSTATE column.) One of the following values:
#DICTIONARY TYPE 8
|EndPointDN||varchar(255)||X||The name of the endpoint.
In a multi-site deployment that uses ISCC, ICON stores the EndpointDN related to the external party as reported by T-Server. The endpoint name might be reported either as the DN on the remote site, or else as "Access Code + External Routing Point".
|EndPointID||int||X||X||The DBID of the endpoint. For DNs, this DBID is equivalent to GC_ENDPOINT.ID. For script objects of type Interaction Queues, Interaction Workbins, and Routing Strategies, this is equivalent to GC_SCRIPT.ID. For Place objects, this is equivalent to GC_PLACE.ID.
|EndPointType||int||X||The type of the endpoint. For a listing of permissible values, refer to G_Dictionary Values (for DB2, Microsoft SQL Server, Oracle, or PostgreSQL, respectively).
|TenantID||int||The DBID of the Tenant configuration object that is associated with either the T-Server Switch or the Interaction Server Switch.|
|AgentID||int||X||The DBID of the agent that is associated with the party.|
|CCEvent||int||A call control event that is associated with the party state change. In the G_PARTY table, stored the party termination event. For a listing of permissible values, refer to G_Dictionary Values (for DB2, Microsoft SQL Server, Oracle, or PostgreSQL, respectively).
|CCEventCause||int||The cause that is associated with the party state change and the call control event. In the G_PARTY table, stored the party termination event. For a listing of permissible values, refer to G_Dictionary Values (for DB2, Microsoft SQL Server, Oracle, or PostgreSQL, respectively).
|Created||datetime||X||The GMT-equivalent date and time when the party was associated with the call.|
|Created_ts||int||The UTC-equivalent 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 date and time when the party was released from the call.|
|Terminated_ts||int||The UTC-equivalent value of the TERMINATED field.|
|Terminated_tcode||int||A reference, derived from the value of the TERMINATED_TS field, to the G_TIMECODE table.|
|LastChange||datetime||X||The GMT-equivalent date and time of the last state change of the party.|
|LastChange_ts||int||The UTC-equivalent value of the LASTCHANGED field.|
|LastChange_tcode||int||A reference, derived from the value of the LASTCHANGED_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)||The value of the LastTransferHomeLocation TEvent attribute.|
|GSYS_EXT_VCH2||varchar(255)||The value of the LastTransferOrigDN TEvent attribute.|
|GSYS_EXT_INT1||int||The sequence number of the call (CSEQ) in party creation.|
|GSYS_EXT_INT2||int||For third party media interactions, stores a special party index in scope of the interaction lifecycle. This value can be 0 or greater.|