/mcpSkill_Group, on page 493 (via ScheduleID) Table 348: Indexes for Schedule Table index_keys index_description index_name EntityID, EnterpriseName nonclustered, unique, unique key 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 XPKSchedule Table 349: Fields in Schedule Table Keys and NULL Option Data Type Description Name NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NULL DBDATETIME Records the date and time when a record is added/updated. DateTimeStamp NOT NULL DBCHAR Deleted Flag. Stored as a character: • Y = Yes • N=No Deleted 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. EntityID FK, IE-3 NULL DBINT Foreign key to a description of how the system software interprets the Schedule_Import data for the schedule. ICRViewID PK NOT NULL DBINT A unique identifier for the schedule. ScheduleID NOT NULL DBINT The number of minutes in each scheduling interval. A schedule can contain different data for each interval. SchedulePeriod Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 429 All Tables Schedule