Cisco Cisco Customer Voice Portal Downloads

CallICMInfo Table

This table contains information to associate a Unified CVP call to ICM.

The global unique id of a call

Yes (Composite
index

No

char(35)

CallGUID

CallGUID,
CallStartDate)

Date of the call, for data
purging purposes

Yes (Composite
index

No

date

CallStartDate

CallGUID,
CallStartDate)

ICM Router CallKey

Yes (Composite
index

No

Integer

RouterCallKey

RouterCallKey,
RouterCallKeyDay)

ICM RouterCallKeyDay

Yes (Composite
index

No

Integer

RouterCallKeyDay

RouterCallKey,
RouterCallKeyDay)

ICM
RouterCallKeySequenceNumber

Yes

Yes

int

RouterCallKeySequenceNumber

Date and time of the event

Yes

No

datetime

EventDateTime

The name of the message bus
that delivers the VXML data
feed message

No

No

varchar(42)

MessageBusName

The date and time of the
database operation (when the

No

No

datetime

DBDateTime

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)

CauseRef Table

This is the table to map a CauseID to the cause.

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