Technical References

Table 172: Indexes for Schedule_Source Table
index_keysindex_descriptionindex_name
EntityIDnonclustered located on PRIMARYXIE1Schedule_Source
ScheduleSourceIDclustered, unique, primary key
located on PRIMARY
XPKSchedule_Source
Fields in Schedule_Source Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
Additional information about the data source.
Description
FK, IE-1 NULLDBINT
If partitioning is enabled, indicates the business entity to which
the schedule belongs.
EntityID
NULLDESCRIPTION
The full file path from which data are retrieved.
FilePath
NULLvarchar(64)
The user name to use when logging into the system.
LoginName
PK NOT NULLDBINT
A unique identifier for the record.
ScheduleSourceID
NOT NULLVNAME32
The name of the system.
SystemName
NULLvarchar(32)
The password to use when logging into the system.
SystemPassword
NULLvarchar(255)
The time zone for the system. The value is the offset in minutes
from UTC (formerly called GMT).
SystemTimeZone
NOT NULLDBINT
The type of system from which the data are imported.
SystemType
Scheduled_Target Table
This table is in the Route category (page 447). To see database rules for these tables, click here
(page 507).
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.
Use the Scheduled Target Explorer to create, delete, and update scheduled targets.
Related tables
Customer Definition (page 153) (via CustomerDefinitionID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
315
Chapter 2: All Tables
Scheduled_Target Table