Webitel: Documentation

cc_calls_history

Description

The table stores the communication history. After a call ends, its record is moved from the cc_calls table.

Structure

column_name

data_type

description

id

uuid

Unique record identifier.

direction

character varying

Enumeration “Call direction”.

destination

character varying

Destination number. The number dialed on the device.

parent_id

uuid

Reference to the main record key in this table. If the field is empty, this record is the A-leg of the call. If the field is filled in, this record is the B-leg of the call.

app_id

character varying

System field. Identifier of the service through which the call is made.

from_type

character varying

Type of the call initiator: user, member, dest.

from_name

character varying

Call initiator name.

from_number

character varying

Call initiator number.

from_id

character varying

User identifier key (see wbt_user) if the call initiator is a system user.

to_type

character varying

Type of the call recipient: user, member, dest.

to_name

character varying

Call recipient name.

to_number

character varying

Call recipient number.

to_id

character varying

User identifier key (see wbt_user) if the call recipient is a system user.

payload

jsonb

JSON object that stores variables from routing.

domain_id

bigint

Domain identifier.

hold_sec

integer

Total time on hold, in seconds.

cause

character varying

Enumeration with the call termination reason (see Hangup cause).

sip_code

integer

SIP response code.

bridged_id

uuid

Reference to the main record key in this table with which the connection was established.

user_id

integer

User identifier key (see wbt_user) if the call initiator is a system user.

gateway_id

bigint

Gateway identifier key (see sip_gateway).

queue_id

integer

Queue identifier key (see cc_queue).

agent_id

integer

Agent identifier key (see cc_agent).

team_id

integer

Team identifier key (see cc_team).

attempt_id

bigint

Dialer attempt identifier key (see cc_member_attempt).

member_id

bigint

Dialer member identifier key (see cc_member).

answered_at

timestamp with time zone

Date and time (with time zone) the call was answered (start of call billing).

bridged_at

timestamp with time zone

Date and time (with time zone) the record was bridged (answered by the B-leg).

hangup_at

timestamp with time zone

Date and time (with time zone) the call ended.

created_at

timestamp with time zone

Date and time (with time zone) the call was created.

stored_at

timestamp with time zone

Date and time (with time zone) the call was stored.

hangup_by

character varying

Who ended the call (A/B).

transfer_from

uuid

Reference to the main record key in this table from which the call was transferred.

transfer_to

uuid

Reference to the main record key in this table to which the call was transferred.

amd_result

character varying

AMD result (HUMAN/MACHINE/NOTSURE).

amd_duration

interval

AMD processing time.

tags

ARRAY

Call tags.

grantee_id

bigint

System field. Identifier of the user group that has access to this call.

hold

jsonb

Array of information about holds of this call.

agent_ids

ARRAY

Array of identifiers of Agents who interacted with this call.

user_ids

ARRAY

Array of identifiers of users who interacted with this call.

queue_ids

ARRAY

Array of identifiers of queues that interacted with this call.

gateway_ids

ARRAY

Array of identifiers of gateways that interacted with this call.

team_ids

ARRAY

Array of identifiers of teams that interacted with this call.

params

jsonb

System field.

blind_transfer

character varying

Number to which a blind transfer is made.

talk_sec

integer

Talk time in seconds.

amd_ai_result

character varying

AI AMD result.

amd_ai_logs

ARRAY

Array of detection variants for this call.

amd_ai_positive

boolean

true – the AI AMD detection result matches the positive labels; false – the AI AMD detection result does not match the positive labels.

contact_id

bigint

Contact identifier.

search_number

text

System field. Numbers used for search.

hide_missed

boolean

true – the missed call is not displayed in Workspace; false – the missed call is displayed in Workspace.

redial_id

uuid

Identifier of the call being redialed.

schema_ids

ARRAY

Array of identifiers of schemas used in this call.