Instruction manual
Database Tables
CentreVu®
CMS Open Database Connectivity
Exceptions Historical Database Items 3-158
*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.
‡ Available only with Generic 3 ECS with the ASAI or EAS feature.
LOGID The login ID of the agent who had the exception. char(10) 10 byte
ASCII
text
string
REASON_
CODE
The reason code that the agent was in when the
exception occurred.
smallint 2 bytes
ROW_DATE
(index)
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
SPLIT The split/skill in which the agent was doing work when
the exception occurred.
smallint 2 bytes
THRESHOLD The limit, as a number of occurrences, administered
for the exception type. An exception occurs when the
agent’s activity falls outside of that limit.
smallint 2 bytes
TIME The limit, as a number of seconds, administered for
timed exceptions types. An occurrence is logged
against the threshold when the agent’s activity falls
outside of that limit.
smallint 2 bytes
Database
Item
Description
Column
Type
Length