Cisco Cisco IPCC Web Option Technical References
2-4
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Agent Table
Agent Table
Contains one record for each agent (a person capable of answering calls). Each agent is associated with
a specific peripheral (ACD) and can be a member of one or more skill groups.
a specific peripheral (ACD) and can be a member of one or more skill groups.
Use ICM Configuration Manager to add, update, and delete Agent records.
Table 2-3
Agent Table Constraints
Constraint
Field Name(s)
PK
SkillTargetID
AK-1
PeripheralID
PersonID
PersonID
AK-2
PeripheralID
PeripheralNumber
PeripheralNumber
FK
AgentDeskSettingID,
PeripheralID
PersonID,
ScheduleID
PeripheralID
PersonID,
ScheduleID
IE-2
AgentDeskSettingID
IE-3
ScheduleID
IE-4
EnterpriseName
Table 2-4
Agent Table
Field Name
Description
Data Type
Keys and
Null
Options
Null
Options
AgentDeskSettingsID
Identifies the agent desk settings associated with
the agent.
the agent.
DBINT
IE-2, FK
NULL
AgentStateTrace
Indicates whether the ICM software collects agent
state trace data for the agent:
state trace data for the agent:
Y = Yes
N = No
N = No
DBCHAR
NOT NULL
ChangeStamp
Incremented when the record is changed in the
central database.
central database.
CHANGESTAMP
NOT NULL
ConfigParam
A string of parameters the ICM software sends to
the peripheral to initialize the agent.
the peripheral to initialize the agent.
varchar(255)
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
DBCHAR
NOT NULL
Description
Additional information about the agent.
DESCRIPTION
NULL