Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Agent Group Database Items 3-151
Agent Group Database Items 3
Overview 3
The Agent Group database items descriptions in the following able apply
to items in the agroups table. The table contains dictionary information on
agent groups. The indexes are ACD_NO, ITEM_TYPE, ITEM_NAME,
and VALUE. because the data contained in the agroups table are
administrative and are used to define agent groups, the table is not
dependent on ECS releases.
Agent Group
Database Items
3
The following table describes the data items in the CMS Agent Group
database dictionary table.
Database Item Description
Data
Type
Column
Type
Length
ACD_NO (index) The ACD number for which data
was collected.
A smallint 2 bytes
ITEM_TYPE
(index)
The type “agent group.” A char(20) 20 byte
ASCII
text string
ITEM_NAME
(index)
The name of the agent group. A char(20) 20 byte
ASCII
text string
VALUE (index) An agent login ID belonging to the
agent group.
A char(9) 9 byte
ASCII
text string