Enterprise CDR Dictionary
- Kyle W.
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. |
callid | Character. (Max. 50) | Internal ID of the A-Leg of the call. |
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. |
orig_carrier_name | Character. (Max. 40) | Name of the originating instance. |
connection_name | Character. (Max. 40) | Name of the originating connection. |
orig_juris | Character. (Max. 10) | Jurisdiction (inter, intra, etc) of the originating carrier:
|
orig_cost | Numeric. NN.NNNNNN | Cost associated with the originating leg of the call. |
duration_real | Integer. (Max. 10) | Duration, in seconds, of the call. |
orig_billed_duration | Integer. (Max. 10) | Extended billed duration of the originating carrier. |
pdd | Integer. (Max. 10) | Post Dial Delay |
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. |
reason | Character. (Max 255) | Internal reason code/description. |
leg | Character. (Max. 1) | A = originating leg B = terminating leg |