Cisco Cisco Unified Contact Center Enterprise 9.0(2) Referencia técnica
(via ICRViewID)
(via EntityID)
ScheduleID)
(via
ScheduleID)
ScheduleID)
(via ScheduleID)
ScheduleID)
(via
ScheduleID)
(via
ScheduleSourceID)
ScheduleReportID)
(via ScheduleID)
ScheduleID)
(via ScheduleID)
Table 166: Indexes for Schedule Table
index_keys
index_description
index_name
EntityID, EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Schedule
ScheduleReportID
nonclustered located on PRIMARY
XIE1Schedule
ScheduleSourceID
nonclustered located on PRIMARY
XIE2Schedule
ICRViewID
nonclustered located on PRIMARY
XIE3Schedule
ScheduleID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKSchedule
Fields in Schedule Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULL
DBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N=No
NULL
DESCRIPTION
Additional information about the schedule.
Description
AK-1 NOT NULL
VNAME32
A unique name for the schedule.
EnterpriseName
AK-1, FK NOT NULL
DBINT
If partitioning is enabled, indicates the business entity to which
the schedule belongs.
the schedule belongs.
EntityID
FK, IE-3 NULL
DBINT
Foreign key to a description of how the ICM software interprets
the Schedule_Import data for the schedule.
the Schedule_Import data for the schedule.
ICRViewID
PK NOT NULL
DBINT
A unique identifier for the schedule.
ScheduleID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
306
Chapter 2: All Tables
Schedule Table