Technical References

ICR View (page 215) (via ICRViewID)Business Entity (page 73) (via EntityID)Agent (page 15) (via ScheduleID)
Recurring Script Schedule Map (page
270) (via ScheduleID)
Import Schedule (page 225) (via
ScheduleID)
Import Log (page 216) (via
ScheduleID)
Schedule Map (page 312) (via
ScheduleID)
Schedule Import Real Time (page 309)
(via ScheduleID)
Schedule Import (page 307)(via
ScheduleID)
Scheduled Target (page 315) (via
ScheduleID)
Schedule Source (page 314)(via
ScheduleSourceID)
Schedule Report (page 314) (via
ScheduleReportID)
Skill Group (page 364) (via ScheduleID)Service Array (page 328) (via
ScheduleID)
Service (page 325) (via ScheduleID)
Table 166: Indexes for Schedule Table
index_keysindex_descriptionindex_name
EntityID, EnterpriseNamenonclustered, unique, unique key
located on PRIMARY
XAK1Schedule
ScheduleReportIDnonclustered located on PRIMARYXIE1Schedule
ScheduleSourceIDnonclustered located on PRIMARYXIE2Schedule
ICRViewIDnonclustered located on PRIMARYXIE3Schedule
ScheduleIDclustered, unique, primary key
located on PRIMARY
XPKSchedule
Fields in Schedule Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NOT NULLDBCHAR
Deleted Flag. Stored as a character:
Deleted
• Y = Yes
• N=No
NULLDESCRIPTION
Additional information about the schedule.
Description
AK-1 NOT NULLVNAME32
A unique name for the schedule.
EnterpriseName
AK-1, FK NOT NULLDBINT
If partitioning is enabled, indicates the business entity to which
the schedule belongs.
EntityID
FK, IE-3 NULLDBINT
Foreign key to a description of how the ICM software interprets
the Schedule_Import data for the schedule.
ICRViewID
PK NOT NULLDBINT
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