Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-422
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
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-381 Trunk_Group_Real_Time Table Constraints
Constraint
Field Name(s)
PK
TrunkGroupID
FK
TrunkGroupID
Table 2-382 Trunk_Group_Real_Time Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
AllTrunksBusyHalf
Total number of seconds during the current
half-hour interval that all trunks in the group were
busy.
half-hour interval that all trunks in the group were
busy.
DBINT
NULL
AllTrunksBusyToday
Total number of seconds since midnight that all
trunks in the group were busy.
trunks in the group were busy.
DBINT
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.
DBINT
NULL
CallsAbandonedToday
Number of calls to the trunk group abandoned in
queue since midnight.
queue since midnight.
DBINT
NULL
CallsInHalf
Number of inbound calls received on the trunk
group during the current half-hour interval.
group during the current half-hour interval.
DBINT
NULL
CallsInNow
Number of inbound calls currently in progress on
the trunk group.
the trunk group.
DBINT
NULL
CallsInToday
Number of inbound calls received on the trunk
group since midnight.
group since midnight.
DBINT
NULL
CallsOutHalf
Number of outbound calls received on the trunk
group during the current half-hour interval.
group during the current half-hour interval.
DBINT
NULL
CallsOutNow
Number of outbound calls currently in progress on
the trunk group.
the trunk group.
DBINT
NULL
CallsOutToday
Number of outbound calls received on the trunk
group since midnight.
group since midnight.
DBINT
NULL
DateTime
Central Controller date and time that this data was
last updated.
last updated.
DBDATETIME
NOT NULL
InServiceTimeHalf
Aggregate number of seconds trunks in the group
have been in service during the current half-hour
interval.
have been in service during the current half-hour
interval.
DBINT
NULL
InServiceTimeToday
Aggregate number of seconds trunks in the group
have been in service since midnight.
have been in service since midnight.
DBINT
NULL