Cisco Cisco IP Contact Center Release 4.6.1 Technical References
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.
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
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.
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
Option
Table 2-63 Enterprise_Agent_Group Table
Field Name
Description
Data Type
Keys and Null
Option
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.
This name must be unique among all enterprise agent
groups within the business entity.
varchar(32)
AK1, NOT
NULL
NULL
Description
Additional information about the enterprise agent
group.
group.
varchar(255)
NULL
EntityID
If partitioning is enabled, The business entity to which
the enterprise agent group belongs.
the enterprise agent group belongs.
int
FK, NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL