CDR Dictionary

The purpose of this article is to enumerate and describe the fields in the Call Detail Record (CDR).

 

CDR File Format: The default file is comma-separated with a header row. Fields have maximum lengths based by 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.

 

Will be blank for calls that did not complete.

call_end_time

YYYY-MM-DD HH:MM:SS

Date and time the call ended. UTC.

 

Will be 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 A-Leg 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.

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)

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)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 is 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.

ani_risk_score

String.

By dipping in industry specific spam databases a score is determined on the fly to identify if spam or not. Scores correlate with spam level options in Trunk Group Settings.

bleg_callid

Character. (Max. 50)

Internal ID of the B-Leg of the call.