Jump to: navigation, search

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.

Table G_VIRTUAL_QUEUE


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 application.

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 numeric(16) X X The unique, autonumbered ID of the virtual queue record. This is the primary key. Autonumbering is controlled by the RDBMS.
VQID varchar(50) X Uniquely identifies each virtual queue record, corresponding to the EventQueued/EventDiverted or EventQueued/EventAbandoned pairs of TEvents.
VQDN varchar(255) X The directory number of the virtual queue, as configured in Configuration Server, where the interaction was queued.
VQDNID int X The DBID of the virtual queue where the interaction was queued.
VQSwitchID int X The DBID of the switch where the virtual queue is configured.
OrigCallID varchar(50) X The reference to the original call, by CALLID, for which the EventQueued TEvent was reported.
OrigSwitchID int Reserved for future use.
OrigDNType int Reserved for future use.
OrigDN varchar(255) Reserved for future use.
OrigDNID int Reserved for future use.
OrigObjType int Reserved for future use.
TargetCallID varchar(50) Reserved for future use.
TargetSwitchID int Reserved for future use.
TargetDNType int Reserved for future use.
TargetDN varchar(255) The destination endpoint name of the routing target.
TargetDNID int Reserved for future use.
TargetObjType int Reserved for future use.
DistCallID varchar(50) The call ID of the interaction prior to distribution to the routing target or abandonment.
DistSwitchID int Reserved for future use.
DistDNType int Reserved for future use.
DistDN varchar(255) Reserved for future use.
DistDNID int Reserved for future use.
DistObjType int Reserved for future use.
VQExtVCH1 varchar(50) Reserved for future use.
VQExtVCH2 varchar(50) Reserved for future use.
Status int X The current status of the virtual queue record, represented by one of the Call Control Event dictionary types. Refer to G_Dictionary Values for a listing of permissible values.


#DICTIONARY TYPE 30

Cause int X The cause leading to the status change in the association between the call interaction and the virtual queue. Refer to G_Dictionary Values for a listing of permissible values.


#DICTIONARY TYPE 85

Created datetime X The GMT-equivalent date and time when the record was created, as inherited from the EventQueued TEvent.
Created_ts int X The UTC-equivalent value of the CREATED field.
Created_tcode int X A reference, derived from the value of the CREATED_TS field, to record in G_TIMECODE table.
Terminated datetime The GMT-equivalent date and time when the record was terminated, as inherited from either the EventDiverted or EventAbandoned TEvents.
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 a record in 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.
GSYS_PARTITION int A key used for partitioning.
GSYS_SYS_ID int System ID. Reserved for future use.
GSYS_SEQ bigint The non-unique sequence number of the statements to be inserted into the database.
GSYS_USEQ bigint The non-unique sequence number of the statements to be updated in the database.
GSYS_TS datetime Reserved for future use.
GSYS_TC int Reserved for future use.
GSYS_EXT_VCH1 varchar(255) Reserved for future use.
GSYS_EXT_VCH2 varchar(255) Reserved for future use.
GSYS_EXT_INT1 int Reserved for future use.
GSYS_EXT_INT2 int Reserved for future use.
This page was last edited on January 10, 2020, at 15:27.

Feedback

Comment on this article:

blog comments powered by Disqus