Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
How Database Items are Presented 3-6
Circular Structure 3
The exceptions, call record, and agent trace tables are circular files.
These tables will continuously populate until the table capacity plus ten
percent has been reached; at which point, the oldest ten percent of the
records will be deleted. For example, if an agent trace table has a
capacity of 100 rows, and the total rows populated equals 110, the oldest
ten rows will automatically be deleted. Therefore, the data in that table
will change continuously as the table is updated.
Terminology 3
For definitions of terms used in database item descriptions, see the
CentreVu
®
CMS R3V8 Database Items and Calculations (585-210-939)
document, and the Glossary in this document.
CMS Feature
Interactions
3
●
Dictionary Names: Clients can access CMS Dictionary names. The
client must map the synonym to the report.
●
Permissions: Applications which access Informix externally, such
as database access scripts, may not work if the table permission
script tries to access a table to which permission is denied.
●
Field Display: The time and date data you receive from the
database may not be formatted. Generally, times may be shown in
seconds or in military format. You will need to review data for
formatting when you import it into your software application. The
data returned from your SQL queries will be formatted in the manner
described in your database interface specifications. See your
software’s documentation for further information on formatting data.
Interactions with
ECS Features
and Tracking of
ECS Capabilities
3
Some of the ECS features and capabilities have an impact on CentreVu
CMS open database items. For more information on these features and
capabilities and their relationship with the
CentreVu CMS open database,
see the
CentreVu
®
CMS R3V8 Database Items and Calculations (585-
210-939) document.