User`s guide

SFVRA Connection Manager 205
SQL D
ATABASE
S
CRIPT
D
EFINITIONS
SFVRA Database Tables
MAX_BANDWIDTH
A number that represents the maximum bandwidth that was ever used during the connection.
IN_OCTET_COUNT
The number of octets of data received by the CyberSWITCH during the connection.
OUT_OCTET_COUNT
The number of octets of data transmitted by the CyberSWITCH during the connection.
IP_ADDRESS
The IP address of the remote user involved in the connection. This field is useful for identifying the
IP address of remote users that request an IP address from a pool of addresses. The default value
for non-IP remote users is 0.0.0.0.
CURRENT_CALL
The SFVRA Service creates these entries when a call comes up. The entries stay in this table until
the connection goes down at which time they move to the CALL_HISTORY table.
C
ONNECTNR
The number that ties the call to the connection in the CURRENT_CONNECT table.
USER_NAME
The User that is part of the call.
SERVER_NAME
The CyberSWITCH that is part of the call.
CONNECT_ID
The Connect ID on the CyberSWITCH for the connection. This number is an index into an array on
the CyberSWITCH. It is used by the SFVRA Service to uniquely identify a connection on a
CyberSWITCH and is of no informative purpose to the customer.
CALL_ID
The Call ID on the CyberSWITCH for the call. This number is an index into an array on the
CyberSWITCH. It is used by the SFVRA Service to uniquely identify a connection on a
CyberSWITCH and is of no informative purpose to the customer.
START_TIME
The start time of the call.
BANDWIDTH
The bandwidth of the call.
CALLED_TN
The number that was called for the call.
CALLING_TN
The number that made the call.
FWD_TN
The number from which the call was forwarded.