Cisco Cisco E-Mail Manager Unity Integration Option Technical References
Table 172: Indexes for Schedule_Source Table
index_keys
index_description
index_name
EntityID
nonclustered located on PRIMARY
XIE1Schedule_Source
ScheduleSourceID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKSchedule_Source
Fields in Schedule_Source Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the data source.
Description
FK, IE-1 NULL
DBINT
If partitioning is enabled, indicates the business entity to which
the schedule belongs.
the schedule belongs.
EntityID
NULL
DESCRIPTION
The full file path from which data are retrieved.
FilePath
NULL
varchar(64)
The user name to use when logging into the system.
LoginName
PK NOT NULL
DBINT
A unique identifier for the record.
ScheduleSourceID
NOT NULL
VNAME32
The name of the system.
SystemName
NULL
varchar(32)
The password to use when logging into the system.
SystemPassword
NULL
varchar(255)
The time zone for the system. The value is the offset in minutes
from UTC (formerly called GMT).
from UTC (formerly called GMT).
SystemTimeZone
NOT NULL
DBINT
The type of system from which the data are imported.
SystemType
Scheduled_Target Table
This table is in the
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.
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
(via CustomerDefinitionID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
315
Chapter 2: All Tables
Scheduled_Target Table