Technical References
Keys and Null
Option:
Data Type:Description:Field Name:
• 2= Not allowed
NOT NULLDBINT
Indicates whether the agent is allowed or required to enter
wrap-up data after an outbound call:
WrapupDataOutgoingMode
• 0= Required
• 1 = Optional
• 2= Not allowed
Agent_Distribution Table
This is one of the Peripheral Detail tables in the Device (page 441) category. For database rules,
click here (page 504).
Each row indicates whether to send real-time and historical agent data from a specific peripheral
to a specific Distributor AW.
Use ICM Configuration Manager to add, update, and delete Agent_Distribution records.
Table 6: Related Table for Agent_Distribution
Peripheral (page 250) (via PeripheralID)
Table 7: Indexes for Admin_Distribution Table
index_keysindex_descriptionindex_name
PeripheralID, DistributorSiteNamenonclustered, unique, unique key
located on PRIMARY
XAK1Agent_Distribution
AgentDistributionIDclustered, unique, primary key
located on PRIMARY
XPKAgent_Distribution
Fields in Agent_Distribution Table :
Keys and Null Option:Data Type:Description:Field Name:
PK NOT NULLDBINT
A unique identifier for the agent distribution.
AgentDistributionID
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
AK-1 NOT NULLVNAME32
The name of the Distributor site to which agent data is sent.
DistributorSiteName
NOT NULLDBCHAR
Indicates whether to send agent data or not:
Enabled
• Y = Yes, an agent can send data.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
22
Chapter 2: All Tables
Agent_Distribution Table