Troubleshooting guide

228 Avaya CMS Supervisor Report Designer
How CMS stores data
This section includes the following topics:
● Table on page 228
● Database items on page 228
● Row on page 228
● Index on page 228
Table
CMS stores data in a CMS database that is divided into 52 different tables. A table is an
array of columns and rows that stores data for a type of ACD element (split/skill, agent,
trunk, trunk group, VDN, vector, call work code, forecasting, agent trace, call records, or
exceptions) and for a specific time frame (for the current intrahour interval, for past
intrahour intervals, for past day, summarized by day, and so on). If data in a table is in real
time, data changes second by second.
Database items
The CMS database uses names to refer to columns of data in a table. These names are
called database items. For a complete listing of database items, see the Avaya CMS
Database Items and Calculations document.
Row
Each row in a table contains data that is related by the values of one or more of the
columns. For example, each row in the Current Interval Agent table contains data related
by agent login ID.
Index
A column that causes the values in a row to be related is called an index. An index stores
data sequentially and adds structure for the storage of data in the other columns. For each