Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IP Contact Center Release 4.6.1
  5. Technical References

Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Download
Page of 557
Table 152: 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)
Table 153: Indexes for Region_Prefix Table
index_keys
index_description
index_name
RegionID, RegionPrefix
nonclustered, unique, unique key
located on PRIMARY
XAK1Region_Prefix
RegionPrefixID
clustered, unique, primary key
located on PRIMARY
XPKRegion_Prefix
Fields in Region_Prefix Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
ChangeStamp
NOT NULL
DBCHAR
Indicates whether daylight savings time is
observed.
DaylightSavingsEnabled
Values are 'N' and 'Y'.
The default is 'N' - daylight savings time is not
observed.
NULL
DBINT
Indicates coordinated universal time,
abbreviated UTC (formerly called GMT) delta
in minutes.
UTC (formerly called
GMT)
AK-1, FK NOT NULL
DBINT
Identifies the associated region.
RegionID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
232
Chapter 2: -  All Tables
Region_Prefix Table