Cisco Cisco IP Contact Center Release 4.6.1 Technical References
Fields in Schedule_Map Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
central database.
ChangeStamp
NULL
DESCRIPTION
IAdditional information about the key field.
Description
NOT NULL
VNAME32
The name of a primary key field.
FieldName
NOT NULL
DESCRIPTION
The value of the primary key field for the schedule.
FieldValue
IE-1, FK NOT NULL
DBINT
Foreign key that identifies the schedule.
ScheduleID
PKNOT NULL
DBINT
A unique identifier for the record.
ScheduleMapID
Schedule_Report Table
This table is in the
Each row describes a report used to export information from the ICM platform to a workforce
management system.
management system.
Related tables
(via ScheduleReportID)
Table 169: 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
located on PRIMARY
XPKSchedule_Report
Fields in Schedule_Report Table:
Keys and Null
Option:
Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central
database.
database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the report.
Description
AK-1 NOT NULL
VNAME32
A name that is unique among all schedule reports
defined in the ICM database.
defined in the ICM database.
EnterpriseName
AK-1, FK NOT
NULL
NULL
DBINT
If partitioning is enabled, indicates the business entity
to which the schedule belongs.
to which the schedule belongs.
EntityID
NULL
varchar(255)
For a SQL report, the UNC name of the file.
PathName
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
267
Chapter 2: All Tables
Schedule_Report Table