unbound_cdr fields
The fields of the unbound_cdr table can be derived from the radacct tables like so:
- server_id - is this the (\d+) part in from of the @ in the callingstationid string when servicetype is outgoing
- unique_id - historically this has been a unique message string furbished by the provider. Do you we use the primary key in the radacct table for this, radacctid?
- invoice_id - not derived from radacct
- calldate - use acctstarttime
- did - get from calledstationid
- ani - when servicetype is ‘transit’ get from callingstationid
- dialed_number - same as what we’re calling did? Looks like the they are related but the dialed_number can take international prefixes into account?
- is_mobile - need some logic on the dailed_number to determine if it’s mobile (both national and international, what about NZ is that national?)
- call_duration - use acctsessiontime
- billable_duration - same as call_duration?
- billed_amount - ?
- customer_billed_amount - ?
- disposition -
- virtual_phone - not needed (Inphonex specific)
- inphonex_id - not needed (Inphonex specific)
- country - is that country called or country receiving?
- info - does this indicate whether information was called?
- provider_type - ‘symbio’
- provider_id - NULL
- provider_customer_id - ?
- direction - derive from servicetype
- international - determine from dialed_number
- call_type - determine from dialed_number
Showing changes from previous revision. Removed | Added
