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 |
|
|
contact_id |
bigint |
Contact identifier. |
|
search_number |
text |
System field. Numbers used for search. |
|
hide_missed |
boolean |
|
|
redial_id |
uuid |
Identifier of the call being redialed. |
|
schema_ids |
ARRAY |
Array of identifiers of schemas used in this call. |