Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-154
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Region Table
Region Table
Each row defines a region composed of calling line ID prefixes or of other regions.
Use Configuration Manager to create, update, and delete Region rows.
Related tables:
Dialed Number Map (via RegionID)
Region Member (via RegionID)
Region Prefix (via RegionID)
Region View Member (via RegionID)
Region_Info Table
Specifies which prefixes and regions are predefined by the ICM software.
Table 2-132 Region Table
Field Name
Description
Data Type
Keys and Null
Option
Option
RegionID
A unique identifier for the region.
int
PK, NOT NULL
EnterpriseName
An enterprise name for the region. This name must be
unique for all regions in the enterprise.
unique for all regions in the enterprise.
varchar(32)
NOT NULL
Description
Additional information about the region.
varchar(255)
NULL
RegionType
The type of the region.
int
NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-133 Region_Info Table
Field Name
Description
Data Type
Keys and Null
Option
Option
Location
Identifies the types of prefixes and regions pre-defined by
the ICM software.
the ICM software.
varchar(32)
NOT NULL
MajorVersion
The major version number of the predefined regions.
int
NOT NULL
MinorVersion
The minor version number of the predefined regions.
int
NOT NULL
Comment
Any additional information about the pre-defined
regions.
regions.
varchar(255)
NULL