Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas
(via NetworkTargetID)
(via ScheduleID)
(via NetworkTargetID)
Table 173: Indexes for Schedule_Target Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Scheduled_Target
CustomerDefinitionID
nonclustered located on PRIMARY
XIE1Scheduled_Target
NetworkTargetID
clustered, unique, primary key
located on PRIMARY
located on PRIMARY
XPKScheduled_Target
Fields in Scheduled_Target Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
FK, IE-1 NULL
DBINT
Identifies the customer definition associated with the scheduled
target.
target.
CustomerDefinitionID
NULL
DESCRIPTION
Additional information about the scheduled target.
Description
AK-1 NOT NULL
VNAME32
A name that is unique among all scheduled targets defined in
the ICM database.
the ICM database.
EnterpriseName
PK, FK NOT NULL
DBINT
Identifier that is unique among all announcements, peripheral
targets, and scheduled targets in the system.
targets, and scheduled targets in the system.
NetworkTargetID
FK NULL
DBINT
Identifies the schedule associated with the scheduled target.
ScheduleID
Scheduled_Target_Real_Time Table
Local database only.
Contains one row for each scheduled target. The ICM software updates the real-time data each
time it sends a call to the target or receives a notification from the routing client that a call has
completed. The Admin Workstation receives updated data every 15 seconds.
time it sends a call to the target or receives a notification from the routing client that a call has
completed. The Admin Workstation receives updated data every 15 seconds.
Related table
(via NetworkTargetID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
316
Chapter 2: All Tables
Scheduled_Target_Real_Time Table