Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco Administrative Workstation
  5. Technical References

Cisco Cisco Administrative Workstation Technical References

Download
Page of 404
 
2-183
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Schedule Table
Related tables:
Physical Interface Controller (via PhysicalControllerID)
Routing Client (via RoutingClientID)
Schedule Table
Each row describes a schedule to be imported from an external system. Imported data are stored in the 
Schedule_Import and Schedule_Import_Real_Time tables.
Use the Workforce Management System Import tool to create, delete, or modify Schedule rows.
Histogram19
The number of calls routed in a 100-millisecond 
period.
int
NULL
NumCancelInd
The number of cancel indications the VRU 
routing client sent to the VRU during the five- 
minute interval.
int
NULL
NumReleasInd
The number of release indications the VRU 
routing client sent to the VRU during the five- 
minute interval.
int
NULL
NumBlindTransferConfTo5
The number of blind transfer confirmation 
messages the routing client sent during the 
five-minute interval.
int
NULL
NumTransferEventTo5
The number of transfer event messages the 
routing client sent during the five-minute interval.
int
NULL
NumCallFailedEventTo5
The number of call failure event messages the 
routing client sent during the five-minute interval.
int
NULL
Table 2-145 Routing_Client_Five_Minute Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-146 Schedule Table
Field Name
Description
Data Type
Keys and Null 
Option
ScheduleID
A unique identifier for the schedule.
int
PK, NOT NULL
ScheduleReportID
Foreign key to the schedule report.
int
FK, NULL
ScheduleSourceID
Foreign key to a description of the source from which 
the schedule is imported.
int
FK, NULL
ICRViewID
Foreign key to a description of how the ICM software 
interprets the Schedule_Import data for the schedule.
int
FK, NULL
ScheduleType
The type of the schedule:
1   =   TCS
2   =   Custom
5  =  Report Export
6   =   Periodic
int
NOT NULL