CentreVu
®
Advocate Database Items and Calculations
CentreVu® Advocate Release 8 User Guide
How Database Items and Calculations Are Presented
13-3
Index Database
Items
0
The index database items in each table are marked. Indexes add
structure to table rows so that
CentreVu CMS can retrieve data faster.
The row search criteria you define for custom reports should be based on
indexes whenever possible. For historical custom reports, always include
a “where” clause based on the ROW_DATE database item.
Database Item
Types
0
Each database item contains one of the following types of data:
●
C =Cumulative data: accumulates throughout the collection
interval. Most real-time database items contain cumulative data.
●
A =Administrative data: administered on the switch or on
CentreVu 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
CentreVu CMS.
●
S =Status data: gives the current status (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.
●
I = Row Identifier data: gives data that is common to all tables,
such as time, date, split in the split/skill tables, and so on.
●
N = Special Table data: belongs only to a specific table, such as
the Historical Agent Login/Logout table or Current Day Forecast
table.
●
M = Maximum Interval Value data: gives data that is the maximum
reached for any value in the specified interval.
●
B = Busy Hour data: gives data that is only meaningful for the busy
hour.
The letter C, A, S, I, N, M, or B appears in the Type column for each
database item.
Historical and Real-
Time Data
0
Cumulative, Administrative, Maximum Value, Row Identifier and
Busy Hour data items apply to historical and real-time database items.
Status items apply only to real-time database items. Special Table data
items apply only to historical database items.
Содержание CentreVu Advocate
Страница 1: ...CentreVu Advocate Release 8 User Guide 585 210 927 Comcode 108502162 Issue 1 December 1999...
Страница 118: ...Call Center Solution Handle Any Media CentreVu Advocate Release 8 User Guide Things to Note 4 26...
Страница 138: ...Call Center Solution Minimize Abandoned Calls CentreVu Advocate Release 8 User Guide Things to Note 5 20...
Страница 200: ...Call Center Solution Better Serve Selected Callers CentreVu Advocate Release 8 User Guide Things to Note 8 16...
Страница 220: ...Call Center Solution Control Agent Time in Skill CentreVu Advocate Release 8 User Guide Things to Note 9 20...
Страница 264: ...Administer CentreVu Advocate on DEFINITY ECS CentreVu Advocate Release 8 User Guide Feature Interactions 11 32...
Страница 302: ...CentreVu Advocate Database Items and Calculations CentreVu Advocate Release 8 User Guide Calculations 13 24...
Страница 326: ...Glossary CentreVu Advocate Release 8 User Guide GL 24...
Страница 338: ......