Cisco Cisco Unified Contact Center Enterprise 9.0(2) Installation Guide
5-12
WebView Installation and Administration Guide for Cisco Enterprise & Hosted Editions, Release 7.0(0)
Chapter 5 The WebView Database
WebView Database Tables
The User Preferences Table
This table contains one record for each favorite saved by each user.
Table 5-4
User Preferences Table
Field Name
Description
Constraint/Index
Database Table Header
Database Table Header
Data Types in
ICM/IPCC
databases
ICM/IPCC
databases
Allow Nulls
UserGuid
The unique ID of the person
who designated the report as
a favorite
who designated the report as
a favorite
Primary Key
varchar(64)
Yes
ReportID
The unique ID of the saved
report
report
Primary Key
int
No
DrillDownTemplate
The name of the report
template assigned to a parent
report component. Drill-down
reports display filtered
versions of the parent report
data
template assigned to a parent
report component. Drill-down
reports display filtered
versions of the parent report
data
char(260)
Yes
DrillDownCategory
The category of drill-down
template
template
char(260)
Yes
Thresholds
The threshold or list of
thresholds set in the report
thresholds set in the report
text
Yes
RefreshRate
The rate in seconds at which
to refresh a real-time report
to refresh a real-time report
int
Yes
Scale
Attribute that specifies the
scale to show a report, in %
scale to show a report, in %
Default 100
smallInt
Yes
UserGuid
The unique ID of the user who
saved the report
saved the report
varchar(64)
Yes
Table 5-3
Report Table (continued)
Field Name
Description
Constraint/Index
Database Table
Header
Database Table
Header
Data Types in
ICM/IPCC
databases
ICM/IPCC
databases
Allow
Nulls
Nulls