Cisco Cisco IP Contact Center Release 4.6.1 Installation Guide
5-11
WebView Installation and Administration Guide for Cisco Enterprise & Hosted Editions, Release 7.0(0)
Chapter 5 The WebView Database
WebView Database Tables
The Report Table
This table contains one record for each saved report. It holds report parameters such as items selected
and thresholds. The User Preferences and Print Jobs tables refer to reports stored in this table.
and thresholds. The User Preferences and Print Jobs tables refer to reports stored in this table.
Table 5-3
Report Table
Field Name
Description
Constraint/Index
Database Table
Header
Database Table
Header
Data Types in
ICM/IPCC
databases
ICM/IPCC
databases
Allow
Nulls
Nulls
ReportID
The unique ID of the saved
report
report
Primary Key
int
Identity (1, 1)
No
Instance
The ICM instance on which
the report data is created
the report data is created
char(10)
No
OwnerID
This is a pre-7.0 field that is
retained for upgrade from
5.0/6.0 to 7.0. For 7.x
software, and after an upgrade
to 7.x, this field in no longer
used.
retained for upgrade from
5.0/6.0 to 7.0. For 7.x
software, and after an upgrade
to 7.x, this field in no longer
used.
int
Yes
CustomerID
The unique ID of the company
to which the report creator
belongs
to which the report creator
belongs
int
Yes
Name
The name of the saved report
char(260)
No
Description
An optional user-entered
description of the report
description of the report
text
Yes
IsPublic
Whether or not the report is
shared or private
shared or private
bit
No
IsRealTime
Whether or not the report is
real-time or historical
real-time or historical
bit
No
Category
The report category
char(260)
No
Type
Table or graph
char(1)
No
Template
The name of the template
from which the report was
created
from which the report was
created
char(260)
No
ItemsSelected
The items selected in the
report to be reported on
report to be reported on
text
No
StartDateTime
If selected in the report, the
beginning date and time for
the report data
beginning date and time for
the report data
datetime
Yes
EndDateTime
If selected in the report, the
end date and time for the
report data
end date and time for the
report data
datetime
Yes
RelativeDateType
If selected in the report, the
relative date and time range
for the report data, relative to
the day the report is run; for
example: Today or Next Week
relative date and time range
for the report data, relative to
the day the report is run; for
example: Today or Next Week
SmallInt
Yes