Cisco Cisco Unified Customer Voice Portal 11.0(1)

The date and time of
the database operation

No

No

datetime

DBDateTime

(when the record was
inserted). This is useful
for debugging purposes
to determine lags
between when the
event occurred versus
when it was written to
the database (for
example, a long lag
may indicate problems
with the reporting
server)

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

The type of action for
a session variable that
changes data

No

No

int

ActionTypeID

Date and time when the
session variable
changed

Yes

No

datetime

EventDateTime

The data type of the
session variable, such

No

No

int

VarDataTypeID

as Integer, String,
Boolean

Reporting Guide for Cisco Unified Customer Voice Portal Release 7.0(2)