CMS database table names

Last Updated : Nov 15, 2024 |

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.

Table 1: ODBC accessible tables

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