Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-189
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Import_Log Table
Import_Log Table
Central database only.
Contains information about schedule import operations that have been performed. The ICM software
automatically creates an Import_Log row each time it imports schedule information.
automatically creates an Import_Log row each time it imports schedule information.
Related tables:
(via ScheduleID)
Table 2-189 Import_Log Table Constraints
Constraint
Field Name(s)
PK
DateTime
ScheduleID
TimeZone
ScheduleID
TimeZone
AK-1
RecoveryKey
FK
ScheduleID
Table 2-190 Import_Log Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
DateTime
The date and time when the row was generated.
DBDATETIME
PK
NOT NULL
LogOperation
The operation that was logged; for example Import
or Edit.
or Edit.
VNAME32
NOT NULL
Message
Indicates ‘Success’ or describes an error.
DESCRIPTION
NOT NULL
RecoveryKey
A unique ID assigned to each record and used
internally by the ICM/IPCC Enterprise software to
track the record.
internally by the ICM/IPCC Enterprise software to
track the record.
DBFLT8
AK-1
NOT NULL
RowsCopied
The number of rows imported or modified.
DBINT
NOT NULL
ScheduleID
Identifies the schedule affected.
DBINT
PK, FK
NOT NULL
TimeZone
The time zone for the date and time. The value is
the offset in minutes from GMT.
the offset in minutes from GMT.
DBINT
PK
NOT NULL
WorkstationName
The workstation from which data was imported.
VNAME32
NOT NULL