Cisco Cisco Customer Voice Portal 8.0(1)

A unique id of the transfer

type. See 

Non-Indexed FK

No

integer

TransferTypeID

New in Rel. 8.0.
The type of the Service. See

.

Non-Indexed FK

No

int

SubSystemTypeID

The name of the Service the

event originated from

No

No

varchar(41)

SubSystemName

No

Yes

nvarchar(255)

MediaFileName

This is the destination to

which CVP transfers the call.

No

Yes

varchar(32)

TransferLabel

The label is received from

ICM via the

TEMPORARY_CONNECT

or CONNECT message

New in Rel. 8.0.
The offset in minutes of this

the local timezone from UTC

timezone.

No

NULL

smallint

LocalTimeZoneOffset

CallICMInfo Table

This table contains information to associate a Unified CVP call to ICM. It stores the ICM Call

RouteCallKey, RouterCallKeyDay and RouterCallSequenceNumber for a call.

The CallICMInfo table is populated when the call is on the switch leg. This table is populated

by SIP or VXML subsystems.

Currently the system does not capture the VRU leg of the call; thus if you have a Capture

element and multiple TCD records are cut, the RouterCallKeySequenceNumber will increment

in HDS but will not be captured in the Unified CVP database. This is a known limitation.

Refer to the CVP Administration and Configuration Guide for further explantion about using

the ReqICMLabel element to pass data to a Unified ICME script.

The global unique id of a call

Indexed FK

(Composite

No

char(32) for new

installations

CallGUID

CallGUID,

CallStartDate)

char(35) for

upgrades

Date of the call, for data purging

purposes

FK (Composite

CallGUID,

CallStartDate)

No

date

CallStartDate

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