Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Exceptions Historical Database Items 3-160
Split/Skill
Exceptions
Database Items
3
The following table describes the historical Split/Skill Exceptions
database items. They apply to the Split/Skill Exceptions (
spex
) table.
Database
Item
Description
Column
Type
Length
ACD The ACD number for which data was collected. smallint 2 bytes
EXTYPE The type of exception that occurred:
Numerical
Value Type
30 Number calls waiting
31 Time call has waited in queue
32 Number calls abandoned
33 Number intraflowed-in calls
34 Number intraflowed-out calls
35 Number interflowed-out calls
36 Number calls offered while queue full*
37 Number calls handled as backup†
38 Number calls transferred**
39 Average speed of answer (seconds)
40 Rolling average speed of answer
(seconds)
41 Expected wait time (priority top)
42 Expected wait time (priority high)
43 Expected wait time (priority medium)
44 Expected wait time (priority low)
smallint
2
bytes
ROW_DATE
(index)
The day for which data was collected or the exception
occurred.
date 4 byte
Informix
date
ROW_TIME The time at which the exception occurred. smallint 2 bytes
SEQNO The sequence number of this exception record. integer 4 bytes
SPLIT The split/skill in which the exception occurred. smallint 2 bytes
THRESHOLD The limit, as a number of occurrences, administered for the
exception type. An exception occurs when the split's/skill's
activity falls outside of that limit.
smallint 2 bytes