Cisco Cisco Unified Contact Center Enterprise 8.5(1) Referencia técnica

Descargar
Página de 708
Keys and Null Option:
Data Type:
Description:
Field Name:
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 Unified ICM Configuration Manager to create, update, and delete Region Prefix rows.
Related table
 (via RegionID)
Table 157: 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
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
Database Schema Guide for Cisco Unified Contact Center Enterprise 8.5(1)
333
Chapter 2:  All Tables
Region_Prefix Table