Instruction manual

Database Tables
CentreVu®
CMS Open Database Connectivity
Exceptions Historical Database Items 3-166
Data Collection
Exceptions
Database Items
3
The following table describes the historical Data Collection Exceptions
database items. They apply to the Data Collection Exceptions (
linkex
)
table.
ROW_DATE The login ID of the agent initiating a
malicious call trace.
date 4 byte
Informix
date
ROW_TIME The date for which data was collected
or the exception occurred.
smallint 2 bytes
SEQNO The sequence number of this
exception record.
integer 4 bytes
SPLIT The split/skill of the agent reporting the
malicious call.
smallint 2 bytes
TKGRP The trunk group number for which data
was collected (or for which an
exception occurred). This will be zero if
the trunk group carrying the call is not
measured.
smallint 2 bytes
VDN The VDN for which the exception
occurred or that carried the malicious
call.
Available on Generic 2, Generic 3, and
newer switches with vectoring.
char(6) 6 byte
ASCII
text string
Database Item Description
Column
Type
Length
Database Item Description
Column
Type
Length
ACD (index) The ACD number for which data was collected. smallint 2 bytes
DURATION The length of time for which data collection was
off.
integer 4 bytes