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. For a listing of permissible values, refer to G_Dictionary Values (for DB2, Microsoft SQL Server, Oracle, or PostgreSQL, respectively). #DICTIONARY TYPE 30
Cause	int		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 DB2, Microsoft SQL Server, Oracle, or PostgreSQL, respectively). #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 (for DB2, Microsoft SQL Server, Oracle, or PostgreSQL, respectively).
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.