Cisco Cisco Customer Voice Portal Downloads

The name of the
message bus that

No

No

varchar(42)

MessageBusName

delivers the VXML
data feed message

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)

VXMLElement Table

This table contains one record for each VoiceXML script element visited by a call. For example,
if the same element is visited twice in an application script during a call, there will be two
separate element records.

The unique id of a
visited element

Yes (Primary Key,
Composite ElementID,
CallStartDate)

No

int8

ElementID

Date of the call, for
data purging purposes

Yes (second field in
Primary Key and
Composite indexes)

No

date

CallStartDate

The unique id of a
VXML application
session

Yes (Composite index
SessionID,
CallStartDate)

No

int8

SessionID

The global unique id of
a call

Yes

No

char(35)

CallGUID

The name of an
element

No

No

nvarchar(51)

ElementName

The type of element

No

No

int

ElementTypeID

Date and time when the
element was entered

Yes

No

datetime

EnterDateTime

Date and time when the
element was exited

No

Yes

datetime

ExitDateTime

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