1. Description
The table stores information about member distributions from an inbound queue or a contact center dialer.
2. Structure
|
column_name |
data_type |
description |
|---|---|---|
|
id |
bigint |
Unique record identifier. |
|
queue_id |
integer |
Identifier of the queue from which the distribution was made. |
|
member_id |
bigint |
Member identifier. |
|
weight |
integer |
System indicator used in routing. It allows moving a member up the list of those waiting in the queue. Shows the amount of time in seconds added to the current waiting indicator. |
|
resource_id |
integer |
Resource identifier. |
|
node_id |
varchar(20) |
System indicator. Identifier of the service that handles this distribution. |
|
result |
varchar(25) |
See the list of possible results here. |
|
agent_id |
integer |
Identifier of the Agent. |
|
bucket_id |
bigint |
Identifier of the bucket. |
|
display |
varchar(50) |
Number displayed to the member. The number can be set in the resource settings. |
|
description |
varchar |
Text the Agent entered in the Description field when simple processing (without a schema) is enabled. |
|
list_communication_id |
bigint |
If a Stop list is set on the General tab and contains this member’s number, this field shows the identifier of the member’s number record in the stop list. Such a member is not connected to an Agent. |
|
joined_at |
timestamp with time zone |
Time this distribution was created (time of joining the queue). |
|
leaving_at |
timestamp with time zone |
Time of leaving the queue. |
|
agent_call_id |
varchar |
Distribution identifier on the Agent side. |
|
member_call_id |
varchar |
Distribution identifier on the member side. |
|
offering_at |
timestamp with time zone |
Start time of the connection with side B. Side B depends on the queue type. Filled in for all queues except the Outbound Task Queue. |
|
reporting_at |
timestamp with time zone |
Processing end time. |
|
bridged_at |
timestamp with time zone |
Time side A was connected to side B. |
|
channel |
varchar |
Channel. Possible values:
|
|
domain_id |
bigint |
Domain identifier. |
|
destination |
jsonb |
Member contact details specified in the Destination field. |
|
seq |
integer |
Sequence number of the connection attempt with the member. Attempts for all member contact details are counted. |
|
team_id |
integer |
Identifier of the team of the Agent currently connected to the member. |
|
resource_group_id |
integer |
Identifier of the resource group selected in the queue settings. |
|
answered_at |
timestamp with time zone |
Member answer time. Filled in for the Predictive Dialer. |
|
region_id |
integer |
Identifier of the region where the Agent works. |
|
transferred_at |
timestamp with time zone |
Time of transfer to another Agent. |
|
transferred_agent_id |
integer |
Identifier of the Agent to whom the call was transferred. |
|
transferred_attempt_id |
bigint |
Identifier of the attempt to connect the Agent with another Agent during a consultative transfer. |
|
parent_id |
bigint |
Identifier of the member’s first distribution to a queue. Filled in when the member was transferred to another queue during a single connection with the system. |
|
form_fields |
jsonb |
JSON schema of the data the Agent entered in the form (dynamic windows). Displayed when processing with a schema is enabled. |
|
import_id |
varchar(120) |
Identifier of the file the member was uploaded from. Displayed when member data is uploaded by importing a file. |
2.1. Result
|
Name |
Description |
|---|---|
|
abandoned |
Abandoned, no further call is expected. |
|
agent_timeout |
For chat queues: the Agent response time has expired (see Agent response timeout). |
|
client_timeout |
For chat queues: the member response time has expired (see Customer response timeout). |
|
dialog_timeout |
For chat queues: the chat response time has expired (see Maximum response timeout). |
|
cancel |
The member dropped the call. |
|
missed |
Missed. |
|
timeout |
Time expired. |
|
failed |
Lost, the call was not connected to an Agent. |
|
endless |
The call is not finished; appears when the Endless switch is enabled. |
|
success |
Successful. |
|
transferred |
Transferred to another Agent or queue. |
|
shutdown |
Maintenance or system failure (contact center restart). |