Cisco Cisco Administrative Workstation Références techniques
2-293
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Schedule_Report Table
Schedule_Report Table
Each row describes a report used to export information from the ICM platform to a workforce
management system.
management system.
Table 2-305 Schedule_Report Table Constraints
Constraint
Field Name(s)
PK
ScheduleReportID
AK-1
EnterpriseName
EntityID
EntityID
FK
EntityID
Table 2-306 Schedule_Report Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
Description
Additional information about the report.
DESCRIPTION
NULL
EnterpriseName
A name that is unique among all schedule reports
defined in the ICM database.
defined in the ICM database.
VNAME32
AK-1
NOT NULL
EntityID
If partitioning is enabled, indicates the business
entity to which the schedule belongs.
entity to which the schedule belongs.
DBINT
AK-1, FK
NOT NULL
PathName
For a SQL report, the UNC name of the file.
varchar(255)
NULL
ReportType
The type of report:
8 = Based on a template.
9 = Based on a SQL report.
9 = Based on a SQL report.
DBINT
NOT NULL
ScheduleReportID
A unique identifier for the report.
DBINT
PK
NOT NULL
SystemName
For a SQL report, the name of the system
containing the report.
containing the report.
VNAME32
NULL
SystemTimeZone
For a template-based report, the time zone offset
to use with the template.
to use with the template.
varchar(255)
NULL
TemplateCategory
For a template-based report, the category used to
locate the template.
locate the template.
VNAME32
NULL
TemplateName
For a template-based report, the name of the
template used to create the report.
template used to create the report.
varchar(255)
NULL
TemplateOptions
For a template-based report, options used with the
template: /H to include the SQL header and
column name information; /A to append to the
output file.
template: /H to include the SQL header and
column name information; /A to append to the
output file.
varchar(255)
NULL
TemplateScope
For a template-based report, the scope used to
locate the template.
locate the template.
VNAME32
NULL