User`s guide

SFVRA Connection Manager 207
SQL D ATABASE S CRIPT D EFINITIONS
SFVRA Database Tables
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.
START_TIME
The start time of the connection.
CONNECTTYPE_ID
The type of the call that initiated the connection as referenced in the USER_CONNECTTYPES table.
CALLDIRECTION_ID
The direction of the call that initiated the connection as reference in the USER_CALLDIRECTIONS
table.
CURRENT_BANDWIDTH
A number that represents the current bandwidth of the connection. This number is updated each
time a call goes up or down.
MAX_BANDWIDTH
A number that represents the maximum bandwidth that has been used so far during the
connection. This number is updated each time a call goes up or down.
CONNECT_STATUS
The current status of the connection. Active means that the connection is currently in place.
Dropped means that as bandwidth decreases, calls within a connection may be dropped. Unknown
means the connection is in an unknown state. The unknown state is entered for any connection that
was Active when the TCP connection between the CyberSWITCH and the SFVRA-CONN was lost.
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.
USER_ACCESS
Entries are created in this table by the Client interface for every User configured.
Note: For every entry in USER_ACCESS there must be a corresponding entry in the USER_INFO
table.
USER_NAME
A string used to uniquely identify a User.