Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Current Day Configuration Forecast Database Items 3-131
Current Day Configuration Forecast Database Items 3
Overview 3
The Current Day Configuration database item descriptions are historical
items used specifically to collect values entered in the Forecast: Current
Day window. They apply to the Current Day (
f_cday
) table. The indexes
are ACD, ROW_DATE and SPLIT.
Current Day
Configuration
Forecast
Database Items
3
The following table describes the data items in the CMS Current Day
Configuration Forecast database table.
Database Item Description
Column
Type
Length
ACD
(index)
The ACD number for which data was collected. smallint 2 bytes
CHANGE The additional change factor (percent). smallfloat 4 byte
Informix
floating
point
type
CHPROF The number of the call handling profile to use. smallint 2 bytes
FMETHOD The type of trending to use for forecast. Values
are
0 = none, 1 = seasonal, 2 = current trending.
smallint 2 bytes
HDATE1-4 The date of first (HDATE1), second (HDATE2),
third (HDATE3), and fourth (HDATE4) days of
historical data to be used.
date 4 byte
Informix
date
ROW_DATE
(index)
The day for which data was collected or the
exception occurred.
date 4 byte
Informix
date
SPLIT
(index)
The split/skill number for which data was
collected
smallint 2 bytes