Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 404
 
2-78
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Enterprise_Agent_Group Table
Related tables:
Call Type (via CallTypeID)
Dialed Number (via DialedNumberID)
Region (via RegionID)
Enterprise_Agent_Group Table
Each row describes an enterprise-wide group of agents composed of agents from different peripherals.
Use ICM Configuration Manager to add, update, and delete Enterprise_Agent_Group records.
ANIWildCard
ANI value or region name. An ANI value can be a prefix 
of any length (the leading digits of the telephone number) 
or a complete telephone number.
varchar(30)
NULL
ANIWildCardType
Indicates what type the ANIWildCard is: 
0 = Unknown
1 = NPA
2 = NPANXX
3 = 10-digit telephone number
4 = Region
5 = Match all
6 = Prefix
smallint
NOT NULL
Description
Additional information about the mapping of these call 
qualifiers to this call type.
varchar(255)
NULL
Table 2-62 Dialer_Number_Map Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-63 Enterprise_Agent_Group Table
Field Name
Description
Data Type
Keys and Null 
Option
EnterpriseAgentGroupID
A unique identifier for the enterprise agent group.
int
PK, NOT NULL
EnterpriseName
An enterprise name for this enterprise agent group. 
This name must be unique among all enterprise agent 
groups within the business entity.
varchar(32)
AK1, NOT 
NULL
Description
Additional information about the enterprise agent 
group.
varchar(255)
NULL
EntityID
If partitioning is enabled, The business entity to which 
the enterprise agent group belongs.
int
FK, NULL
ChangeStamp
Incremented when the record is changed in the central 
database.
int
NOT NULL