Cisco Cisco Unified Contact Center Enterprise 9.0(2) Technical References
2-194
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Import_Rule_History Table
Import_Rule_History Table
Central database only.
Contains the history of every Outbound Option import and shows how many records succeeded and
failed.
failed.
Related tables:
(via ImportRuleID)
Table 2-195 Import_Rule_History Table Constraints
Constraint
Field Name(s)
PK
ImportRuleID
StartDateTime
TimeZone
StartDateTime
TimeZone
AK-1
RecoveryKey
FK
ImportRuleID
Table 2-196 Import_Rule_History Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
BadRecords
The number of records that had errors while
importing.
importing.
DBINT
NOT NULL
EndDateTime
The date and time when the import was finished.
DBDATETIME
NOT NULL
GoodRecords
The number of records successfully imported so
far.
far.
DBINT
NOT NULL
ImportRuleID
The current active import.
DBINT
PK, FK
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
StartDateTime
The date and time when the import was started.
DBDATETIME
PK
NOT NULL
TimeZone
The time zone for the server where the import
process resides. The value is the offset in minutes
from GMT.
process resides. The value is the offset in minutes
from GMT.
DBINT
PK
NOT NULL
TotalRecords
The total number of records contained in the
import file.
import file.
DBINT
NOT NULL