Jump to: navigation, search

In the Column List:

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

Table G_ROUTE_RES_VQ_HIST


This table contains information about the use of virtual queues in interaction processing, according to the data passed from the Universal Routing Server through the T-Server or Interaction Server application.

Column List

Legend

Column Data Type P M F Description

ID

NUMERIC(16) X X The unique, autonumbered ID of the record. This is the primary key. Autonumbering is controlled by the RDBMS.

PartyID

VARCHAR(50) X The ID of the party that is associated with the routing point/strategy.

CallID

VARCHAR(50) X The unique ID of the interaction.

VQID

VARCHAR(50) X Uniquely identifies each virtual queue record, as it is reported by URS in attached user data.

VQSeq

INTEGER X Local VQ sequence of VQ associated with the PARTY of type RoutingPoint/Strategy, numbered sequentially from 0 to N - 1, where N is the last VQ reported by URS, related to specific Route Result.

Added

TIMESTAMP X The GMT-equivalent date and time of the record, based on time provided by T-Server/Interaction Server in notification events.

Added_ts

INTEGER The UTC-equivalent of the value of the ADDED field.

Added_tcode

INTEGER A reference, derived from the value of the ADDED_TS field, to a record in 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 used for partitioning.

GSYS_SYS_ID

INTEGER System ID.

GSYS_SEQ

BIGINT The non-unique sequence number of the statements to be inserted into the database.

GSYS_USEQ

BIGINT Reserved.

GSYS_TS

TIMESTAMP Reserved for future use.

GSYS_TC

INTEGER Reserved for future use.

GSYS_EXT_VCH1

VARCHAR(255) Reserved for future use.

GSYS_EXT_VCH2

VARCHAR(255) Reserved for future use.

GSYS_EXT_VCH3

VARCHAR(255) Reserved for future use.

GSYS_EXT_VCH4

VARCHAR(255) Reserved for future use.

GSYS_EXT_INT1

INTEGER Reserved for future use.

GSYS_EXT_INT2

INTEGER Reserved for future use.

GSYS_EXT_INT3

INTEGER Reserved for future use.

GSYS_EXT_INTEGER

INTEGER Reserved for future use.


Index List

Index Name U C

IDX_G_R_RES_VQ_H

X

 

 

Feedback

Comment on this article:

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