Cisco Cisco Customer Voice Portal 8.0(1)

written to the database (for

example, a long lag may

indicate problems with the

reporting server).

VXMLSession Table

This table contains one record for each application visited by a VXML 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

PK (Composite

SessionID,

CallStartDate)

No

int8

SessionID

Date of the call, for data

purging purposes

PK (second field in

PK 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

Indexed FK

(Composite index

No

char(32) for new

installations

CallGUID

CallGUID,

CallStartDate);

char(35) for upgrades

Date and time when session

starts

Yes

No

datetime YEAR to

FRACTION(3)

StartDateTime

The name of the VXML

application

Yes

No

nvarchar(51)

AppName

The mechanism used to end

the application visit

Non-Indexed FK

No

int

EventTypeID

The reason that the application

visit ended

Non-Indexed FK

No

int

CauseID

The end date and time of the

session

No

Yes

datetime YEAR to

FRACTION(3)

EndDateTime

The name of the application

that transferred to this one

No

Yes

nvarchar(51)

SourceAppName

The name of the VXML

Service

No

No

varchar(41)

SubSystemName

The name of the message bus

that delivers the VXML data

feed message

No

No

varchar(42)

MessageBusName

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