Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas
Schedule_Report
This table is in the
category. To see database rules, see
Each row describes a report used to export information from the ICM platform to a workforce management
system.
system.
Related tables
(via ScheduleReportID)
(via ScheduleReportID)
Table 315: Indexes for Schedule_Report Table
index_keys
index_description
index_name
EntityID, EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Schedule_Report
ScheduleReportID
clustered, unique, primary key located
on PRIMARY
on PRIMARY
XPKSchedule_Report
Table 316: Fields in Schedule_Report table
Keys and
NULL
Option
NULL
Option
Data Type
Description
Name
NOT
NULL
NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the report.
Description
AK-1 NOT
NULL
NULL
VNAME32
A name that is unique among all schedule reports
defined in the system database.
defined in the system database.
EnterpriseName
AK-1, FK
NOT
NULL
NOT
NULL
DBINT
If partitioning is enabled, indicates the business
entity to which the schedule belongs.
entity to which the schedule belongs.
EntityID
NULL
varchar(255)
For a SQL report, the UNC name of the file.
PathName
NOT
NULL
NULL
DBINT
The type of report:
• 8 = Based on a template.
• 9= Based on a SQL report.
ReportType
PK NOT
NULL
NULL
DBINT
A unique identifier for the report.
ScheduleReportID
Database Schema Guide for Cisco Unified Contact Center Enterprise Release 9.0
438
All tables
Schedule_Report