Cisco Cisco Customer Voice Portal 8.0(1)

Page of 132
Description
Index
Null
Type
Field
Unique Identifier
PK
No
smallint
ResourceID
The name of the resource we are
measuring (CPU, Memory, DSP,
DS0, System)
No
Yes
char(40)
Descriptor
ResultRef Table
This is the table to map a ResultID to a text value for a result.
Description
Index
Null
Type
Field
The unique id of a result
PK
No
int
ResultID
The name of the element result
No
No
nvarchar(96)
Result
Formerly Name
Table Values (ID, Result):
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
PK
No
int
SubSystemTypeID
The name of the Service type
No
No
nvarchar(96)
SubSystem
Table Values (ID, Name):
0, "SIP"
1, "IVR"
2, "VXML"
Reporting Guide for Cisco Unified Customer Voice Portal Release 8.0(1)
89
Chapter 4: Database Schema
Lookup and Reference Tables