Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Scheduled_Target_Real_Time Table
This table is in the 
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 noti
fication from the routing client that a call has
completed. The Admin Workstation receives updated data every 15 seconds.
Related table
 (via NetworkTargetID)
Table 173: Indexes for Scheduled_Target_Real_Time Table
index_keys
index_description
index_name
NetworkTargetID
clustered, unique, primary key
located on PRIMARY
XPKScheduled_Target_Real_Time
Fields in Scheduled_Target_Real_Time Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The number of calls currently in progress at the
scheduled target.
CallsInProgress
NOT NULL
DBDATETIME
The date and time when the row was last updated.
DateTime
NULL
DBINT
The maximum number of simultaneous calls the
target can handle for the current time period (based
on its schedule).
MaxCallsInProgress
PK, FK NOT NULL
DBINT
Identifies the scheduled target.
NetworkTargetID
NULL
DBINT
Number of calls currently queued at the CallRouter
for this target.
RouterCallsQNow
Script Table
This table is part of the 
Each row represents a version of a routing script or an administrative script. You can save
multiple versions of each script. The binary representation of the script version is stored in the
Script_Data table. General information that applies to all versions of a script is stored in the
Master Script table.
Use the Script Editor to create and modify scripts.
Related tables
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
271
Chapter 2:  All Tables
Scheduled_Target_Real_Time Table