Tables in the PBX Database

When you query your Cloud Voice phone system’s database directly, the data you read comes from the tables described here. This reference covers the tables that hold call detail records (CDRs), queue activity, call transcriptions, and other call-related data, and lists the fields in each one along with what they contain.

Caution

Many columns exist only to support the system’s internal operation. They are marked Reserved for internal use, and their contents and format can change between releases without notice. Build reports and integrations on the documented fields only.

Abbreviations used in this reference

Several field descriptions use these terms:

• CDR (call detail record): one row describing a call or a single leg of a call.
• DID (Direct Inward Dialing): the phone number an outside caller dials to reach the system.
• DOD (Direct Outward Dialing): the number presented as the caller ID on outbound calls.
• IVR (Interactive Voice Response): the automated menu that asks the caller to press a key.
• SIP (Session Initiation Protocol): the signaling protocol used to set up calls. A SIP URI identifies a calling or called endpoint.
• STIR/SHAKEN: the caller-ID authentication framework. The attestation level records how strongly the caller’s number was verified.
• CRM (Customer Relationship Management): an external contact and sales system that calls can be linked to.

agent_misscall_unread

Tracks unread missed calls for queue agents.

Field	Description
id	Reserved for internal use.
unique_id	Reserved for internal use.
agent_id	Reserved for internal use.
queue_num	Queue number.
agent_num	Agent’s extension number.
is_read	Whether the missed-call record has been marked as read.

call_note

Stores notes that agents add to calls.

Field	Description
id	Reserved for internal use.
group_id	Reserved for internal use.
agent_id	Reserved for internal use.
create_time	Reserved for internal use.
registration_time	Reserved for internal use.
agent_name	Agent’s name.
remark	Free-text note.

call_note_disposition_code

Links call notes to their disposition codes.

Field	Description
disposition_code_id	Reserved for internal use.
call_note_id	Reserved for internal use.

cdr

The primary call detail record for each call leg.

Which table should you query?

For most reports and dashboards, read from cdr_basic (one summarized row per call) or cdr_cleaned (per-call rows with ready-made metrics and status flags such as answered and missed). The cdr table holds the raw, per-leg records that feed those summaries, so it carries the most detail but is harder to aggregate.

Field	Description
id	Reserved for internal use.
datetime	Date and time of the record.
timestamp	Reserved for internal use.
uid	Reserved for internal use.
clid	Reserved for internal use.
src	Caller’s number.
srcname	Caller’s name.
srcaddr	Reserved for internal use.
dst	Callee’s number.
dstname	Callee’s name.
dcontext	Reserved for internal use.
channel	Reserved for internal use.
dstchannel	Reserved for internal use.
srctrunk	Trunk the call originated from.
dsttrunk	Trunk the call was routed out on.
lastapp	Reserved for internal use.
lastdata	Reserved for internal use.
duration	Total length of the call.
ringduration	How long the call rang.
talkduration	How long the parties were connected on the call.
disposition	Outcome of the call.
amaflags	Reserved for internal use.
calltype	Type of communication.
accountcode	PIN (account) code used for the call.
uniqueid	Reserved for internal use.
didnumber	DID number.
dodnumber	DOD number.
recordfile	File name of the recording.
recordpath	Full path to the recording, including the file name.
srcchanurl	Caller’s SIP URI.
dstchanurl	Callee’s SIP URI.
reasonpartya	Reserved for internal use.
reasonpartyb	Reserved for internal use.
reasonpartyc	Reserved for internal use.
reasonpartyd	Reserved for internal use.
reasonpartye	Reserved for internal use.
reasonpartyf	Reserved for internal use.
displayonweb	Reserved for internal use.
src_del_cdr	Reserved for internal use.
dst_del_cdr	Reserved for internal use.
src_del_recording	Reserved for internal use.
dst_del_recording	Reserved for internal use.
srcnameprefix	Reserved for internal use.
dstnameprefix	Reserved for internal use.
misscall_isread	Reserved for internal use.
in2outbound	Reserved for internal use.
concurrentcalls	Reserved for internal use.
videocall	Reserved for internal use.
rascall	Reserved for internal use.
tryvideocall	Reserved for internal use.
amount	Cost charged for the call.
rate_id	Reserved for internal use.
displayonext	Reserved for internal use.
dstexten	Reserved for internal use.
callflow	Reserved for internal use.
callflownumber	Reserved for internal use.
holdduration	How long the call was held.
press_timeout	How many times the caller let the prompt time out without pressing a key.
press_invalid	How many times the caller pressed an invalid key.
press	Key the caller pressed.
groupid	Reserved for internal use.
reasonpartyg	Reserved for internal use.
reasonpartyh	Reserved for internal use.
reasonpartyi	Reserved for internal use.
process_ext	Extension of the operator who set the processing result.
process_time	When the operator set the processing result.
ivrdst	Reserved for internal use.
linkedid	Reserved for internal use.
attended_requestor	Reserved for internal use.
is_auto_fill_0	Reserved for internal use.
contactname	Reserved for internal use.
contacttype	Reserved for internal use.
campaign_id	Reserved for internal use.
target_id	Reserved for internal use.
task_id	Reserved for internal use.
target_source	Reserved for internal use.
number_encryption_object	Reserved for internal use.
cdrid	Reserved for internal use.
enb_call_note	Reserved for internal use.
record_custom_code	Reserved for internal use.
auto_sync_process_result	Auto-sync state for processing results across repeat calls.
shakenattestation	Reserved for internal use.

