Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Agent Trace Database Items 3-128
LOC_ID
The
DEFINITY port network location ID that is
associated with an agent upon login to the ACD. A
location ID is not directly assigned to an agent;
instead, it is associated with the equipment location
of the voice terminal that the agent uses to log into
the ACD. Therefore, only when an agent logs into
the ACD can the agent become associated with a
location ID. Valid values are 01-44.
integer 4 bytes
LOGID
(index)
The login ID that was used to staff the
EXTENSION. Agents in multiple splits/skills have
one LOGID.
char(10) 10 byte
ASCII
text
string
LOGOUTREASON The reason code (0 through 9) associated with the
agent’s logout. For switch releases earlier than the
ECS or switch releases that do not have the EAS
feature and reason codes active, this field will
always contain 0 when the agent has logged out.
smallint 2 bytes
MCT The agent activated a malicious call trace.
Available on Generic 2 and Generic 3 (except for
Generic 3i Version 1) switches.
char(1) 1 byte
ASCII
text
string
RECONNECT This event represents the agent reconnecting to
the call after putting it on hold.
Available on Generic 2 and Generic 3 (except for
Generic 3 Version 1) switches.
char(1) 1 byte
ASCII
text
string
ROW_DATE
(index)
The day for which data was collected or the
exception occurred.
date 4 byte
Informix
date
SPLIT The split number to which the EXTENSION is
assigned or the skill number the agent logged into.
smallint 2 bytes
STARTTIME The time of day (hour and minute) for which the
agent trace is being ordered. This is the time of day
you enter to request the report.
smallint 2 bytes
Database Item Description
Column
Type
Length