Cisco Cisco Customer Voice Portal 8.0(1)

PK, FK

No

integer (serial)

SurrogateID

Date of the callback for data

purging purposes

PK

No

date

CallStartDate

Unique ID for the call

No

Yes

char(32) for new

installations

CallGuid

char(35) for upgrades

FK

No

smallint

QueueID

Status in queue:

No

No

smallint

QueueStatus

0 = in_queue,

1 = not_in_queue
Datetime entered queue

No

No

datetime year to

second

EnterDateTime

Datetime left queue

No

Yes

datetime year to

second

LeaveDateTime

CVP-calculated estimated wait

time (in seconds) Since

No

No

smallint

CVPEstimatedWaitTime

enterdatetime. This will be

generated during the insert, it

will not be maintained.
Unified ICM-calculated

estimated wait time (in

No

No

smallint

ICMEstimatedWaitTime

seconds) Since enterdatetime.

This will be generated during

the insert, it will not be

maintained.
The bitmask result obtained

from the Validation method.

No

No

smallint

ValidationStatus

See sample code below.
The date and time of the

database operation.

No

No

datetime year to

fraction(3)

DBDateTime

Validation Method sample code.

This is an example of a bitmask result obtained from the Validation method:

•

TOD = Time of Day Error", meaning the callback was scheduled for a time of day when the

queue is not open.

•

EWT = Estimated Wait Time, indicates if the agent wait time for an agent is long enough to

warrant a callback.

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