cdr_basic

A condensed, per-call summary of call detail records used for reporting.

Field	Description
id	Reserved for internal use.
tenant_id	Reserved for internal use.
uid	Reserved for internal use.
timestamp	Reserved for internal use.
datetime	Date and time of the record.
src	Caller’s number.
srcname	Caller’s name.
dst	Callee’s number.
dstname	Callee’s name.
second_dst	Callee’s number on the second leg of the call.
second_dstname	Callee’s name on the second leg of the call.
last_dst	Callee’s number on the final leg of the call.
last_dstname	Callee’s name on the final leg of the call.
disposition	Outcome of the call.
call_duration	Length of the call.
routing_duration	Elapsed time from the call starting to being answered.
ivr_duration	Time the call spent in the IVR.
callflow_duration	Time the call spent in the call flow.
wait_duration	Elapsed time from the call starting to being answered.
handling_duration	Time from answer to hang-up, including any hold and wrap-up time.
talk_duration	Time from answer to hang-up.
hold_duration	How long the call was held.
wrap_duration	Time the agent spent on post-call wrap-up.
call_type	Type of communication.
call_note	Reserved for internal use.
queues	Reserved for internal use.
ringgroups	Reserved for internal use.
ivrs	Reserved for internal use.
callflows	Reserved for internal use.
campaigns	Reserved for internal use.
disconnect_by	Which party ended the call.
segments	Number of legs in the call.
has_recording	Whether the call has an associated recording.
srcnameprefix	Reserved for internal use.
dstnameprefix	Reserved for internal use.
second_calltype	Communication type on the second leg of the call.
second_dstnameprefix	Reserved for internal use.
last_calltype	Communication type on the final leg of the call.
last_dstnameprefix	Reserved for internal use.
last_callflow	Name of the call feature used on the final leg.
last_callflownumber	Number of the call feature used on the final leg.
enb_timeline	Whether the call timeline is enabled.
first_contact_name	Contact name on the first leg of the call.
first_contact_type	Contact type on the first leg of the call.
wrapup_ts	Reserved for internal use.

cdr_cleaned

A processed set of call detail records with derived metrics for analytics.

