Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBCHAR
Valid options include:
NullEnabled
• Y = Column allows a NULL entry.
• N = Column does not allow NULL values.
PK NOT NULL
DBINT
The index for clauses within a given import rule.
SequenceNumber
NULL
DBINT
The name of a Blended Agent standard column to
which this 
field will default.
StandardColumnType
NOT NULL
DBINT
The data type of the column.
Type
Import_Rule_History Table
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 113: 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
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
184
Chapter 2: -  All Tables
Import_Rule_History Table