Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-63
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Bucket_Intervals Table
Bucket_Intervals Table
This configuration table holds the definition for Bucket Intervals that are used for Call type reporting.
The Intervals are in sequentially increasing order, with the unused intervals having a NULL value.
The Intervals are in sequentially increasing order, with the unused intervals having a NULL value.
Use the Configuration Manager Bucket Interval List Tool to modify Bucket intervals.
A default record is createdcontaining the following initial data for the Bucket_Intervals table.
Table 2-53 Bucket_Intervals Table Constraints
Constraint
Field Name(s)
PK
BucketIntervalID
AK-1
EnterpriseName
Table 2-54 Bucket_Intervals Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
BucketIntervalID
The primary key for this table.
DBINT
PK
NOT NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
Deleted
The default is N.
DBCHAR
NOT NULL
EnterpriseName
The enterprise name for this table.
VNAME32
AK-1
NOT NULL
IntervalUpperBound1
Upper bound in seconds of interval 1
DBINT
NULL
IntervalUpperBound2
Upper bound in seconds of interval 2
DBINT
NULL
IntervalUpperBound3
Upper bound in seconds of interval 3
DBINT
NULL
IntervalUpperBound4
Upper bound in seconds of interval 4
DBINT
NULL
IntervalUpperBound5
Upper bound in seconds of interval 5
DBINT
NULL
IntervalUpperBound6
Upper bound in seconds of interval 6
DBINT
NULL
IntervalUpperBound7
Upper bound in seconds of interval 7
DBINT
NULL
IntervalUpperBound8
Upper bound in seconds of interval 8
DBINT
NULL
IntervalUpperBound9
Upper bound in seconds of interval 9
DBINT
NULL
Table 2-55 Bucket_Intervals Table - Initial Data
BucketIntervalID
1
EnterpriseName
Default_Bucket_Interval
IntervalUpperBound1
8
IntervalUpperBound2
30
IntervalUpperBound3
60