Cisco Cisco IPCC Web Option Technical References

Page of 620
Related tables
 (via RegionID)
 (via RegionID)
 (via RegionID)
 (via RegionID)
Table 152: Indexes for Region Table
index_keys
index_description
index_name
EnterpriseName
nonclustered, unique, unique key
located on PRIMARY
XAK1Region
RegionID
clustered, unique, primary key
located on PRIMARY
XPKRegion
Fields in Region Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the region.
Description
AK-1 NOT NULL
VNAME32
An enterprise name for the region. This name must be unique for all
regions in the enterprise.
EnterpriseName
PK NOT NULL
DBINT
A unique identifier for the region.
RegionID
NOT NULL
DBINT
The type of the region.
RegionType
Region_Info Table
This table is in the 
To see database rules for these tables, click 
Specifies which prefixes and regions are predefined by the ICM software.
Use Configuration Manager to create, update, and delete Region rows.
Fields in Region_Info Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
DESCRIPTION
Any additional information about the pre-defined regions.
Comment
NOT NULL
VNAME32
Identifies the types of prefixes and regions pre-defined by the ICM
software.
Location
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
273
Chapter 2:  All Tables
Region_Info Table