Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The real-time import status: 380, Import begin; 385,
Import Update; 420, Import End.
Status
NULL
DBINT
A count of all records within an import file.
TotalRecords
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
 (via ScheduleID)
Table 115: Indexes for Import_Schedule Table
index_keys
index_description
index_name
ScheduleID
nonclustered located on PRIMARY
XIE1Import_Schedule
ImportScheduleID
clustered, unique, primary key
located on PRIMARY
XPKImport_Schedule
Fields in Import_Schedule Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
varchar(255)
The command the ICM software executes to import
the data.
AtCommand
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the
central database.
ChangeStamp
NULL
DESCRIPTION
Additional information about the schedule import.
Description
PK NOT NULL
DBINT
A unique identifier for the Import Schedule record.
ImportScheduleID
FK NOT NULL
DBINT
Identifies the Schedule for which the data is
imported.
ScheduleID
NOT NULL
VNAME32
The host name of the workstation from which the
ICM software imports schedule data.
WorkstationName
Label Table
Defines the label that is sent to the routing client for each Network Target value. Use the ICM
Con
figuration Manager to add, update, and delete Label records.
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
186
Chapter 2: -  All Tables
Import_Schedule Table