Cisco Cisco Administrative Workstation Technical References

Page of 548
   
2-299
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
  
Chapter 2      Table Details
Scheduled_Target Table
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.
Use the Scheduled Target Explorer to create, delete, and update scheduled targets.
Related tables:
 (via CustomerDefinitionID)
 (via NetworkTargetID)
 (via ScheduleID)
 (via NetworkTargetID)
Table 2-311 Scheduled_Target Table Constraints
Constraint
Field Name(s)
PK
NetworkTargetID
AK-1
EnterpriseName
FK
CustomerDefinitionID
NetworkTargetID
ScheduleID
IE-1
CustomerDefinitionID
Table 2-312 Scheduled_Target Table
Field Name
Description
Data Type
Keys and 
Null Option
ChangeStamp
Incremented when the record is changed in the 
central database.
CHANGESTAMP
NOT NULL
CustomerDefinitionID
Identifies the customer definition associated with 
the scheduled target.
DBINT
FK, IE-1
NULL
Description
Additional information about the scheduled target. DESCRIPTION
NULL
EnterpriseName
A name that is unique among all scheduled targets 
defined in the ICM database.
VNAME32
AK-1
NOT NULL
NetworkTargetID
Identifier that is unique among all announcements, 
peripheral targets, and scheduled targets in the 
system.
DBINT
PK, FK
NOT NULL
ScheduleID
Identifies the schedule associated with the 
scheduled target.
DBINT
FK
NULL