Cisco Cisco IPCC Web Option Technical References

Page of 620
Import_Rule_History Table
This table is in the 
. To see database rules for these tables,
click 
Central database only.
Contains the history of every Blended Agent import and shows how many records succeeded
and failed.
Related table
Table 114: Indexes for Import_Rule_History Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
XAK1Import_Rule_History
StartDateTime, ImportRuleID, TimeZone
clustered, unique, primary key
located on PRIMARY
XPKImport_Rule_History
Fields in Import_Rule_History Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
The number of records that had errors while importing.
BadRecords
NOT NULL
DBDATETIME
The date and time when the import was finished.
EndDateTime
NOT NULL
DBINT
The number of records successfully imported so far.
GoodRecords
NULL
DBINT
Reserved for future use
FutureUseInt1
NULL
DBINT
Reserved for future use
FutureUseInt2
NULL
DBINT
Reserved for future use
FutureUseInt3
NULL
DBINT
Reserved for future use
FutureUseInt4
NULL
DBINT
Reserved for future use
FutureUseInt5
PK, FK NOT NULL
DBINT
The current active import.
ImportRuleID
AK-1 NOT NULL
DBFLT8
A value used internally by the ICM software to track virtual time.
RecoveryKey
PK NOT NULL
DBDATETIME
The date and time when the import was started.
StartDateTime
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
223
Chapter 2:  All Tables
Import_Rule_History Table