Cisco Cisco Unified Contact Center Enterprise 9.0(1) Referências técnicas

Página de 718
Keys and
NULL
Option
Data Type
Description
Name
PK, FK
NOT
NULL
DBINT
Foreign key from the Dialed Number table.
DialedNumberID and Item together form an
alternate key that is used by the system software to
determine the order in which to match the wildcards.
DialedNumberID
PK NOT
NULL
DBINT
The order in which the rows for a dialed number are
tested against the call qualifiers.
Item
FK NULL
DBINT
If ANIWildCardType is 4 (Region), this is the
foreign key of the region from the Region table.
RegionID
Dial_Number_Plan
This is in the
category. For database rules, see
Defines special dialing codes that allow enterprise agents to use the system software to place calls to services,
other agents, skill groups, enterprise skill groups, supervisors, the local public network, a long-distance
network, or to specific trunks. Use Unified ICM Configuration Manager to add, update, and delete
Dial_Number_Plan records.
Related tables
(via DialedNumberID)
(via RoutingClientID)
Table 139: Indexes for Dial_Number_Plan Table
index_keys
index_description
index_name
RoutingClientID, WildcardPattern
nonclustered, unique, unique key
located on PRIMARY
XAK1Dial_Number_Plan
DialNumberPlanID
clustered, unique, primary key located
on PRIMARY
XPKDial_Number_Plan
Table 140: Fields in Dial_Number_Plan table
Keys and
NULL
Option
Data Type
Description
Name
NOT
NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
ChangeStamp
Database Schema Guide for Cisco Unified Contact Center Enterprise Release 9.0    
249
All tables
Dial_Number_Plan