SQL Query and CMS Database Table Basics
CentreVu Report Designer Version 8 User Guide
CMS Database Table Basics
18-8
Database Items
18
A database item is the name of a column of data in a table, either
standard or custom. When you enter a database item, you must always
add the name of a table and a period (.) as a prefix if more than on table
is included in the query. The format is <table name>.<database item>.
Examples:
dsplit.ACDCALLS
hagent.STARTTIME
ctkgrp.NUMINUSE
Standard Database
Items
18
Standard database items are listed in the Dictionary subsystem as having
all upper-case letters (as in the preceding examples).
A standard database item can store:
●
Identifiers (for example,
SPLIT
,
VDN
,
LOGID
, and so on)
●
Timed data (for example,
ACDTIME
,
ABANTIME
,
AUXOUTIME
, and
so on)
call_rec
Call record data.
agex
Agent exceptions.
spex
Split exceptions
tgex
Trunk group exceptions.
vecex
Vector exceptions.
vdnex
VDN exceptions.
linkex
Link down exceptions.
mctex
Malicious call trace exceptions.
f_cday
Forecast current day configuration data by split/skill.
f_cdayrep
Current day forecast data by split/skill.
haglog
Agent login/logout.
ag_actv
Agent trace.
call_rec
Call records.
Name
Data Stored
Summary of Contents for CentreVu Report Designer
Page 4: ......
Page 18: ...Introduction CentreVu Report Designer Version 8 User Guide Related Documents 1 8...
Page 102: ...Edit Inputs CentreVu Report Designer Version 8 User Guide Viewing the Input Window 6 16...
Page 198: ...Format Text CentreVu Report Designer Version 8 User Guide Formatting Text on the Report 15 4...
Page 264: ...Index CentreVu CMS R3V8 Upgrades and Migration IN 10...
Page 266: ......