Page Comparison

A data record is produced by a telephone exchange or other telecommunications equipment that documents the details of a telephone call or other telecommunications telecommunication transactions (e.g. text message) which pass through that facility or device.

The CDR Diagnostic Report tool enables you to retrieve Call Detail Records. For more information on this Reporting tool, click here and navigate to the CDR Diagnostic Report section.

File format

...

The default file is comma-separated with a header row. Fields have maximum lengths based by on data type as described in the Format column of the table below. New fields are always added to the END of the CDR.
Will be blank Will be blank   Typically Initiated is Indicates
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.
Used for SIP entities that provide billing services for a session. The processing of this header would allow you to bill based on P-Charge instead of FROM field if present.

Versions Compared

Old Version 2

New Version 3

Key

File format

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.	Used for SIP entities that provide billing services for a session. The processing of this header would allow you to bill based on P-Charge instead of FROM field if present.