Technical References

Table 154: Indexes for Region_Prefix Table
index_keysindex_descriptionindex_name
RegionID, RegionPrexnonclustered, unique, unique key
located on PRIMARY
XAK1Region_Prex
RegionPrexIDclustered, unique, primary key
located on PRIMARY
XPKRegion_Prex
Fields in Region_Prefix Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central
database.
ChangeStamp
NOT NULLDBCHAR
Indicates whether daylight savings time is observed.
DaylightSavingsEnabled
Values are 'N' and 'Y'.
The default is 'N' - daylight savings time is not observed.
NULLDBINT
Indicates coordinated universal time, abbreviated UTC
(formerly called GMT) delta in minutes.
UTC (formerly called GMT)
AK-1, FK NOT NULLDBINT
Identies the associated region.
RegionID
AK-1 NOT NULLvarchar(32)
An initial string to match against calling line IDs.
RegionPrex
PK NOT NULLDBINT
A unique identier for the record.
RegionPrexID
Region_View Table
This table is part of the Script category (page 451). For database rules, click here. (page 509)
Each row denes a graphical display of regions.
Use Conguration Manager to create, update, and delete Region Prex rows.
Related table
Region View Member (page 276) (via RegionViewID)
Table 155: Indexes for Region_View Table
index_keysindex_descriptionindex_name
EnterpriseNamenonclustered, unique, unique key
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