Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Exceptions Historical Database Items 3-161
*Available only on Generic 2 and Generic 3 ECS
†Available only with Generic 2.2 ECS with the ASAI Gateway Interface
feature and Generic 3 ECS with the ASAI feature.
** Available only with Generic 2.1 or later and Generic 3 ECS.
Trunk Group
Exceptions
Database Items
3
The following table describes the historical Trunk Group Exceptions
database s. They apply to the Trunk Group Exceptions (
tgex
) table.
TIME The limit, as a number of seconds, administered for timed
exception types. An occurrence is logged against the threshold
when the split’s/skill’s activity falls outside of that limit.
smallint 2 bytes
Database
Item
Description
Column
Type
Length
Database Item Description
Column
Type
Length
ACD (index) The ACD number for which data was
collected.
smallint 2 bytes
EXTYPE The type of exception that occurred:
Numerical
Value Type
50 Time trunk in use (min)
51 Time trunk in use (max)
52 Number of trunks in use
53 Time any trunk maintenance
busy
54 Number of trunks maintenance
busy
55 Length of time all trunks busy
56 Number trunk failures in group
57 Number failures on a single trunk
58 Audio difficulty on a trunk
smallint
2 bytes
EQLOC The physical equipment location (trunk
number) for which data was collected or the
exception occurred.
For the
DEFINITY ECS R8, this field is eight
characters. For previous switch releases, it is
nine characters.
char(9) 9 byte
ASCII
text
string