...
The default file is comma-separated with a header row. Fields have maximum lengths based on data type as described in the Format column of the table below. New fields are always added to the END of the CDR.
...
Field
...
Format
...
Description
...
sip_code
...
Integer. (Max. 10)
...
SIP code returned to the originator.
...
sip_reason
...
Character. (Max. 500)
...
Internal code associated with the call.
...
call_start_time
...
YYYY-MM-DD HH:MM:SS
...
Date and time the call was initiated. UTC.
...
call_transaction_time
...
YYYY-MM-DD HH:MM:SS
...
Date and time of this leg. UTC.
...
call_answered_time
...
YYYY-MM-DD HH:MM:SS
...
Date and time the call was answered. UTC. Blank for calls that did not complete.
...
call_end_time
...
YYYY-MM-DD HH:MM:SS
...
Date and time the call ended. UTC.
Blank for calls that did not complete.
...
from_did
...
Character. (Max. 30)
...
ANI/originating number of the call.
...
to_did
...
Character. (Max. 30)
...
Dialed number of the call.
...
lrn_did
...
Character. (Max. 30)
...
LRN, if applicable, of the call.
...
callid
...
Character. (Max. 50)
...
Internal ID of the call.
...
duration_real
...
Integer. (Max. 10)
...
Duration, in seconds, of the call.
...
taxable_jurisdiction
...
Character. (Max 1)
...
Jurisdiction based on BTN
...
orig_carrier_id
...
Integer. (Max. 10)
...
ID of the originating carrier.
...
orig_carrier_name
...
Character. (Max. 40)
...
Name of the originating carrier.
...
orig_trunk_group_id
...
Integer. (Max. 10)
...
ID of the originating trunk group.
...
orig_trunk_group_name
...
Character. (Max. 40)
...
Name of the originating trunk group.
...
orig_juris
...
Character. (Max. 10)
...
Jurisdiction (inter, intra, etc.) of the originating carrier.
L = Local
A= Intrastate
E= Interstate
U = Unknown/Indeterminate
I = International
...
orig_rate
...
Numeric. NN.NNNNNN
...
Per-minute rate of the originating carrier.
...
orig_billed_duration
...
Integer. (Max. 10)
...
Extended billed duration of the originating carrier.
...
orig_cost
...
Numeric. NN.NNNNNN
...
Cost associated with the originating leg of the call.
...
term_carrier_id
...
Integer (Max. 10)
...
ID of the terminating carrier.
...
term_carrier_name
...
Character. (Max. 40)
...
Name of the originating carrier.
...
term_trunk_group_id
...
Integer. (Max. 10)
...
ID of the terminating trunk group.
...
term_trunk_group_name
...
Character. (Max. 40)
...
External name of the terminating trunk group.
...
term_juris
...
Character. (Max. 10)
...
Jurisdiction (inter, intra, etc.) of the terminating carrier.
L = Local
A = Intrastate
E = Interstate
U = Unknown/Indeterminate
I = International
...
term_rate
...
Numeric. NN.NNNNNN
...
Per-minute rate of the terminating carrier.
...
term_billed_duration
...
Integer. (Max. 10)
...
Extended billed duration of the terminating carrier. In seconds.
...
term_cost
...
Numeric. NN.NNNNNN
...
Cost associated with the terminating leg of the call.
...
pdd
...
Integer. (Max. 10)
...
Post Dial Delay
...
orig_ip
...
Character. (Max. 40)
...
Signaling IP of the originating leg.
...
orig_socket
...
Character. (Max 50)
...
Inbound switch IP
...
term_ip
...
Character. (Max. 40)
...
Signaling IP of the terminating leg.
...
term_socket
...
Character. (Max 50)
...
Outbound switch IP
...
orig_media_ip
...
Character. (Max. 40)
...
Media IP of the originating leg.
...
term_media_ip
...
Character. (Max. 40)
...
Media IP of the terminating leg.
...
reason
...
Character. (Max 255)
...
Internal reason code/description.
...
leg
...
Character. (Max. 1)
...
A = originating leg
B = terminating leg
...
attempt_counter
...
Integer. (Max. 2)
...
LCR Depth of attempt. Base 1.
...
terminator
...
Character. (Max. 1)
...
Party that terminated the call.
T (Terminator)
O (Originator)
...
orig_country
...
Character. (Max. 50)
...
Country of the originating leg.
...
orig_destination
...
Character. (Max. 50)
...
Source destination of the originating leg. Typically used in International calls.
...
orig_ocn
...
Character. (Max. 10)
...
OCN the call originating from.
...
orig_lata
...
Character. (Max. 10)
...
LATA the call originated from.
...
orig_state
...
Character. (Max. 5)
...
State of the originating leg.
...
orig_ratecenter
...
Character. (Max. 50)
...
Rate center of the originating leg.
...
term_country
...
Character. (Max. 50)
...
Country of the terminating leg.
...
term_destination
...
Character. (Max. 50)
...
Destination of the terminating leg. Typically used in International calls.
...
term_ocn
...
Character. (Max. 10)
...
OCN the call terminated to.
...
term_lata
...
Character. (Max. 10)
...
LATA the call terminated to.
...
term_state
...
Character. (Max. 5)
...
State of the terminating leg.
...
term_ratecenter
...
Character. (Max. 50)
...
Rate center of the terminating leg.
...
mos_min
...
Numeric. NN.NN
...
Minimum MOS score.
...
mos_avg
...
Numeric. NN.NN
...
Average MOS score.
...
mos_max
...
Numeric. NN.NN
...
Maximum MOS score.
...
cdr_uuid
...
Character. (Max. 50)
...
Internal ID of this leg of the call.
...
direction
...
Character. (Max 1)
...
O = Outbound
I = Inbound
...
diversion_from
...
Character. (Max 30)
...
Contains ANI from Diversion header if present.
...
orig_rounding
...
Integer.
...
The number of rounding digits on the customer-termination or vendor-origination rate deck
...
term_rounding
...
Integer.
...
The number of rounding digits on the vendor-termination or customer-origination rate deck
...
isup_oli
...
Text.
...
Text datatype to accommodate leading 0s - Originating Line Information Support
...
isup_surcharge
...
Numeric. NN.NN
...
=0.00 and can contain a maximum of 2 decimal places
...
orig_billed_prefix
...
Integer.
...
Shows users which code was used by rating engine for INTL calls
...
term_billed_prefix
...
Integer.
...
Shows users which code was used by rating engine for INTL calls
...
orig_tech_prefix
...
String.
...
Shows users if an origination tech prefix was used
...
term_tech_prefix
...
String.
...
Shows users if an termination tech prefix was used
...
stir_attest
...
Character. (Max 1)
...
(STIR Signing Request Component) [Text Wrapping Break]
This value indicates the attestation level. Must be either A, B, or C. (Full, Partial, or Gateway)
...
stir_orig_id
...
Character. (Max. 50)
...
(STIR Signing Request Component)[Text Wrapping Break][Text Wrapping Break]This value indicates the origination identifier which is a GUID that represents the originating point of a call. For example the switch where the call started or a trunk group. This information is used to help traceback the origin of a call on a trusted network.
...
stir_orig_tn
...
Character. (Max. 50)
...
(STIR Signing Request Component)
Indicates the calling number or calling Uniform Resource Identifier.
...
stir_dest_tn
...
Character. (Max. 50)
...
(STIR Signing Request Component)
Indicates the called number(s) or called Uniform Resource Identifier(s).
...
stir_iat
...
Character. (Max. 50)
...
(STIR Signing Request Component)
Initiated at time (IAT). The time the request was initiated.
...
stir_x5u
...
Character. (Max. 200)
...
(STIR Signing Request Component)
Indicates the location of the certificate used to sign the token.
...
ani_lrn
...
Integer.
...
LRN of the ANI that will be used for rating of Origination TOLLFREE calls.
...
p_charge_info
...
String.
...
Please refer to the CDR Dictionary for more information on the fields contained within.