Cisco Cisco IPCC Web Option Technical References
2-191
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Schedule_Source Table
Schedule_Source Table
Each row indicates the system and path from which the associated schedule data are imported.
Related tables:
Schedule (via ScheduleSourceID)
Scheduled_Target Table
Each row represents a scheduled target. A scheduled target is not associated with a peripheral and the
ICM software has only limited information about it: number of agents scheduled and number of calls in
progress. You can route calls to scheduled targets using the Scheduled Select script node.
ICM software has only limited information about it: number of agents scheduled and number of calls in
progress. You can route calls to scheduled targets using the Scheduled Select script node.
Use the Scheduled Target Explorer to create, delete, and update scheduled targets.
Table 2-152 Schedule_Source Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ScheduleSourceID
A unique identifier for the record.
int
PK, NOT NULL
EntityID
If partitioning is enabled, indicates the business entity
to which the schedule belongs.
to which the schedule belongs.
int
FK, NULL
SystemName
The name of the system.
varchar(32)
NOT NULL
SystemType
The type of system from which the data are imported. int
NOT NULL
SystemTimeZone
The time zone for the system. The value is the offset in
minutes from GMT.
minutes from GMT.
int
NULL
FilePath
The full file path from which data are retrieved.
varchar(255)
NULL
Description
Additional information about the data source.
varchar(255)
NULL
LoginName
The user name to use when logging into the system.
varchar(64)
NULL
SystemPassword
The password to use when logging into the system.
varchar(32)
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-153 Scheduled_Target Table
Field Name
Description
Data Type
Keys and Null
Option
Option
NetworkTargetID
Identifier that is unique among all announcements,
peripheral targets, and scheduled targets in the system.
peripheral targets, and scheduled targets in the system.
int
PK, FK, NOT
NULL
NULL
CustomerDefinitionID
Identifies the customer definition associated with the
scheduled target.
scheduled target.
int
IE1, FK, NULL
EnterpriseName
A name that is unique among all scheduled targets
defined in the ICM database.
defined in the ICM database.
varchar(32)
AK1, NOT
NULL
NULL
ScheduleID
Identifies the schedule associated with the scheduled
target.
target.
int
FK, NULL