Cisco Cisco IP Contact Center Release 4.6.2 Technical References
2-252
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Region_Prefix Table
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:
(via RegionID)
Table 2-273 Region_Prefix Table Constraints
Constraint
Field Name(s)
PK
RegionPrefixID
AK-1
RegionID
RegionPrefix
RegionPrefix
FK
RegionID
Table 2-274 Region_Prefix Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
DaylightSavingsEnd
The end of daylight savings time.
DBDATETIME
NULL
DaylightSavingsStart
The start of daylight savings time.
DBDATETIME
NULL
GMT
Indicates Greenwich Mean Time (GMT) delta in
minutes.
minutes.
DBINT
NOT NULL
RegionID
Identifies the associated region.
DBINT
AK-1, FK
NOT NULL
RegionPrefix
An initial string to match against calling line IDs. varchar(32)
AK-1
NOT NULL
RegionPrefixID
A unique identifier for the record.
DBINT
PK
NOT NULL