Cisco Cisco Unified Customer Voice Portal 11.0(1)

The mechanism used
to end the application
visit

No

Yes

int

EventTypeID

The reason that the
application visit ended

No

Yes

int

CauseID

The end date and time
of the session

No

Yes

datetime

EndDateTime

The name of the
application that
transferred to this one

No

Yes

nvarchar(51)

SourceAppName

The local time zone
identifier

No

Yes

int

LocalTimeZone

The duration of the
session (seconds)

No

Yes

int

Duration

The name of the
VXML Service

No

No

varchar(41)

SubSystemName

The name of the
message bus that

No

No

varchar(42)

MessageBusName

delivers the VXML
datafeed message

The date and time of
the database operation

No

No

datetime

DBDateTime

VXMLSessionVariable Table

This table contains one record for each instance of a session variable. For example, if the same
session variable was modified once in an application script during a call, there will be two
separate records, one for its initial value when it was created and another for the updated value.

The unique id of an
IVR application
session

Yes (Composite index
SessionID,
CallStartDate)

No

int8

SessionID

The identifier of the
element in which the

Yes (Composite index
ElementID,
CallStartDate)

No

int8

ElementID

session variable
changes

Date of the call, for
data purging purposes

Yes (second field in
Composite indexes)

No

date

CallStartDate

The name of the
session variable that
was exited

No

No

nvarchar(51)

VarName

The value of the
session variable

No

Yes

nvarchar(255)

VarValue

Reporting Guide for Cisco Unified Customer Voice Portal Release 4.0(1)