Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Split/Skill Database Items 3-9
Split/Skill Database Items 3
Overview 3
The Split/Skill database item descriptions apply to historical items.
The Data Type column refers to Cumulative (C), Administrative (A),
Status (S), Row Identifier (I), Busy Hour (B), Special Table (N), or
Maximum Value (M) data. Cumulative, Administrative, Row Identifier,
Busy Hour, and Maximum Value items apply to both the current and
previous interval real-time tables. Special Table items are historical, and
apply only to the table in which they are stored.
Historical split/skill database items apply to the Intrahour Split/Skill
(
hsplit
), Daily Split/Skill (
dsplit
), Weekly Split/Skill (
wsplit
), and
Monthly Split/Skill (
msplit
) tables. All items listed in the following table
are included in all four tables, unless otherwise noted in the Column Type
column. Any differences in the data format between the four split/skill
tables are also noted in the Column Type column. The historical indexes
are SPLIT and ROW_DATE.
Split/Skill
Database Items
3
The following table describes the data items in the Split/Skill CMS
database tables.
Database Item Description
Data
Type
Column
Type
Length
ABNCALLS The number of CALLSOFFERED that were
abandoned while in queue or ringing at an
agent position.
For Generic 3 Version 1 switches with the
Vectoring feature, this also includes calls that
were queued to the split/skill and abandoned
while listening to a forced disconnect
announcement.
C integer;
smallint
in hsplit
table
4 bytes,
2 bytes
in hsplit
table