AVAYA DOCUMENTATION CENTER
Find answers to your technical questions and learn how to use our products
No results found
Search suggestions:
- Use fewer tags and filters.
- Use different search terms.
Filters
AVAYA DOCUMENTATION CENTER
Find answers to your technical questions and learn how to use our products
No results found
Search suggestions:
- Use fewer tags and filters.
- Use different search terms.
Filters
Avaya Call Management System Database Items and Calculations
Table of Contents
Type to filter navigation items by title
CMS database table names
Last Updated : Nov 15, 2024 |
Prolog information
Metadata
Keywords:
To select data for external use, you must use the names listed in the following table in your queries. The following table contains all the tables that are accessible in CMS and a brief description of the data in each. The table will still be accessible by root. All tables included in this chapter have read-only external user access.
|
Name
|
Data stored
|
|---|---|
|
hsplit
|
Split/Skill data for each intrahour interval
|
|
dsplit
|
Split/Skill data summarized by day
|
|
wsplit
|
Split/Skill data summarized by week
|
|
msplit
|
Split/Skill data summarized by month
|
|
hagent
|
Agent data for each intrahour interval
|
|
dagent
|
Agent data summarized by day
|
|
wagent
|
Agent data summarized by week
|
|
magent
|
Agent data summarized by month
|
|
htkgrp
|
Trunk group data for each intrahour interval
|
|
dtkgrp
|
Trunk group data summarized by day
|
|
wtkgrp
|
Trunk group data summarized by week
|
|
mtkgrp
|
Trunk group data summarized by month
|
|
htrunk
|
Trunk data for intrahour interval
|
|
dtrunk
|
Trunk data summarized by day
|
|
wtrunk
|
Trunk data summarized by week
|
|
mtrunk
|
Trunk data summarized by month
|
|
hvector
|
Vector data for each intrahour interval
|
|
dvector
|
Vector data summarized by day
|
|
wvector
|
Vector data summarized by week
|
|
mvector
|
Vector data summarized by month
|
|
hvdn
|
VDN data for each intrahour interval
|
|
dvdn
|
VDN data summarized by day
|
|
wvdn
|
VDN data summarized by week
|
|
mvdn
|
VDN data summarized by month
|
|
hcwc
|
Call work code data for each intrahour interval
|
|
dcwc
|
Call work code data summarized by day
|
|
wcwc
|
Call work code data summarized by week
|
|
mcwc
|
Call work code data summarized by month
|
|
call_rec
|
Call record data
|
|
d_secs
|
The number of seconds in the daily data collection period
|
|
m_secs
|
The number of seconds in the monthly data collection period
|
|
w_secs
|
The number of seconds in the weekly data collection period
|
|
arch_stat
|
The status of archiver executions
|
|
customer_log
|
The customer error log data
|
|
agroups
|
Agent group definitions
|
|
synonyms
|
Dictionary synonyms
|
|
acd_shifts
|
Shift times and maximum agents logged in for each shift
|
|
dbitems
|
Dictionary standard and custom database items, constants, and calculations
|
|
f_cday
|
Forecast current day configuration data by split/skill
|
|
f_cdayrep
|
Current day forecast data by split/skill
|
|
haglog
|
Agent login and logout information
|
|
ag_actv
|
Agent activity trace data
|
|
agex
|
Agent exceptions
|
|
fullex
|
Disk full exceptions
|
|
spex
|
Split/skill exceptions
|
|
tgex
|
Trunk group exceptions
|
|
vecex
|
Vector exceptions
|
|
vdnex
|
VDN exceptions
|
|
linkex
|
Link down exceptions
|
|
mctex
|
Malicious call trace exceptions
|