Cisco Cisco Customer Voice Portal 8.0(1)

Table Definitions

This section lists all the tables, in alphabetical order.

ActionTypeRef Table

This is the table to map an ActionTypeID to the type of action for an element that changes data.

The unique id of an
action type

Yes (Primary Key)

No

int

ActionTypeID

The name of the action
type

No

No

nvarchar(96)

Name

1, "Initialize"

2, "Update"

3, "Return"

Call Table

This table contains one record per call.

The global unique id of
a call

Yes (Primary Key
Composite CallGUID,
CallStartDate)

No

char(35)

CallGUID

Date of the call, for
data purging purposes

Yes (Primary Key
Composite CallGUID,
CallStartDate)

No

date

CallStartDate

Date and time a call
was made

Yes

No

datetime

StartDateTime

The name of the Call
Server (its message

No

No

varchar(42)

MessageBusName

adapter name) where
the call originates
The type of Unified
CVP Service, such as
SIP, IVR, VXML

No

No

int

SubSystemTypeID

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