Cisco Cisco E-Mail Manager Unity Integration Option Technical References
2-5
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Agent Table
Related tables:
(via AgentDeskSettingsID)
(via SkillTargetID)
(via SkillTargetID)
(via SkillTargetID)
(via SkillTargetID)
(via PeripheralID)
(via PersonID)
(via ScheduleID)
(via SkillTargetID)
(via SkillTargetID)
EnterpriseName
An enterprise name for the agent that is unique
within the enterprise. You might form the name by
combining the agent’s first and last name with the
name of the peripheral.
within the enterprise. You might form the name by
combining the agent’s first and last name with the
name of the peripheral.
VANME32
IE-4
NOT NULL
PeripheralID
Foreign key from the Peripheral table.
DBSMALLINT
AK-1,
AK-2, FK
AK-2, FK
NOT NULL
PeripheralName
The name of the agent as known to the peripheral. VANME32
NULL
PeripheralNumber
The agent’s login ID assigned at the switch.
varchar(32)
AK-2
NOT NULL
PersonID
Foreign key from the Person table.
DBINT
AK-1, FK
NOT NULL
ScheduleID
Identifies an imported schedule associated with
the agent.
the agent.
DBINT
FK, IE-3
NULL
SkillTargetID
An identifier that is unique among all skill targets
in the enterprise.
in the enterprise.
DBINT
PK, FK
NOT NULL
SupervisorAgent
Indicates whether an agent is a supervisor.
Y = Yes, agent is a supervisor
N = No, agent is not a supervisor
N = No, agent is not a supervisor
DBCHAR
NULL
TemporaryAgent
Indicates whether the agent is a temporary agent
created by the CallRouter:
created by the CallRouter:
Y = Yes, created by the CallRouter
N = No, not created by the CallRouter
N = No, not created by the CallRouter
DBCHAR
NOT NULL
Table 2-4
Agent Table (continued)
Field Name
Description
Data Type
Keys and
Null
Options
Null
Options