Database item types

Last Updated : Aug 18, 2022 |
Prolog information
Each database item contains one of the following types of data:
Field
Description
Administrative data
The data that is administered on the communication server or CMS. For example, the database item INTRVL in the split/skill real-time table contains the number of minutes in the intrahour interval (15, 30, 60) currently assigned to the specified split/skill on CMS
Busy Hour data
The data that is only meaningful for the busy hour.
Cumulative data
The data that is accumulated throughout the collection interval. Most real-time database items contain cumulative data.
Maximum Interval Value data
The data that is reached for any value in the specified interval.
Row Identifier data
The data that is common to all tables, such as time, date, and split in the split/skill tables
Special Table data
The data that is belonging only to a specific table, such as the Historical Agent Login/Logout table or Current Day Forecast table.
Status data
The data that is showing the current status such as a snapshot of a particular ACD element). For example, the database item INQUEUE in the split/skill real-time table contains the number of split/skill calls currently waiting in queue.
The type of data that each database item contains is specified at the end of the database item definition in Dictionary of CMS database items.