Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Database Table Names 3-7
Database Table Names 3
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 ODBC-accessible in
CentreVu CMS and a brief description of the
data in each. If a table is not listed here, it is not accessible through
ODBC, but will still be accessible by root. All tables included in this
chapter have read-only external user access. The database items are
described later in this chapter.
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.