Hi,
We are currently using the default settings for pgq_processors.yml of “cdr_fields: all” but we’ve noticed were not getting the diversion_in/out fields. Is this correct behaviour?
I have noticed this:
cdr_fields: [
‘id’, ‘src_prefix_in’, ‘src_prefix_out’, ‘dst_prefix_in’, ‘dst_prefix_out’, ‘time_start’,
‘time_connect’, ‘time_end’, ‘duration’, ‘customer’, ‘vendor’, ‘destination_fee’,
‘destination_initial_interval’, ‘destination_initial_rate’, ‘destination_next_interval’,
‘destination_next_rate’, ‘customer_price’, ‘orig_call_id’, ‘local_tag’, ‘term_call_id’
]
Am I correct in thinking that those are all the fields that can be passed or are there more that we can add? And if so is there a list of all fields that we can add to the array based on the information we would like to send.
Cheers
James
this is full CDR field list for version 1.8:
id | bigint |
customer_id | integer |
vendor_id | integer |
customer_acc_id | integer |
vendor_acc_id | integer |
customer_auth_id | integer |
destination_id | integer |
dialpeer_id | integer |
orig_gw_id | integer |
term_gw_id | integer |
routing_group_id | integer |
rateplan_id | integer |
destination_next_rate | numeric |
destination_fee | numeric |
dialpeer_next_rate | numeric |
dialpeer_fee | numeric |
time_limit | character varying |
internal_disconnect_code | integer |
internal_disconnect_reason | character varying |
disconnect_initiator_id | integer |
customer_price | numeric |
vendor_price | numeric |
duration | integer |
success | boolean |
profit | numeric |
dst_prefix_in | character varying |
dst_prefix_out | character varying |
src_prefix_in | character varying |
src_prefix_out | character varying |
time_start | timestamp with time zone |
time_connect | timestamp with time zone |
time_end | timestamp with time zone |
sign_orig_ip | character varying |
sign_orig_port | integer |
sign_orig_local_ip | character varying |
sign_orig_local_port | integer |
sign_term_ip | character varying |
sign_term_port | integer |
sign_term_local_ip | character varying |
sign_term_local_port | integer |
orig_call_id | character varying |
term_call_id | character varying |
vendor_invoice_id | integer |
customer_invoice_id | integer |
local_tag | character varying |
destination_initial_rate | numeric |
dialpeer_initial_rate | numeric |
destination_initial_interval | integer |
destination_next_interval | integer |
dialpeer_initial_interval | integer |
dialpeer_next_interval | integer |
destination_rate_policy_id | integer |
routing_attempt | integer |
is_last_cdr | boolean |
lega_disconnect_code | integer |
lega_disconnect_reason | character varying |
pop_id | integer |
node_id | integer |
src_name_in | character varying |
src_name_out | character varying |
diversion_in | character varying |
diversion_out | character varying |
lega_rx_payloads | character varying |
lega_tx_payloads | character varying |
legb_rx_payloads | character varying |
legb_tx_payloads | character varying |
legb_disconnect_code | integer |
legb_disconnect_reason | character varying |
dump_level_id | integer |
auth_orig_ip | inet |
auth_orig_port | integer |
lega_rx_bytes | integer |
lega_tx_bytes | integer |
legb_rx_bytes | integer |
legb_tx_bytes | integer |
global_tag | character varying |
dst_country_id | integer |
dst_network_id | integer |
lega_rx_decode_errs | integer |
lega_rx_no_buf_errs | integer |
lega_rx_parse_errs | integer |
legb_rx_decode_errs | integer |
legb_rx_no_buf_errs | integer |
legb_rx_parse_errs | integer |
src_prefix_routing | character varying |
dst_prefix_routing | character varying |
routing_plan_id | integer |
routing_delay | double precision |
pdd | double precision |
rtt | double precision |
early_media_present | boolean |
lnp_database_id | smallint |
lrn | character varying |
destination_prefix | character varying |
dialpeer_prefix | character varying |
audio_recorded | boolean |
ruri_domain | character varying |
to_domain | character varying |
from_domain | character varying |
src_area_id | integer |
dst_area_id | integer |
auth_orig_transport_protocol_id | smallint |
sign_orig_transport_protocol_id | smallint |
sign_term_transport_protocol_id | smallint |
core_version | character varying |
yeti_version | character varying |
lega_user_agent | character varying |
legb_user_agent | character varying |
uuid | uuid |
pai_in | character varying |
ppi_in | character varying |
privacy_in | character varying |
rpid_in | character varying |
rpid_privacy_in | character varying |
pai_out | character varying |
ppi_out | character varying |
privacy_out | character varying |
rpid_out | character varying |
rpid_privacy_out | character varying |
destination_reverse_billing | boolean |
dialpeer_reverse_billing | boolean |
is_redirected | boolean |
customer_account_check_balance | boolean |
customer_external_id | bigint |
customer_auth_external_id | bigint |
customer_acc_vat | numeric |
customer_acc_external_id | bigint |
routing_tag_ids | smallint[] |
vendor_external_id | bigint |
vendor_acc_external_id | bigint |
orig_gw_external_id | bigint |
term_gw_external_id | bigint |
failed_resource_type_id | smallint |
failed_resource_id | bigint |
customer_price_no_vat | numeric |
customer_duration | integer |
vendor_duration | integer |
customer_auth_name | character varying |
Do you have no diversion_in/out fields or it contains empty values?
We don’t get the diversion_in/out fields, Should they still be send even if they were empty, just a value of “null” instead?