Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Agent Login/Logout Database Items 3-124
SKLEVEL2-20
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 SKLEVEL2-20 applies to LOGONSKILL2-20.
Requires a
DEFINITY ECS R5 or R6 with EAS.
Reserve levels are only available on the ECS R6.
integer 4 bytes
SKPERCENT The agent’s percent allocation for LOGONSKILL.
Requires a
DEFINITY ECS R6 with EAS.
integer 4 bytes
SKPERCENT2-20 The agent’s percent allocation for LOGONSKILL2-20.
Requires a
DEFINITY ECS R6 with EAS.
integer 4 bytes
ROW_DATE
(index)
The day for which data was collected or the exception
occurred.
date 4 byte
Informix
date
SKILLTYPE The type (“p” for primary or “s” for secondary) of the
second, third, and fourth skills the agent logged into.
NOTE: For the ECS and later switch releases with the
EAS feature, skill level 1 will be represented by “p,” skill
level 2 will be represented by “s,” and skill levels 3
through 16 by blank. Users of more than 2 skill levels
should use SKLEVEL instead of SKILLTYPE items.
Available for Generic 3 switches with EAS and requires
Generic 2.2 or Generic 3 Version 2 switches with EAS.
char(1) 1 byte
ASCII
text
string
SKILLTYPE2-4 The type (“p” for primary or “s” for secondary) of the
second, third, and fourth skills the agent logged into.
Requires Generic 2.2 or Generic 3 Version 2 switches
with EAS.
NOTE: For the ECS and newer EAS releases, skill level
1 will be represented by “p”, skill level 2 by “s” and skill
levels 3-16 by blank. Users of more than 2 skill levels
should use SKLEVEL items instead of SKILLTYPE
items.
char(1) 1 byte
ASCII
text
string
SKLEVEL The skill level (from 1 through 16) associated with the
first skill the agent logged into.
smallint 2 bytes
SKLEVEL2-20 The skill levels (from 1 through 20) associated with the
second through twentieth skills (LOGONSKILL2
through LOGONSKILL20) the agent logged into.
smallint 2 bytes
SPLIT
(index)
The split number to which the extension is assigned or
skill number the agent logged into.
smallint 2 bytes
Database Item Description
Column
Type
Length