The following table lists historical database tables and the data that are stored in them:
Name |
Data stored |
Interval |
hsplit |
split/skill |
intrahour |
dsplit |
split/skill |
day |
wsplit |
split/skill |
week |
msplit |
split/skill |
month |
hagent |
agent |
intrahour |
dagent |
agent |
day |
wagent |
agent |
week |
magent |
agent |
month |
htkgrp |
trunk group |
intrahour |
dtkgrp |
trunk group |
day |
wtkgrp |
trunk group |
week |
mtkgrp |
trunk group |
month |
htrunk |
trunk |
intrahour |
dtrunk |
trunk |
day |
wtrunk |
trunk |
week |
mtrunk |
trunk |
month |
hvector |
vector |
intrahour |
dvector |
vector |
day |
wvector |
vector |
week |
mvector |
vector |
month |
hvdn |
VDN |
intrahour |
dvdn |
VDN |
day |
wvdn |
VDN |
week |
mvdn |
VDN |
month |
hcwc |
CWC |
intrahour |
dcwc |
CWC |
day |
wcwc |
CWC |
week |
mcwc |
CWC |
month |
call_rec |
Call record |
not applicable |
agex |
Agent exceptions |
not applicable |
spex |
Split exceptions |
not applicable |
tgex |
Trunk group exceptions |
not applicable |
vecex |
Vector exceptions |
not applicable |
vdnex |
VDN exceptions |
not applicable |
linkex |
Link down exceptions |
not applicable |
mctex |
Malicious call trace exceptions |
not applicable |
f_cday |
Forecast current day configuration data by split/skill |
not applicable |
f_cdayrep |
Current day forecast data by split/skill |
not applicable |
haglog |
Agent login and logout information |
not applicable |
ag_actv |
Agent activity trace data |
not applicable |
