Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
The number of minutes in each scheduling interval. A schedule
can contain different data for each interval.
can contain different data for each interval.
SchedulePeriod
FK, IE-1 NULL
DBINT
Foreign key to the schedule report.
ScheduleReportID
FK, IE-2 NULL
DBINT
Foreign key to a description of the source from which the schedule
is imported.
is imported.
ScheduleSourceID
NOT NULL
DBINT
The type of the schedule:
ScheduleType
• 1 = TCS
• 2 = Custom
• 5 = Report Export
• 6 = Periodic
Schedule_Import Table
This table is in the
Contains the schedule data imported from a source system. Only specific fields within this table
are meaningful for any schedule type. The meaning of the imported data is described by the
ICR_View and View_Column tables.
are meaningful for any schedule type. The meaning of the imported data is described by the
ICR_View and View_Column tables.
Related table
(viaScheduleID)
Table 167: Indexes for Schedule_Import Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Schedule_Import
DateTime, ScheduleID, TimeZone
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKSchedule_Import
Fields in Schedule_Import Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBCHAR
An imported value.
Bool1
NOT NULL
DBCHAR
An imported value.
Bool2
PK NOT NULL
DBDATETIME
The date and time at which the schedule data in the record becomes
effective.
effective.
DateTime
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
307
Chapter 2: All Tables
Schedule_Import Table