Cisco Cisco Customer Voice Portal 8.0(1) Guida Utente

Pagina di 157
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.
integer
app_id
The ANI of the originating caller. Is NA if the ANI was not sent by the
telephony provider.
varchar(10)
ani
The DNIS of the originating caller. Is NA if the DNIS was not sent by
the telephony provider.
varchar(10)
dnis
The UUI of the originating caller. Is NA if the UUI was not sent by the
telephony provider.
varchar(100)
uui
The IIDIGITS of the originating caller. Is NA if the IIDIGITS was not
sent by the telephony provider.
varchar(100)
iidigits
The area code of the originating caller. Is null if the ANI is NA.
varchar(10)
area_code
The exchange of the originating caller. Is null if the ANI is NA.
varchar(10)
exchange
The UID of the caller if the call was associated with a user. If not, it
will appear as null.
integer
uid
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.
datetime
start_time
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.
datetime
end_time
flags
This table contains records of the flags triggered by every call made to the system. Since flags
are used to indicate important parts of the voice application, knowing what areas of the voice
application people visited in the past can be very useful. The table specification is as follows:
Description
Type
Columns
This refers to the call ID of the call.
integer
call_id
This is the name of the flag that was triggered.
varchar(100)
flag_name
This is the date and time the flag was triggered.
datetime
flag_time
User Guide for Cisco Unified CVP VXML Server and Cisco Unified Call Studio Release 8.0(1)
96
Chapter 4: User Management
Database Design