Technical References

Keys and Null Option:Data Type:Description:Field Name:
PK, FK NOT NULLDBINT
The current active import.
ImportRuleID
NULLDBINT
The real-time import status: 380, Import begin; 385, Import Update;
420, Import End.
Status
NULLDBINT
A count of all records within an import file.
TotalRecords
Import_Schedule Table
This table is in the Schedule category (page 450). To see database rules, click here (page 508).
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 (page 305) (via ScheduleID)
Table 116: Indexes for Import_Schedule Table
index_keysindex_descriptionindex_name
ScheduleIDnonclustered located on PRIMARYXIE1Import_Schedule
ImportScheduleIDclustered, unique, primary key
located on PRIMARY
XPKImport_Schedule
Fields in Import_Schedule Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLvarchar(255)
The command the ICM software executes to import the data.
AtCommand
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
NULLDESCRIPTION
Additional information about the schedule import.
Description
PK NOT NULLDBINT
A unique identifier for the Import Schedule record.
ImportScheduleID
FK NOT NULLDBINT
Identifies the Schedule for which the data is imported.
ScheduleID
NOT NULLVNAME32
The host name of the workstation from which the ICM software
imports schedule data.
WorkstationName
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
225
Chapter 2: All Tables
Import_Schedule Table