Cisco Cisco Unified Customer Voice Portal 11.0(1) Release Note
C
HAPTER
4:
U
SER
M
ANAGEMENT
U
SER
G
UIDE FOR
C
ISCO
U
NIFIED
CVP
VXML
S
ERVER
AND
C
ISCO
U
NIFIED
C
ALL
S
TUDIO
89
Historical Data
Tracking user information is only part of a user management system. Many applications benefit
from knowing information about the past history of a user’s interaction with the phone system.
This component of the user management system is automatically updated by VXML Server and
need only be queried by the developer when information about user(s) is desired.
from knowing information about the past history of a user’s interaction with the phone system.
This component of the user management system is automatically updated by VXML Server and
need only be queried by the developer when information about user(s) is desired.
sessions
This table contains records of every call made to the system. It stores telephony information
about the call as well as when the call was made. The table specification is as follows:
about the call as well as when the call was made. The table specification is as follows:
Column
Type
Description
call_id
integer
This is an automatically incremented ID for the call. It is
used exclusively within the user management system.
used exclusively within the user management system.
source
varchar(50)
This column contains the name of the application which
transferred to this one or is null if the application was
called directly.
transferred to this one or is null if the application was
called directly.
app_id
integer
The application ID of the application called. If the user
management system is not shared across multiple
applications, this ID would be the same for all calls.
management system is not shared across multiple
applications, this ID would be the same for all calls.
ani
varchar(10)
The ANI of the originating caller. Is NA if the ANI was
not sent by the telephony provider.
not sent by the telephony provider.
dnis
varchar(10)
The DNIS of the originating caller. Is NA if the DNIS
was not sent by the telephony provider.
was not sent by the telephony provider.
uui
varchar(100)
The UUI of the originating caller. Is NA if the UUI was
not sent by the telephony provider.
not sent by the telephony provider.
iidigits
varchar(100)
The IIDIGITS of the originating caller. Is NA if the
IIDIGITS was not sent by the telephony provider.
IIDIGITS was not sent by the telephony provider.
area_code
varchar(10)
The area code of the originating caller. Is null if the ANI
is NA.
is NA.
exchange
varchar(10)
The exchange of the originating caller. Is null if the ANI
is NA.
is NA.
uid
integer
The UID of the caller if the call was associated with a
user. If not, it will appear as null.
user. If not, it will appear as null.
start_time
datetime
The date and time the visit to the application began. If no
other application can transfer to this one, this will be the
time the call was made.
other application can transfer to this one, this will be the
time the call was made.
end_time
datetime
The date and time the visit to the application ended. If
this application cannot transfer to any other application,
this will be the time the call ended in a hang-up or
disconnect.
this application cannot transfer to any other application,
this will be the time the call ended in a hang-up or
disconnect.