Cisco Cisco IP Contact Center Release 4.6.1 Technical References
A four-byte floating-point value (7-digit precision).
NULL
real
DBFLT4
An eight-byte floating-point value (15-digit precision).
fl
oat
fl
oat
DBFLT8
A date and time accurate to the minute. Stored as two
unsigned two-byte integers (four bytes total): number
unsigned two-byte integers (four bytes total): number
smalldatetime
smalldatetime
DBSMALLDATE
of days since January 1, 1900 and minutes since
midnight.
A four-byte integer value between -2,147,483,648 and
2,147,483,647.
midnight.
A four-byte integer value between -2,147,483,648 and
2,147,483,647.
NULL
int
DBINT
A two-byte integer value between -32,768 and 32,767.
NULL
smallint
DBSMALLINT
Up to 255 characters. The value 255 is the storage size.
NULL
varchar(255)
DESCRIPTION
A one-byte integer value between 0 and 255.
NOT NULL
tinyint
DBTINYINT
Up to 10 characters. The value 10 is the storage size.
NULL
char (10)
TELNO
Up to 32 characters. The value 32 is the storage size.
varchar(32)
varchar(32)
VNAME32
Up to 10 characters. The value 10 is the storage size.
NULL
varchar(10)
VTELNO10
Up to 20 characters. The value 20 is the storage size.
NULL
varchar(20)
VTELNO20
Up to n characters. The value n is the storage size.
NULL
char(n)
char(n)
Up to n characters. The value n is the storage size.
NULL
varchar(n)
varchar(n)
Up to 2,147,483,647 bytes of binary data. The storage
size is determined by the length of the data.
size is determined by the length of the data.
NULL
image
image
A date and time accurate to the second. Stored as two
four-byte integers (eight bytes total): days before or
since January 1, 1900 and seconds since midnight.
four-byte integers (eight bytes total): days before or
since January 1, 1900 and seconds since midnight.
NULL
datetime
datetime
A date and time accurate to the minute. Stored as two
unsigned two-byte integers (four bytes total): number
unsigned two-byte integers (four bytes total): number
NULL
smalldatetime
smalldatetime
of days since January 1, 1900 and minutes since
midnight.
midnight.
Partitioning
Customers who enable partitioning can refer to the ICM Administration Guide for Cisco ICM
Enterprise Edition
Enterprise Edition
for information about security related to partitioning.
Real-time and Historical Data
ICM/IPCC software maintains real-time and historical status information about certain objects
in the system such as service, skill groups, routes, and scripts.
in the system such as service, skill groups, routes, and scripts.
For example, the Route Real Time table contains real-time information about each route. The
Route Five Minute and Route Half Hour tables contain historical information about each route.
The Route Real Time table contains one row for each route. (It has a one-to-one relationship
with the Route table.) The Route Half Hour table contains many rows for each route—ICM/IPCC
software adds an additional row for each route every half hour. (It has a one-to-many relationship
with the Route table.)
Route Five Minute and Route Half Hour tables contain historical information about each route.
The Route Real Time table contains one row for each route. (It has a one-to-one relationship
with the Route table.) The Route Half Hour table contains many rows for each route—ICM/IPCC
software adds an additional row for each route every half hour. (It has a one-to-many relationship
with the Route table.)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
15
Chapter 1: Introduction
Real-time and Historical Data