Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-3
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Agent Table
Related tables:
Master Script (via MasterScriptID)
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.
Recurrence
The granularity of the script frequency interval: 0 =
hours, 1 = minutes, 2 = seconds.
hours, 1 = minutes, 2 = seconds.
smallint
NOT NULL
RecurrenceFreq
Specifies how many recurrence intervals occur
between successive executions.
between successive executions.
int
NOT NULL
Description
Additional information about the schedule.
varchar(255)
NULL
Table 2-1
Admin_Script_Schedule_Map Table (continued)
Field Name
Description
Data Type
Keys and Null
Option
Option
Table 2-2
Agent Table
Field Name
Description
Data Type
Keys and Null
Options
Options
SkillTargetID
An identifier that is unique among all skill targets in
the enterprise.
the enterprise.
int
PK, FK, NOT
NULL
NULL
PersonID
Foreign key from the Person table.
int
FK
NOT NULL
NOT NULL
AgentDeskSettingsID
Identifies the agent desk settings associated with the
agent.
agent.
int
FK, IE2, NULL
ScheduleID
Identifies an imported schedule associated with the
agent.
agent.
int
FK, IE3, NULL
PeripheralID
Foreign key from the Peripheral table.
smallint
FK, IE5, NOT
NULL
NULL
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.
varchar(32)
IE4, NOT NULL
PeripheralNumber
The agent’s login ID assigned at the switch.
varchar(32)
IE5, 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
Description
Additional information about the agent.
varchar(255)
NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
N = No
char(1)
NOT NULL