Instruction manual
Database Tables
CentreVu®
CMS Open Database Connectivity
Exceptions Historical Database Items 3-162
LOGID
The login ID of the agent reporting audio
difficulty.
char(10) 10 byte
ASCII
text
string
ROW_DATE The day for which data was collected or the
exception occurred.
date 4 byte
Informix
date
ROW_TIME The time at which the exception occurred. smallint 2 bytes
SEQNO The sequence number of this exception
record.
integer 4 bytes
THRESHOLD The limit, as a number of occurrences,
administered for the exception type. An
exception occurs when the trunk group’s
activity falls outside of that limit.
smallint 2 bytes
TIME The limit, as a number of seconds,
administered for timed exception types. An
occurrence is logged against the threshold
when the trunk group’s activity falls outside of
that limit.
smallint 2 bytes
TKGRP The trunk group number for which data was
collected (or for which an exception
occurred). This will be zero if the trunk group
carrying the call is not measured.
smallint 2 bytes
Database Item Description
Column
Type
Length