cdr/COPM3/dialogs

A collection of CDR records to populate the CONNECTION_VOIP table to provide SORM-3.

Contains only successful calls that ended in a conversation - one record with aggregated information for each dialog.

Served by microservice callstore. Population occurs if the active microservice instance has the options 'cdr_enabled' and 'sorm3_enabled'.

Storage Type: history.

Table 1. Class fields
Field Type Description

begin_time

datetime

Start time of the call

end_time

datetime

End time of the call

client_ipv4

string

IP-caller’s address

client_ip_port

integer

Conversation initiator port

protocol_code

integer

5060.

session_id

string

Call-ID of the call initiator. If the call came from an external caller (via the provider), this is the Call-ID of the external arm (between the ESG and the provider), otherwise it is the Call-ID of party A on the microservice B2B.

duration

integer

Talk time in seconds

call_type_id

integer

Call Type. Options:

  • 1 - internal

  • 2 - incoming

  • 3 - outgoing

  • 4 - transit

  • 5 - cross

calling_original_number

string

Originating number of the call initiator subscriber

calling_translated_number

string

Converted number of the call initiator subscriber

called_original_number

string

Initial number to be dialed

called_translated_number

string

Converted dialed number

fax

boolean

An indication of an attempt to switch to a fax session using the protocol T.38

term_cause

integer

Reason for ending the conversation. Options:

  • 1 - bye_a

  • 2 - bye_b

  • 3 - cancel

  • 4 - call_final

  • 5 - timeout

  • 6 - error

  • 7 - call_terminate

  • 1000 - dead

  • 1001 - external

  • 1002 - unknown

gateway_ip4

string

IP-the address of the media gateway handling the call

invite_id

string

Unique call identifier (on B2B)

invite_ts

long

Call timestamp (on B2B)

acallid

string

Call-ID call initiator (on B2B)

bcallid

string

Call-ID of the triggered arm (at B2B)

record_link

string

Link to call recording if available

transcript

any

Subject with the results of stenography if available