Cisco Cisco Administrative Workstation Technical References

Page of 404
 
2-179
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Routing_Client_Five_Minute Table
Routing_Client_Five_Minute Table
Central database only.
Contains statistics for each routing client during the most recent five-minute interval.
The ICM software generates Routing_Client_Five_Minute records for each routing client.
Table 2-145 Routing_Client_Five_Minute Table
Field Name
Description
Data Type
Keys and Null 
Option
DateTime
Central Controller date and time at the start of the 
five-minute interval.
smalldatetime
PK, NOT 
NULL
RoutingClientID
Foreign key from Routing Client table.
smallint
PK, FK, NOT 
NULL
PhysicalControllerID
Foreign key from Physical Interface Controller 
table.
smallint
PK, FK, NOT 
NULL
TimeZone
The time zone for the date and time. The value is 
the offset in minutes from GMT.
int
PK, NOT 
NULL
ResponsesTo5
Number of route responses to the routing client 
during the five-minute interval.
int
NOT NULL
MeanResponseTo5
Mean time, in milliseconds, for the responses to 
the routing client during the five-minute interval.
int
NOT NULL
RcvInErrorTo5
Number of requests from the routing client that 
produced errors during the five-minute interval.
Note
This field will increment only when:
- A pre-routed (that is, translation-routed) 
call terminates before reaching its 
destination target for reasons other than 
exceeding the late threshold, timing-out, 
or being discarded.
- A post-routed call terminates for reasons 
other than timing-out, being rejected for 
carrying duplicate invocation, due to an 
inactive Routing Client service, or being 
associated with Network Transfer. 
int
NOT NULL
TimeoutCallsTo5
Number of responses to the routing client that 
timed out during the five-minute interval.
int
NOT NULL
MaxDelay
Maximum delay, in milliseconds, of responses to 
the routing client during the five-minute interval.
int
NOT NULL
LateCallsTo5
Number of responses to the routing client that 
exceeded the late threshold but did not timeout.
int
NOT NULL
DiscardedCallsTo5
Number of requests from the routing client 
discarded because of an internal constraint, such 
as buffering.
int
NOT NULL