Cisco Cisco Customer Voice Portal 8.0(1)

Page of 102
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)
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
Yes (Primary Key)
No
int
ResultID
The name of the
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
Yes (Primary Key)
No
int
SubSystemTypeID
The name of the
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