Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
How Database Items are Presented 3-2
How Database Items are Presented 3
Database Item
Tables
3
The database items are presented in a table format, according to ACD
entity (split/skill, agent, vector, VDN, trunk, trunk group, exception,
synonym, call work code, and forecast).
Sample Database
Item Table
3
The following table is an example of how the table information is
presented:
Many database items appear in more than one database table. When an
item is in more than one table, the definition is probably not the same
from table to table. Database items that are used in the description of
another database item are in boldface type. Where applicable, Enterprise
Communications Server (ECS) information has been included in the
database item descriptions.
If you are using a G2.2 ECS without the Call Center Features (CCF = N),
you should refer to information for the G2.1 ECS for functionality.
Index Database
Items
3
The index database items in each table are marked. Indexes add
structure to table rows so that
CentreVu CMS can retrieve data faster.
The row search criteria you define for custom reports should be based on
indexes whenever possible. For historical custom reports, always include
a “where” clause based on the ROW_DATE database item.
Database Item Description
Data
Type
Column
Type
Length
DATABASE
ITEM
The definition of the database item is given
here. Any additional information, such as
other database items that are included in the
sum of the database item, or the specific
ECS release to which the database item
applies, is also listed.
C, A, I,
N, M,
or B
integer,
smallint,
date,
smallfloat,
or char(n)
length in
bytes
NOTE: