NAS Call Detail Fields

Database Field type Descriptions
account_user  varchar Account charged by this entry
account_domain varchar Domain charged by this entry
cdr_type
varchar
CDR Type :
call - Real Time Rating
post - Post Rating
callid
varchar Call-ID of the termination call leg
orignumber  varchar phone number of the origination party
origdomain varchar domain of the origination party
termnumber varchar phone number of the termination party
termdomain varchar domain of URI of the termination party
lergclass
varchar
LERG Class
0 - not classified
1 - Inter-State, Inter-LATA
2 - Inter-State, Intra-LATA
3 - Intra-State, Inter-LATA
4 - Intra-State, Intra-LATA
5 - Local
time_start
date time
Start time of the call(yyyy-mm-dd hh:mm:ss)
time_ring
date time
Ringing  start time(yyyy-mm-dd hh:mm:ss)
time_answer
date time
Answer time  of the call(yyyy-mm-dd hh:mm:ss)
time_release
date time
Release time of the call(yyyy-mm-dd hh:mm:ss)
release_cause varchar
Cause of release
duration double
Duration of call (second)
duration_charged double
Duration charged (second)
rate double
Charge per minute (dollar)
extra_charge double
Extra charge applied (dollars)
longcall_extra double Long Call Extra Charge applied (dollars)
disconnect_fee double Disconnect Fee applied (dollars)
tax double
Total Tax applied (dollars)
total_charge
double
Total Charges (dollars)
rate_entry
varchar Rate entry applied
bucket_id
varchar
ID of the Minute Bucket applied
bucketed_date date
Date that the Minute Bucket is applied
bucketed_credit
double
Credit applied from the Minute Bucket
tax_id
varchar
Tax ID
origprefix varhcar Matched prefix of the origination number
termrefix
varchar Matched prefix of the termination number
account_debited
no or yes
Whether the "total_charge" has been debited from the associated account
orig_conn
varchar Match Pattern of the Origination Connection
term_conn
varchar Match Pattern of the Termination Connection
orig_callid
varcharCall-ID of the origination call leg
pac
varcharAccount code