Cisco Cisco Customer Voice Portal Downloads
Description
Index
Null
Type
Field
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)
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)
ResultRef Table
This is the table to map a ResultID to a result string.
Description
Index
Null
Type
Field
The unique id of a
result
result
Yes (Primary Key)
No
int
ResultID
The name of the
element result
element result
No
No
nvarchar(96)
Name
Table Values (ID, Name):
1, "Normal"
2, "Invalidated"
3, "HotEvent"
4, "HotLink"
5, "Hang Up"
6, "Error"
7, "Transfer"
SubSystemTypeRef Table
This is the table to map a SubSystemTypeID to a Unified CVP Service type.
Description
Index
Null
Type
Field
The unique id of a
Service type
Service type
Yes (Primary Key)
No
int
SubSystemTypeID
The name of the
Service type
Service type
No
No
nvarchar(96)
Name
Table Values (ID, Name):
Reporting Guide for Cisco Unified Customer Voice Portal Release 7.0(2)
69
Chapter 6: Introduction to the Database Schema
Table Definitions