Instruction manual
Database Tables
CentreVu®
CMS Open Database Connectivity
How Database Items are Presented 3-5
Sample ECS Cross-
Reference Table
3
The following table is an example of how the table information is
presented:
If you are using the G2.2 ECS without the Call Center Features (CCF =
N), you should refer to the G2.1 column for functionality
Database Logic
Structure
3
CMS historical tables store information in one record per row format. This
formatting affects the way data can be accessed through ODBC. For
example, in the agent tables, a record will be created for each split/skill
that an agent is logged into. If an agent is logged into four splits/skills,
there will be four records for that agent. Similarly, if an agent starts the
day with four splits/skills, and is added to a fifth split/skill before the end
of the day, the agent’s fifth record will be generated only from the point at
which the additional split/skill was added. The other four records will
reflect the total logon time. When accessing data in the historical
tables,
you may need to sum the information to retrieve complete data.
Agent Tables 3
If an agent logged off and logged on more than once in a specified
interval, another complete set of records will be created for that agent for
each logon in the agent tables. If an agent logs into four split/skills, logs
out, and then logs back on during a set interval, there will be two sets of
four records for that agent, one set per logon.
VDN Tables 3
The VDN tables store one record per vector on which a VDN terminates.
Therefore, if the terminating vector for a specific VDN changes in a set
interval, there will be two records for that VDN—one per terminating
vector. This logic also applies to the Vector, Trunk, Trunk Group, and
Split/Skill tables. If information is required from these tables, a sum
structured query language (SQL) query may be necessary to access
complete data for each VDN, vector, trunk, and so on.
NOTE:
Database
Item
G3V2/
G3V3 G3V4
DEFINITY®
ECS R5
DEFINITY
ECS R6
DEFINITY
ECS R7
DEFINITY
ECS R8
ITEM NAME XXX X X X
ECS releases that this database item applies to are marked with X’s.