Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-155
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Region_Member Table
Region_Member Table
Each row defines the relationship between two regions. A region is composed of calling line ID prefixes
or of other regions. Each Region_Member row associates a region with a parent region.
or of other regions. Each Region_Member row associates a region with a parent region.
Use Configuration Manager to create, update, and delete Region Member rows.
Related tables:
Region (via RegionID and ParentRegionID)
Region_Prefix Table
Each row defines the initial part of a calling line ID and maps it to a region. Any calling line IDs that
match the prefix string are assumed to be members of the region.
match the prefix string are assumed to be members of the region.
Use Configuration Manager to create, update, and delete Region Prefix rows.
Related tables:
Region(via RegionID)
Table 2-134 Region_Member Table
Field Name
Description
Data Type
Keys and Null
Option
Option
RegionID
The region that is a member of a larger region.
int
PK, FK, NOT
NULL
NULL
ParentRegionID
The larger region.
int
PK, FK, NOT
NULL
NULL
Table 2-135 Region_Prefix Table
Field Name
Description
Data Type
Keys and Null
Option
Option
RegionPrefixID
A unique identifier for the record.
int
PK, NOT NULL
RegionPrefix
An initial string to match against calling line IDs.
varchar(32)
NOT NULL
RegionID
Identifies the associated region.
int
FK, NOT NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
GMT
Indicates Greenwich Mean Time (GMT) delta in minutes. int
NOT NULL
DaylightSavingsStart
The start of daylight savings time.
datetime
NULL
DaylightSavingsEnd
The end of daylight savings time.
datetime
NULL