Jump to: navigation, search

In the Column List:

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

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.

Column List

Legend

Column Data Type P M F Description

ID

NUMBER(16) X X The unique, autonumbered ID of the party record. This is the primary key.

PartyID

VARCHAR2(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

VARCHAR2(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

VARCHAR2(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

VARCHAR2(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

VARCHAR2(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. Refer to G_Dictionary Values for a listing of permissible values.


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. Refer to G_Dictionary Values for a listing of permissible values.


#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. Refer to G_Dictionary Values for a listing of permissible values.


#DICTIONARY TYPE 31

Created

TIMESTAMP(3) 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(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 of the TERMINATED_TS field, to the G_TIMECODE table.

LastChange

TIMESTAMP(3) 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.

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) The value of the LastTransferHomeLocation TEvent attribute.

GSYS_EXT_VCH2

VARCHAR2(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.


Index List

Index Name U C

IDX_G_PARTY_PPID

IDX_G_PARTY_PID

X

IDX_G_PARTY_GE_INT_CID

X

 

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 31 October 2016, at 15:33.