Cisco Cisco Customer Voice Portal 8.0(1)

The type of Unified CVP

Service, such as SIP, IVR,

VXML

Non-Indexed KX

No

int

SubSystemTypeID

The offset in minutes of the

local timezone from UTC

timezone.

No

smallint

LocalTime

ZoneOffset

CallEvent Table

This tabletracks each event that occurs within a call.

This table is populated for SIP calls. VXML calls will be recorded in the analogous

The global unique id of a call

Indexed FK (Composite

CallGUID,

CallStartDate)

No

char(32) for new

installations

char(35) for upgrades

CallGUID

Date of the call, for data

purging purposes

FK (Composite

CallGUID,

CallStartDate)

No

date

CallStartDate

A call id assigned by a Service

No

Yes

varchar(255,43)

CallLegID

The name of the Call Server

(its message adapter name)

No

No

varchar(42)

MessageBusName

with which the event is

associated
Date and time of the event

Yes 8.0

No

datetime YEAR to

FRACTION(3)

EventDateTime

Uses UTC in Rel. 8.0.
The mechanism used to

generate the call event. See

Non-Indexed FK

No

int

EventTypeID

The reason that the call event

was generated. See 

Non-Indexed FK

No

int

CauseID

The date and time of the

database operation (when the

record was inserted).

Yes (8.0)

No

datetime YEAR to

FRACTION(3)

DBDateTime

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