Cisco Cisco Customer Voice Portal 8.0(1)

Date of the call, for data

purging purposes

Yes (Composite

index ElementID,

CallStartDate)

No

date

CallStartDate

The name of the element

variable

No

No

nvarchar(51)

VarName

The String value of the element

variable

No

Yes

nvarchar(255)

VarValue

The data type of the element

variable, such as String, Integer,

Boolean

Non-Indexed FK

No

int

VarDataTypeID

The type of action for an

element that changes data

Non-Indexed FK

No

int

ActionTypeID

Date and time when the variable

was changed

Yes

No

datetime YEAR to

FRACTION(3)

EventDateTime

Uses UTC in Rel. 8.0.
The date and time of the

database operation (when the

record was inserted).

Yes

No

datetime YEAR to

FRACTION(3)

DBDateTime

VXMLElementFlag Table

This table contains one record for each element in which a Ȁag was activated. The Name field

holds the name of the Ȁag.

The unique id for the

element in which the Ȁag

activated

Indexed FK

(Composite index

ElementID,

CallStartDate)

No

int8

ElementID

Date of the call, for data

purging purposes

Yes (Composite index

ElementID,

CallStartDate)

No

date

CallStartDate

The date and time when the

Ȁag activated

Yes

No

datetime YEAR to

FRACTION(3)

EventDateTime

Uses UTC in Rel. 8.0.
The Ȁag name

No

No

nvarchar(51)

Name

Name of the previous

application element

No

Yes

nvarchar(51)

PreviousElementName

The date and time of the

database operation (when the

record was inserted).

Yes

No

datetime YEAR to

FRACTION(3)

DBDateTime

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