Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 557
Keys and Null Option:
Data Type:
Description:
Field Name:
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
PK NOT NULL
DBINT
The time zone for the date and time. The value is the
offset in minutes from UTC (formerly called GMT).
TimeZone
NOT NULL
DBINT
The total number of records contained in the import file.
TotalRecords
Import_Rule_Real_Time Table
This table is in the 
. To see database rules for these tables,
click 
Local database only.
Contains the name and current status of the import list that is currently being generated by the
Blended Agent Import Rule process.
Related table
Table 114: Indexes for Import_Rule_Real_Time Table
index_keys
index_description
index_name
ImportRuleID
clustered, unique, primary key
located on PRIMARY
XPKImport_Rule_Real_Time
Fields in Import_Rule_Real_Time Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NULL
DBINT
The number of records that had errors while being
imported.
BadRecords
NOT NULL
DBDATETIME
The date and time when the import was changed.
DateTime
NULL
DBDATETIME
The date and time at which this import was started.
DateTimeStart
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
NULL
DBINT
The number of records successfully imported so far.
GoodRecords
PK, FK NOT NULL
DBINT
The current active import.
ImportRuleID
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions Release 7.2(1)
185
Chapter 2:  All Tables
Import_Rule_Real_Time Table