Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Agent Login/Logout Database Items 3-122
Agent Login/Logout Database Items 3
Overview 3
The Agent Login/Logout database item descriptions are historical items
that apply specifically to the Agent Login/Logout (
haglog
) table. The
indexes are ACD, SPLIT and ROW_DATE.
Agent
Login/Logout
Database Items
3
The following table describes the data items in the CMS Agent
Login/Logout database table.
Database Item Description
Column
Type
Length
ACD (index) The ACD number for which data was collected. smallint 2 bytes
EXTN the extension number of the station that the agent
staffed.
char(6) 6 byte
ASCII
text
string
INFLAG If not null, indicates that agent was already logged in
when the link came up. Values are NULL and “<.”
char(1) 1 byte
ASCII
text
string
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 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