Cisco Cisco IPCC Web Option Technical References
Table 154: Indexes for Region_Prefix Table
index_keys
index_description
index_name
RegionID, RegionPrefix
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Region_Prefix
RegionPrefixID
clustered, unique, primary key
located on PRIMARY
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.
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.
(formerly called GMT) delta in minutes.
UTC (formerly called GMT)
AK-1, FK NOT NULL
DBINT
Identifies the associated region.
RegionID
AK-1 NOT NULL
varchar(32)
An initial string to match against calling line IDs.
RegionPrefix
PK NOT NULL
DBINT
A unique identifier for the record.
RegionPrefixID
Region_View Table
This table is part of the
Each row defines a graphical display of regions.
Use Configuration Manager to create, update, and delete Region Prefix rows.
Related table
(via RegionViewID)
Table 155: Indexes for Region_View Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
located on PRIMARY
XAK1Region_View
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
275
Chapter 2: All Tables
Region_View Table