Cisco Cisco Unified Contact Center Enterprise 10.0(1) Technical References
2-8
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Agent_Distribution Table
Agent_Distribution Table
Each row indicates whether to send real-time and historical agent data from a specific peripheral to a
specific Distributor AW.
specific Distributor AW.
Use ICM Configuration Manager to add, update, and delete Agent_Distribution records.
Related tables:
Peripheral (via PeripheralID)
Agent_Half_Hour Table
Central database only.
Each row provides half-hour statistics for an agent. The ICM software generates Agent_Half_Hour
records for each agent.
records for each agent.
Table 2-4
Agent_Distribution Table
Field Name
Description
Data Type
Keys and Null
Option
Option
AgentDistributionID
A unique identifier for the agent distribution.
int
PK, NOT NULL
PeripheralID
The peripheral from which agent data is sent.
smallint
FK, NOT NULL
DistributorSiteName
The name of the Distributor site to which agent data
is sent.
is sent.
varchar(32)
NOT NULL
Enabled
Indicates whether to send agent data or not: '
Y = Yes, an agent can send data.
N = No, an agent cannot send data.
N = No, an agent cannot send data.
char(1)
NOT NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
int
NOT NULL
Table 2-5
Agent_Half_Hour Table
Field Name
Description
Data Type
Keys and Null
Option
Option
DateTime
Central Controller date and time that the row was
updated.
updated.
smalldatetime
PK, NOT NULL
SkillTargetID
Identifies the agent.
int
PK, FK, NOT
NULL
NULL
TimeZone
The time zone for the date and time. The value is the
offset in minutes from GMT.
offset in minutes from GMT.
int
PK, NOT NULL
MRDomainID
The identifier for the Media Routing Domain for the
peripheral associated with this agent.
peripheral associated with this agent.
int
FK, NOT NULL
RecoveryKey
A value used internally by the ICM software to track
virtual time.
virtual time.
float
AK1, NOT
NULL
NULL