Instruction manual

Database Tables
CentreVu®
CMS Open Database Connectivity
Agent Login/Logout Database Items 3-123
LOGIN
The time at which the agent logged into this extension
and split/skill with the given login ID. This field is a
standard UNIX time field; that is, the time is stored as
the number of seconds since January 1, 1970.
integer 4 bytes
LOGONSKILL2-20 The second through twentieth skills the agent logged in
with. NOTE: The number of skills per agent depends on
the type of switch. For example, prior to the ECS,
LOGONSKILL5 is only available on Generic 2.2
switches.
Available on the ECS with the EAS feature and the
Generic 2.2 and later Generic 3 switches with the EAS
feature.
smallint 2 bytes
LOGOUT The time at which the agent logged out. This field is a
standard UNIX time field; that is, the time is stored as
the number of seconds since January 1, 1970.
integer 4 bytes
LOGOUT_DATE The date on which the agent logged out. date 4 byte
Informix
date
LOGOUT_REASON 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 a 0
when the agent has logged out.
smallint 2 bytes
OUTFLAG If not null, this item indicates that the agent logged out
while the link was down. Values are NULL and “>.”
char(1) 1 byte
ASCII
text
string
PREFERENCE The agent's call handling preference. Values are NEED
(greatest need) LVL (skill level), and PCNT (percent
allocation).
Requires a
DEFINITY
ECS R5 or R6 with EAS. PCNT
is only available on the ECS R6.
integer 4 bytes
SKLEVEL This item indicates the agent's skill level (1-16) for a
normal skill or reserve level (1 or 2) for a reserve skill.
This SKLEVEL applies to LOGONSKILL.
Requires a
DEFINITY
ECS R5 or R6 with EAS.
Reserve levels are only available on the ECS R6.
integer 4 bytes
Database Item Description
Column
Type
Length