xdr

Represents an item of usage (CDR/XDR) bound to a subscription, but not necessarily rated.

Column name Description Data type
xdr Reference to xdr_rated. bigint
subscription Reference to subscription. integer
rating_period Reference to rating_period. integer *
binding Primary key. bigint
subservice Reference to subservice. integer *
start_time   timestamp with time zone
session May represent a session from current_connections if it is still active. integer *
access_server Reference to access_server. smallint *
access_server_port   integer *
xdr_type Reference to xdr_type. text *
call_id   text *
flagfall   boolean *
count   integer *
bytes_in   bigint *
bytes_out   bigint *
seconds   integer *
pages   integer *
disconnect_reasons Indicates why the connection was terminated. smallint *
disconnect_reason_type Indicates how to interpret disconnect reason:
  • 0—Acct-Terminate-Cause from RADIUS RFC2138
  • 1—Ascend-Disconnect-Cause from RADIUS RFC2138
  • 2—It is not known why the connection was terminated
  • 3—The connection is still active
  • 4—The connection timed out
 smallint *
ip_address   text *
calling_party Indicates the root source of the call, for example, phone number of the caller. text *
called_party Indicates the root destination of the call, for example, phone number of the receiver. text *
call_source Indicates where the call is coming from, for example, originating switch. text *
call_destination Indicates where the call is going to, for example, terminating switch. text *
originating_subscription Indicates which subscription triggered this XDR if it was not the one listed in subscription field.

Reference to subscription.

 integer *
description   text *
username   text *
tariff_code   text *
wholesale_cost   numeric (14,6) *
role
  • 0—source of XDR
  • 1—destination of XDR
 smallint
chargeable   boolean