Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-121
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
Import_Schedule Table
Import_Schedule Table
Defines a command that the ICM software executes periodically to import data into a schedule.
Use the Workforce Management Integration System to schedule import operations.
Related tables:
Schedule (via ScheduleID)
Label Table
Defines the label that is sent to the routing client for each Network Target value.
Use the ICM Configuration Manager to add, update, and delete Label records.
Table 2-99 Import_Schedule Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ImportScheduleID
A unique identifier for the Import Schedule record.
int
PK, NOT NULL
ScheduleID
Identifies the Schedule for which the data is imported. int
FK, NOT NULL
AtCommand
The command the ICM software executes to import
the data.
the data.
varchar(255)
NOT NULL
WorkstationName
The host name of the workstation from which the
ICM software imports schedule data.
ICM software imports schedule data.
varchar(32)
NOT NULL
Description
Additional information about the schedule import.
varchar(255)
NULL
ChangeStamp
Incremented when the record is changed in the central
database.
database.
int
NOT NULL
Table 2-100 Label Table
Field Name
Description
Data Type
Keys and Null
Option
Option
LabelID
Unique identifier for this label.
int
PK, NOT NULL
ICRInstanceID
For network VRU labels with multiple NAMs, this field
contains a foreign key to identify the Network
Applications Manager (NAM) instance for which the
label is valid.
contains a foreign key to identify the Network
Applications Manager (NAM) instance for which the
label is valid.
int
FK, NULL
CustomerDefinitionID
Identifies the customer associated with the label.
int
IE1, FK, NULL
NetworkTargetID
Foreign key from the Network Target table. Each label
maps to one and only one network target.
maps to one and only one network target.
int
FK, NULL