Jump to: navigation, search

In the Column List:

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

Table G_ROUTE_RESULT


This table contains information regarding the results of the routing of a specific interaction, according to the information passed from the Universal Routing Server through either the T-Server or Interaction Server application.

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) X The unique ID of the interaction.

ConnID

VARCHAR2(50) X The T-Server event connection ID. This is preserved for backward compatibility.

PartyID

VARCHAR2(50) X The ID of the party record for the party that is associated with the routing point.

IRID

VARCHAR2(50) Reference to record in interaction hierarchy table (G_IR).

EndPointID

INTEGER The DBID of the routing point device.

RTargetRuleSelected

VARCHAR2(255) A copy of the data that was attached by the URS with the RTargetRuleSelected key.

RTargetObjectSelected

VARCHAR2(255) A copy of the data that was attached by the URS with the RTargetObjectSelected key.

RTargetTypeSelected

INTEGER Route target type. A copy of the data that was attached by the URS with the RTargetTypeSelected key. Refer to G_Dictionary Values for a listing of permissible values.


#DICTIONARY TYPE 29

RTargetAgentSelected

VARCHAR2(255) A copy of the data that was attached by the URS with the RTargetAgentSelected key.

RTargetPlaceSelected

VARCHAR2(255) A copy of the data that was attached by URS with the RTargetPlaceSelected key.

RRequestedSkillComb

VARCHAR2(255) A copy of the data that was attached by URS with the RRequestedSkillCombination key.

RStrategyName

VARCHAR2(255) A copy of the data that was attached by the URS with the RStrategyName key, only present if URS routed the interaction. This strategy name must be less than 256 characters; otherwise, ICON may stop writing interaction records to IDB. If URS did not route the interaction, then the value of this field will be null.

RTenant

VARCHAR2(255) A copy of the data that was attached by the URS with the RTenant key.

DestEndPointDN

VARCHAR2(255) The DN name to which a call is successfully routed; for situations when the routing is unsuccessful, the value is notKnown.

DestEndPointID

INTEGER The DBID of the configured DN to which the interaction is routed.


In a SIP Cluster environment, if the endpoint is not configured in Configuration Layer, the value for this field is 0.

DestEndPointType

INTEGER The routing type of the configured DN to which voice call or Multimedia interaction is successfully routed. Refer to G_Dictionary Values for a listing of permissible values.


#DICTIONARY TYPE 505
In a SIP Cluster environment, if the endpoint is not configured in Configuration Layer, the value for this field is 1.

Result

INTEGER X The result of the routing operation. One of the following values:
  • 0—Unknown–Reserved.
  • 1—Success–The routing was successful.
  • 2—Failure–The routing attempt failed (if a voice call or chat was abandoned, and so on).
  • 102—distributed_to_default–Call was routed to the default destination after the URS timeout expired.
  • 103—routed_by_switch–Call was routed by the switch.
  • 105—other_reasons–The routing was unsuccessful due to some other reasons (unclassified).
  • 133—ixn_server_timeout–Routing timeout expired on Interaction Server (open media interactions only).
  • 134—ixn_taken_out–An interaction was taken (pulled out) from strategy by Interaction Server (open media interactions only).


#DICTIONARY TYPE 28

Duration

INTEGER The duration of the routing dialog.This is the time between party creation (in events such as EventRouteRequest, EventQueued, or EventCallPartyAdded) and termination (in events such as EventRouteUsed, EventAbandoned, EventDiverted, or EventCallPartyDeleted).

Created

TIMESTAMP(3) X The GMT-equivalent date and time when the record was created as inherited from T-Server or Interaction Server.

Created_ts

INTEGER The UTC-equivalent time of the value in the CREATED field.

Created_tcode

INTEGER A reference, derived from the value of the CREATED_TS field, to a record in G_TIMECODE table.

Terminated

TIMESTAMP(3) The GMT-equivalent date and time when the record was terminated, as inherited from T-Server (EventRouteUsed or EventAbandoned TEvents) or Interaction Server.

Terminated_ts

INTEGER The UTC-equivalent time of the value in the TERMINATED field.

Terminated_tcode

INTEGER A reference, derived from the value of the TERMINATED_TS field, to a record in 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 virtual queue's ID, if a virtual queue is configured and provided by URS when it routes call. If reported, the value is the same as G_VIRTUAL_QUEUE.VQID in the related record in the G_VIRTUAL_QUEUE table.

GSYS_EXT_VCH2

VARCHAR2(255) If a virtual queue is configured and reported by URS (Universal Router Server), then, when URS routes call, it attaches parameter "RVQDBID" to call UserData, so this field will store virtual queue's DBID as it is configured in configuration database.

GSYS_EXT_INT1

INTEGER A flag indicating the reliability of the virtual queue's ID stored in the GSYS_EXT_VCH1 field. One of the following values:
  • 0—Unknown–No information about a virtual queue is reported in the corresponding EventRouteUsed.
  • 1—Reliable–The virtual queue's ID that is stored in the field GSYS_EXT_VCH1 is taken from the corresponding EventRouteUsed.
  • 1—Valid in the past–The value of the virtual queue ID stored in the field GSYS_EXT_VCH1 was valid in the past, before a call has been transferred to another Routing Point in a multi-site routing scenario.


#DICTIONARY TYPE 87

GSYS_EXT_INT2

INTEGER Reserved

   

 

Feedback

Comment on this article:

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