Cisco Cisco Customer Voice Portal 8.0(1) User Guide

a user to associate with their account both their home and work numbers can automatically
recognize who the caller is when calls are received from either number, rather than requiring
them to log in. If multiple phone numbers are not required or necessary, this table can contain
one entry per account or remain empty. Since there may be multiple rows in the system with
the same UID, there is no primary key to this table. The table specification is as follows:

A phone number to associate with this account.

varchar(10)

phone

The UID identifying the user.

integer (foreign key)

uid

This table is used to track calls made from specific phone numbers (ANIs). This table is
automatically updated by VXML Server and need only be queried by the developer when
information about a caller is desired. The table contains information about the number of calls
and the last call made from a phone number. This information can be used to welcome a caller
back to the application or warn that menu options have changed since their last call even if the
application itself is not set up to track individual users through logins. The table specification
is as follows:

The phone number of the caller.

varchar(10)

ani

The application the caller called into. This exists in case multiple
applications share a common user management system.

integer

app_id

The number of calls received by this phone number to this application.

integer

call_count

The last time a call was received by this phone number to this
application.

datetime

last_call

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.

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:

This is an automatically incremented ID for the call. It is used exclusively
within the user management system.

integer

call_id

This column contains the name of the application which transferred to
this one or is null if the application was called directly.

varchar(50)

source

User Guide for Cisco Unified CVP VXML Server and Cisco Unified Call Studio Release 8.0(1)