Field	Description
id	Reserved for internal use.
tenant_id	Reserved for internal use.
uid	Reserved for internal use.
cdrid	Reserved for internal use.
another_uid	Reserved for internal use.
group_cdrid	Reserved for internal use.
rate_id	Reserved for internal use.
is_group	Reserved for internal use.
group_id	Reserved for internal use.
flag	Reserved for internal use.
timestamp	Reserved for internal use.
start_ts	Reserved for internal use.
datetime	Date and time of the record.
src	Caller’s number.
dst	Callee’s number.
dstexten	Reserved for internal use.
srctrunk	Trunk the call originated from.
dsttrunk	Trunk the call was routed out on.
didnumber	DID number.
dodnumber	DOD number.
call_flow	Name of the call feature involved.
call_flow_number	Number of the call feature involved.
call_type	Type of communication.
disposition	Outcome of the call.
answered	Whether the call was answered.
missed	Whether the call was missed.
abandoned	Whether the caller hung up before being answered.
no_answer	Whether the call went unanswered.
busy	Whether the call returned busy.
failed	Whether the call failed.
vm	Whether the call was sent to voicemail.
duration	Total length of the call.
talk_duration	Time from answer to hang-up.
ring_duration	Elapsed time from the call starting to being answered.
answered_ring_duration	For answered calls, the time from the call starting to being answered.
hold_duration	How long the call was held.
wrapup_duration	Time the agent spent on post-call wrap-up.
press_key	Key the caller pressed.
concurrent	Peak number of simultaneous calls.
amount	Cost charged for the call.
satisfaction	Score returned by the satisfaction survey.
transfer_dest	Destination the call was transferred to.
is_qcb	Whether the call is a queue callback.
qcb_status	Status of the callback.
qcb_failed_reason	Reason the queue callback failed.
opr_duration	Time spent handling IVR input.
member_answerd_count	Number of queue calls answered by agents.
member_hold_duration	Time agents kept queue calls on hold.
qcb_time	When the agent placed the callback.
qcb_number	Number that requested the callback.
srcname	Caller’s name.
dstname	Callee’s name.
dstnameprefix	Reserved for internal use.
member_answered_number	Extension of the internal user who answered the call.
is_display	Reserved for internal use.
member_answered_name	Name of the member who answered the call.
member_answered_count	Number of calls answered by members.
source_src	Caller’s number on the first leg of the call.
source_srcname	Caller’s name on the first leg of the call.
shaken	STIR/SHAKEN attestation level.
member_answer_ringduration	For answered calls, the time from the call starting to being answered.
member_polling_attemps	Number of attempts made to reach an agent.
join_announcement_duration	Length of the join announcement.

cdr_clip

Per-leg call detail records retained for call clips and recordings.

Field	Description
id	Reserved for internal use.
tenant_id	Reserved for internal use.
uid	Reserved for internal use.
clid	Reserved for internal use.
uniqueid	Reserved for internal use.
linkedid	Reserved for internal use.
cdrid	Reserved for internal use.
datetime	Date and time of the record.
timestamp	Reserved for internal use.
src	Caller’s number.
srcname	Caller’s name.
srcnameprefix	Reserved for internal use.
dst	Callee’s number.
dstname	Callee’s name.
dstnameprefix	Reserved for internal use.
channel	Reserved for internal use.
dstchannel	Reserved for internal use.
srctrunk	Trunk the call originated from.
dsttrunk	Trunk the call was routed out on.
duration	Total length of the call.
ringduration	How long the call rang.
talkduration	How long the parties were connected on the call.
holdduration	How long the call was held.
wrapduration	Time the agent spent on post-call wrap-up.
disposition	Outcome of the call.
calltype	Type of communication.
didnumber	DID number.
dodnumber	DOD number.
recordfile	File name of the recording.
recordpath	Full path to the recording, including the file name.
amount	Cost charged for the call.
rate_id	Reserved for internal use.
accountcode	PIN (account) code used for the call.
callflow	Reserved for internal use.
callflownumber	Reserved for internal use.
groupid	Reserved for internal use.
enb_call_note	Reserved for internal use.
scenario	Reserved for internal use.
scenario_primary_id	Reserved for internal use.
scenario_secondary_id	Reserved for internal use.
displayonweb	Reserved for internal use.
displayonext	Reserved for internal use.
concurrencys	Current number of simultaneous calls.
number_encryption_object	Reserved for internal use.
srcaddr	Reserved for internal use.
srcchanurl	Reserved for internal use.
dstchanurl	Reserved for internal use.
videocall	Reserved for internal use.
rascall	Reserved for internal use.
tryvideocall	Reserved for internal use.
src_del_cdr	Reserved for internal use.
dst_del_cdr	Reserved for internal use.
src_del_recording	Reserved for internal use.
dst_del_recording	Reserved for internal use.
finish_call	Reserved for internal use.
transactionid	Reserved for internal use.
dcontext	Reserved for internal use.
shakenattestation	Reserved for internal use.
shakenrejectreason	Reserved for internal use.
start_ts	Reserved for internal use.
join_announcement_duration	Length of the join announcement.

cdr_extend

Holds extended attributes that supplement a call detail record.

Field	Description
id	Reserved for internal use.
tenant_id	Reserved for internal use.
uid	Reserved for internal use.
cdrid	Reserved for internal use.
another_uid	Reserved for internal use.
timestamp	Reserved for internal use.
is_auto_fill_0	Reserved for internal use.
contactname	Reserved for internal use.
contacttype	Reserved for internal use.
record_custom_code	Reserved for internal use.
dstexten	Reserved for internal use.

