User`s guide

SFVRA Connection Manager 203
SQL D ATABASE S CRIPT D EFINITIONS
SFVRA Database Tables
REASON_STRING
The reason for the failure.
CALL_HISTORY
The SFVRA Service creates entries in this table when a connection has gone down. All calls that
made up this connection are moved from the CURRENT_CALL table to this table.
C
ALLNR
An identity field to uniquely identify this entry.
C
ONNECTNR
The number that ties the call to the connection in the CONNECT_HISTORY table.
CONNECT_ID
The Connect 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.
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 call on a CyberSWITCH and
is of no informative purpose to the customer.
CALL_START_TIME
The start time of the call.
CALL_END_TIME
The end time of the call.
DURATION
The duration of this call, the difference between CALL_START_TIME and CALL_END_TIME.
BANDWIDTH
The maximum bandwidth used by this call.
CALLED_TN
The number that was called.
CALLING_TN
The number that made the call.
FWD_TN
The number from which the call was forwarded.
CONN_START_TIME
The start time of the connection that this call is a part. This is the same value as START_TIME in the
CONNECTION_HISTORY table.