Webitel: Documentation

cc_member_attempt_history

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:
call – call;
chat – chat;
task – task.

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