Instruction manual
Database Tables
CentreVu®
CMS Open Database Connectivity
Agent Trace Database Items 3-129
ECS Cross-
Reference
3
The following table lists which of the ECS releases support each Agent
Trace database item.
TRANSFERRED This item represents whether or not an answering
agent initiated a transfer for this call. Valid values
are YES and NO.
For Generic 2.1 switches, TRANSFERRED
includes transfers to measured VDNs or
splits/skills.
For Generic 3 and Generic 2.2 switches,
TRANSFERRED includes all calls that are
transferred.
char(1) 1 byte
ASCII
text
string
UCID The UCID is the Universal Call Identifier—a unique
number assigned to this call segment within the
customer network.
Requires the
DEFINITY
ECS R6.
char(20) 20 byte
ASCII
text
string
WMODE_SEQ The sequence number for events that occur in the
same second.
smallint 2 bytes
WORKCODE The call work code the agent entered for the call.
Available on Generic 3 and Generic 2.2 switches
with call work codes.
char(16) 16 byte
ASCII
text
string
WORKMODE The work mode in which the agent was working
during the trace.
Agent work modes include: AVAIL, ACD, ACW,
AUX, DACD, DACW, RING, UNKNOWN, OTHER,
and UNSTAFF. If the agent has not been logged in
during the collection interval, the value is blank.
smallint 2 bytes
Database Item Description
Column
Type
Length
Database Item
G3V2/
G3V3
G3V4 ECS R5 ECS R6 ECS R7 ECS R8
ACD X X XXXX
AGT_RELEASED X X XXXX
ASSIST_ACTV X X XXXX