Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Current Day Forecast Report Database Items 3-133
Current Day Forecast Report Database Items 3
Overview 3
The Current Day Forecast Report database item descriptions are
historical items used specifically to collect values displayed in the
Current Day Forecast report, and they apply to the Current Day Report
(
f_cdayrep
) table. The indexes are ACD, ROW_DATE and SPLIT.
Forecast data for a split/skill are automatically generated when the
Forecast Manager runs (if you have also completed a Current Day
Configuration for the split/skill).
Current Day
Forecast Report
Database Items
3
The following table describes the data items in the CMS Current Day
Forecast Report database table.
Database Item Description
Column
Type
Length
ACD (index) The ACD number for which data was collected. smallint 2 bytes
AGOCC The objective maximum percentage of time that
an agent will be on ACD calls (agent
occupancy).
smallfloat 4 byte
Informix
floating
point
type
AVGAGSERV The objective average number of seconds for an
agent to service a call.
smallint 2 bytes
AVGSPEEDANS The objective average speed of answer in
seconds for this type of call.
smallint 2 bytes
FCALLS The number of forecast calls carried. integer 4 bytes
INTRVL The length of intrahour interval (15, 30, or 60).
INTRVL applies to intrahour tables only.
smallint 2 bytes
NUMAGREQ The number of agents required to handle
FCALLS.
smallint 2 bytes