Table G_PARTY

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.

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	bigserial	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	integer		X		The party type. One of the following values: 0—Unknown–Reserved. 1—Internal–Party is associated with a device defined in the switch configuration. 2—External–Party is associated with a device not defined in the switch configuration. 3—MULTIMEDIA Place–Place associated with the party. 4—MULTIMEDIA Interaction Queue–Party is associated with a script of type "Interaction Queue". 5—MULTIMEDIA Interaction Workbin–Party is associated with a script of type "Interaction Workbin". 6—MULTIMEDIA Routing Strategy–Party is associated with a script of type "Simple Routing" or "Enhanced Routing". #DICTIONARY TYPE 9
PRole	integer		X		Party role. One of the following values: 0—Unknown–Reserved for future use. 1—Observer–Indicates that the supervisor was observing service. #DICTIONARY TYPE 10
ParentPartyID	varchar(50)				The ID of the associated party.
ParentLinkType	integer				The type of association with the other party (identified by ParentPartyID) established as result of different call scenarios. One of the following values: 0—Unknown–Reserved. 1—Consultation–The ParentPartyID refers to the held party from the primary call. 2—Transfer–The ParentPartyID refers to the party record of the call from which the party was transferred. 3—Conference–The ParentPartyID refers to the party record of the call from which the party was conferenced. 4—Divert–The ParentPartyID refers to the party record of the call that was diverted to this party. #DICTIONARY TYPE 11
CallID	varchar(50)		X	X	The current ID as inherited from T-Server or Interaction Server.
State	integer		X		The current state of party. (The previous party state is recorded in the PREVSTATE column.) One of the following values: 0—Unknown–State in which there is no relationship between the call and the device. 1—Initiated–Reserved. 2—Alerting–State in which an attempt is being made to connect an interaction to a device. Typically, the call is being presented for the purpose of having the device connect to the interaction and the user is made aware that the interaction is being delivered at the device. 3—Connected–State in which the device is actively participating in the interaction. 4—Hold–State in which the device is inactively participating in the call. This state includes logical participation in a call while physical participation is suspended. 5—Queued–State in which interaction progression is suspended or made inactive while awaiting some form of action. Examples include: a call is parked at a device, a call is queued at a distribution mechanism, waiting for an agent to become available, and so on. 6—Fail–State in which call progression has been aborted. #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	integer		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. If the endpoint is not configured in the Configuration Layer (it is an external DN or an endpoint in a SIP Cluster environment), the value for this field is 0.
EndPointType	integer		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). This value is the same that is stored in GC_ENDPOINT.TYPE, if the endpoint is a voice DN. If the endpoint is one of the following, the value of this field is the same as that stored in GC_SCRIPT.TYPE: Interaction Queue Interaction Workbin Routing Strategy Agent Place #DICTIONARY TYPE 505 In a SIP Cluster environment, if the endpoint is not configured in Configuration Layer, the value for this field is 1.
TenantID	integer				The DBID of the Tenant configuration object that is associated with either the T-Server Switch or the Interaction Server Switch.
AgentID	integer			X	The DBID of the agent that is associated with the party.
CCEvent	integer				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). #DICTIONARY TYPE 30
CCEventCause	integer				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). #DICTIONARY TYPE 31
Created	timestamp		X		The GMT-equivalent date and time when the party was associated with the call.
Created_ts	integer				The UTC-equivalent value of the CREATED field.
Created_tcode	integer				A reference, derived from the value of the CREATED_TS field, to the G_TIMECODE table.
Terminated	timestamp				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 of the TERMINATED_TS field, to the G_TIMECODE table.
LastChange	timestamp		X		The GMT-equivalent date and time of the last state change of the party.
LastChange_ts	integer				The UTC-equivalent value of the LASTCHANGED field.
LastChange_tcode	integer				A reference, derived from the value of the LASTCHANGED_TS field, to the G_TIMECODE table.
GSYS_DOMAIN	integer				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	integer				A key that is used for partitioning.
GSYS_SYS_ID	integer				System ID. Reserved for future use.
GSYS_SEQ	bigint				Insert Sequence. Not unique.
GSYS_USEQ	bigint				Update Sequence. Not unique.
GSYS_TS	timestamp				Reserved
GSYS_TC	integer				Reserved
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	integer				The sequence number of the call (CSEQ) in party creation.
GSYS_EXT_INT2	integer				For third party media interactions, stores a special party index in scope of the interaction lifecycle. This value can be 0 or greater.