Cisco Cisco Unified Intelligent Contact Management Software Technical References

Page of 620
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
The major version number of the predefined regions.
MajorVersion
NOT NULL
DBINT
The minor version number of the predefined regions.
MinorVersion
Region_Member Table
This table is part of the 
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.
Use Configuration Manager to create, update, and delete Region Member rows.
Related table
 (via RegionID and ParentRegionID)
Table 153: Indexes for Region_Member Table
index_keys
index_description
index_name
ParentRegionID
nonclustered located on PRIMARY
XIE1Region_Member
RegionID, ParentRegionID
clustered, unique, primary key
located on PRIMARY
XPKRegion_Member
Fields in Region_Member Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
PK, IE-1 NOT NULL
DBINT
The larger region.
ParentRegionID
PK, FK NOT NULL
DBINT
The region that is a member of a larger region.
RegionID
Region_Prefix Table
This table is part of the 
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.
Use Configuration Manager to create, update, and delete Region Prefix rows.
Related table
 (via RegionID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
274
Chapter 2:  All Tables
Region_Member Table