cdr_process

Records how queue calls were processed and by whom.

Field	Description
id	Reserved for internal use.
uid	Reserved for internal use.
tenant_id	Reserved for internal use.
cdrid	Reserved for internal use.
linkedid	Reserved for internal use.
timestamp	Reserved for internal use.
queue	Queue number.
process_result	Processing result recorded for the queue call.
process_ext	Extension of the operator who set the processing result.
process_time	When the operator set the processing result.
auto_sync_process_result	Auto-sync state for processing results across repeat calls.

cdr_timeline

Stores the sequence of events that make up a call’s timeline.

Field	Description
id	Reserved for internal use.
tenant_id	Reserved for internal use.
uid	Reserved for internal use.
cdrid	Reserved for internal use.
event_time	Date and time of the record.
timestamp	Reserved for internal use.
event_type	Type of call event.
event_name	Name of the call event.
event_content	Details of the call event.

dyncrm_phone_call

Maps calls to activities logged in a connected CRM.

Field	Description
id	Reserved for internal use.
cdrid	Reserved for internal use.
crm_id	Reserved for internal use.
act_id	Reserved for internal use.
create_time	Reserved for internal use.

personal_misscall_count

Tracks each extension’s count of unread missed calls.

Field	Description
id	Reserved for internal use.
ext_num	Extension number.
unread_count	Count of unread missed calls.

queue_log

Low-level event log for queue activity.

Field	Description
id	Reserved for internal use.
callid	Reserved for internal use.
queueid	Reserved for internal use.
time	Reserved for internal use.
timestamp	Reserved for internal use.
queuename	Reserved for internal use.
agent	Reserved for internal use.
event	Reserved for internal use.
data1	Reserved for internal use.
data2	Reserved for internal use.
data3	Reserved for internal use.
data4	Reserved for internal use.
data5	Reserved for internal use.
data6	Reserved for internal use.

queue_miss_call

Records missed calls that came through queues.

Field	Description
id	Reserved for internal use.
uniqueid	Reserved for internal use.
caller_id	Reserved for internal use.
linked_id	Reserved for internal use.
cdr_id	Reserved for internal use.
new_cdrid	Reserved for internal use.
new_id	Reserved for internal use.
timestamp	Reserved for internal use.
src	Caller’s number.
ext_num	Extension number.
dod_number	DOD number.
call_flow_number	Number of the call feature involved.
number_encryption_object	Reserved for internal use.
talk_duration	Time from answer to hang-up.
call_type	Type of communication.
disposition	Outcome of the call.
dcontext	Reserved for internal use.
clid	Reserved for internal use.
reason_partya	Reserved for internal use.
ring_duration	Elapsed time from the call starting to being answered.
is_read	Whether the missed-call record has been marked as read.
process_ext	Extension of the operator who set the processing result.
process_time	When the operator set the processing result.
process_result	Processing result recorded for the queue call.
auto_sync_process_result	Auto-sync state for processing results across repeat calls.

transcription_meta

Metadata for call transcriptions.

Field	Description
id	Reserved for internal use.
call_id	Reserved for internal use.
ext_id	Reserved for internal use.
created_at	Reserved for internal use.
used	Whether the transcription has been used.
language	Language of the transcription.

transcription_record

Stores the transcribed content of calls.

Field	Description
id	Reserved for internal use.
call_id	Reserved for internal use.
timestamp	Reserved for internal use.
created_at	Reserved for internal use.
duration	Reserved for internal use.
type	Reserved for internal use.
source_number	Source number the transcription is for.
content	Text of the transcription.

transcription_summary

Stores AI-generated summaries of transcribed calls.

Field	Description
id	Reserved for internal use.
call_id	Reserved for internal use.
ext_id	Reserved for internal use.
created_at	Reserved for internal use.
updated_at	Reserved for internal use.
summary	AI-generated summary of the call.

transcription_visibility

Controls which extensions can view a transcription.

Field	Description
id	Reserved for internal use.
transcription_record_id	Reserved for internal use.
visible_ext_id	Reserved for internal use.
visible	Reserved for internal use.
call_id	Reserved for internal use.

trunk_concurrent

Records peak concurrent-call counts per trunk.

Field	Description
id	Reserved for internal use.
timestamp	Reserved for internal use.
datetime	Date and time of the record.
trunk	Name of the trunk.
call_type	Type of communication.
concurrent	Peak number of simultaneous calls on the trunk.