Jump to: navigation, search

In the Column List:

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

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 bigserial 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 integer X The DBID of the virtual queue where the interaction was queued.
VQSwitchID integer 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 integer Reserved for future use.
OrigDNType integer Reserved for future use.
OrigDN varchar(255) Reserved for future use.
OrigDNID integer Reserved for future use.
OrigObjType integer Reserved for future use.
TargetCallID varchar(50) Reserved for future use.
TargetSwitchID integer Reserved for future use.
TargetDNType integer Reserved for future use.
TargetDN varchar(255) The destination endpoint name of the routing target.
TargetDNID integer Reserved for future use.
TargetObjType integer Reserved for future use.
DistCallID varchar(50) The call ID of the interaction prior to distribution to the routing target or abandonment.
DistSwitchID integer Reserved for future use.
DistDNType integer Reserved for future use.
DistDN varchar(255) Reserved for future use.
DistDNID integer Reserved for future use.
DistObjType integer Reserved for future use.
VQExtVCH1 varchar(50) Reserved for future use.
VQExtVCH2 varchar(50) Reserved for future use.
Status integer X The current status of the virtual queue record, represented by one of the Call Control Event dictionary types. For a listing of permissible values, refer to G_Dictionary Values (for DB2Microsoft SQL Server, Oracle, or PostgreSQL, respectively).


#DICTIONARY TYPE 30

Cause integer X The cause leading to the status change in the association between the call interaction and the virtual queue. For a listing of permissible values, refer to G_Dictionary Values (for DB2Microsoft SQL Server, Oracle, or PostgreSQL, respectively).


#DICTIONARY TYPE 85

Created timestamp X The GMT-equivalent date and time when the record was created, as inherited from the EventQueued TEvent.
Created_ts integer X The UTC-equivalent value of the CREATED field.
Created_tcode integer X A reference, derived from the value of the CREATED_TS field, to record in G_TIMECODE table.
Terminated timestamp The GMT-equivalent date and time when the record was terminated, as inherited from either the EventDiverted or EventAbandoned TEvents.
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 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 (for DB2Microsoft SQL Server, Oracle, or PostgreSQL, respectively).
GSYS_PARTITION integer A key used for partitioning.
GSYS_SYS_ID integer 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 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_INT1 integer Reserved for future use.
GSYS_EXT_INT2 integer 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