Webitel: Documentation

cc_member_attempt

1. Description

The table stores information about active distributions of members from an inbound queue or a contact center dialer.

2. Structure

column_name

data_type

description

id

bigint

Active distribution identifier.

queue_id

integer

Identifier of the queue from which the distribution occurs.

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

character varying

System indicator. Identifier of the service that handles this distribution.

result

character varying

See the list of possible results here.

agent_id

integer

Identifier of the Agent.

bucket_id

bigint

Identifier of the bucket.

display

character varying

Number displayed to the member. The number can be set in the resource settings.

description

character varying

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

character varying

Distribution identifier on the Agent side.

member_call_id

character varying

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.

state

character varying

Current state at the time of viewing. See the possible values here.

bridged_at

timestamp with time zone

Time side A was connected to side B.

channel

character varying

Channel. Possible values:
call – call;
chat – chat;
task – task.

timeout

timestamp with time zone

System indicator. Filled in when processing is enabled in the queue settings and the connection with the member has ended. Shows the expected processing end time.

last_state_change

timestamp with time zone

Time of the last state change.

communication_idx

integer

System indicator. Position index of the member’s communication type record.

resource_group_id

integer

Identifier of the resource group selected in the queue settings.

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.

answered_at

timestamp with time zone

Member answer time. Filled in for the Predictive Dialer.

team_id

number

Identifier of the team of the Agent currently connected to the member.

sticky_agent_id

number

Identifier of the Agent assigned to the member.

domain_id

number

Domain identifier.

transferred_at

time

Time of transfer to another Agent.

transferred_agent_id

number

Identifier of the Agent to whom the call was transferred.

transferred_attempt_id

number

Identifier of the attempt to connect the Agent with another Agent during a consultative transfer.

parent_id

number

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.

waiting_other_numbers

number

Number of the member’s numbers that still need to be served.

form_fields

jsonb

JSON schema of the data the Agent entered in the form (dynamic windows). Displayed when processing with a schema is enabled.

form_view

jsonb

JSON schema of the dynamic window. Displayed when processing with a schema is enabled.

import_id

string

Identifier of the file the member was uploaded from. Displayed when member data is uploaded by importing a file.

schema_processing

boolean

System indicator that keeps the attempt from moving to History until the post-dial schema finishes.
When the After-executive schema starts after the processing timeout ends, the value becomes true.
For the attempt to move to History, leaving_at must be filled in and this field must be false.
After the schema finishes, the value becomes false.

queue_params

jsonb

System field.

2.1. States

State availability in queues:

Name

Description

Offline Queue

Inbound Queue

Outbound IVR Queue

Preview Dialer

Progressive Dialer

Predictive Dialer

Chat Inbound Queue

Inbound Task Queue

Outbound Task Queue

idle

Initial state, lasts a fraction of a second

+

-

+

+

+

+

-

+

+

waiting

Waiting for connection with the member

-

-

-

-

-

+

-

-

-

waiting_agent

Waiting for an available Agent

-

+

-

-

-

+

+

-

-

offering

Distribution

attempt to connect with the member

attempt to connect with the Agent

attempt to connect with the member

attempts to connect with the Agent and with the member

attempts to connect with the Agent and with the member

attempt to connect with the Agent

attempt to connect with the Agent

attempt to connect with the Agent

-

bridged

The Agent is handling a call, chat, or task

+

+

+

+

+

+

+

+

+

leaving

End of service

+

+

+

+

+

+

+

+

+

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