Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Database Table Names 3-8
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.
Name Data Stored