Cisco Cisco Customer Voice Portal 8.0(1)

VXMLSession Table

This table contains one record for each application visited by a call. For example, if a call has
transferred from one application to another one, the call with the same CallGUID will have two
session records.

The unique id of a
VXML application
session

Yes (Primary Key,
Composite SessionID,
CallStartDate)

No

int8

SessionID

Date of the call, for
data purging purposes

Yes (second field in
Primary Key and
Composite indexes)

No

date

CallStartDate

The name of the
session assigned by
VXML Server

No

No

nvarchar(96)

SessionName

The global unique id of
a call

Yes (Composite index
CallGUID,
CallStartDate)

No

char(35)

CallGUID

Date and time when
session starts

Yes

No

datetime

StartDateTime

The name of the
VXML application

Yes

No

nvarchar(51)

AppName

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. This field is
not populated

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
data feed message

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