Technical References

Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBINT
The number of minutes in each scheduling interval. A schedule
can contain different data for each interval.
SchedulePeriod
FK, IE-1 NULLDBINT
Foreign key to the schedule report.
ScheduleReportID
FK, IE-2 NULLDBINT
Foreign key to a description of the source from which the schedule
is imported.
ScheduleSourceID
NOT NULLDBINT
The type of the schedule:
ScheduleType
• 1 = TCS
• 2 = Custom
• 5 = Report Export
• 6 = Periodic
Schedule_Import Table
This table is in the Schedule category (page 450). To see database rules, click here (page 508).
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.
Related table
Schedule (page 305) (viaScheduleID)
Table 167: Indexes for Schedule_Import Table
index_keysindex_descriptionindex_name
RecoveryKeynonclustered, unique, unique key
located on PRIMARY
XAK1Schedule_Import
DateTime, ScheduleID, TimeZoneclustered, unique, primary key
located on PRIMARY
XPKSchedule_Import
Fields in Schedule_Import Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLDBCHAR
An imported value.
Bool1
NOT NULLDBCHAR
An imported value.
Bool2
PK NOT NULLDBDATETIME
The date and time at which the schedule data in the record becomes
effective.
DateTime
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
307
Chapter 2: All Tables
Schedule_Import Table