Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-284
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Trunk_Group_Real_Time Table
Trunk_Group_Real_Time Table
Local database only.
Contains real time information about each trunk group.
The ICM software generates a Trunk_Group_Real_Time record for each trunk group.
Table 2-187 Trunk_Group_Real_Time Table
Field Name
Description
Data Type
Keys and Null
Option
Option
TrunkGroupID
Foreign key from the Trunk Group table.
int
PK, FK, NOT
NULL
NULL
DateTime
Central Controller date and time that this data was last
updated.
updated.
datetime
NOT NULL
AllTrunksBusyHalf
Total number of seconds during the current half-hour
interval that all trunks in the group were busy.
interval that all trunks in the group were busy.
int
NULL
AllTrunksBusyToday
Total number of seconds since midnight that all trunks
in the group were busy.
in the group were busy.
int
NULL
CallsAbandonedHalf
Number of calls to the trunk group abandoned in
queue during the current half-hour interval.
queue during the current half-hour interval.
int
NULL
CallsAbandonedToday
Number of calls to the trunk group abandoned in
queue since midnight.
queue since midnight.
int
NULL
CallsInHalf
Number of inbound calls received on the trunk group
during the current half-hour interval.
during the current half-hour interval.
int
NULL
CallsInNow
Number of inbound calls currently in progress on the
trunk group.
trunk group.
int
NULL
CallsInToday
Number of inbound calls received on the trunk group
since midnight.
since midnight.
int
NULL
CallsOutHalf
Number of outbound calls received on the trunk group
during the current half-hour interval.
during the current half-hour interval.
int
NULL
CallsOutNow
Number of outbound calls currently in progress on the
trunk group.
trunk group.
int
NULL
CallsOutToday
Number of outbound calls received on the trunk group
since midnight.
since midnight.
int
NULL
InServiceTimeHalf
Aggregate number of seconds trunks in the group have
been in service during the current half-hour interval.
been in service during the current half-hour interval.
int
NULL
InServiceTimeToday
Aggregate number of seconds trunks in the group have
been in service since midnight.
been in service since midnight.
int
NULL
InUseInboundTimeHalf
Aggregate number of seconds trunks in the group have
been in use for inbound calls during the current
half-hour interval.
been in use for inbound calls during the current
half-hour interval.
int
NULL
InUseInboundTimeToday
Aggregate number of seconds trunks in the group have
been in use for inbound calls since midnight.
been in use for inbound calls since midnight.
int
NULL