Cisco Cisco IPCC Web Option Technical References

Page of 404
 
2-120
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Import_Rule_Real_Time Table
Related tables:
Import_Rule (via ImportRuleID)
Import_Rule_Real_Time Table
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 tables:
Import_Rule (via ImportRuleID)
TimeZone
The time zone for the date and time. The value is the offset 
in minutes from GMT.
int
PK, NOT NULL
DateTimeEnd
The date and time when the import was finished.
datetime
NOT NULL
GoodRecords
The number of records successfully imported so far.
int
NOT NULL
BadRecords
The number of records that had errors while importing.
int
NOT NULL
RecoveryKey
A value used internally by the ICM software to track 
virtual time.
float
AK1, NOT 
NULL
TotalRecords
The total number of records contained in the import file.
int
NOT NULL
Table 2-97 Import_Rule_History Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-98 Import_Rule_Real_Time Table
Field Name
Description
Data Type
Keys and Null 
Option
ImportRuleID
The current active import.
int
PK, NOT NULL
DateTime
The date and time when the import was changed.
datetime
NOT NULL
Status
The real-time import status: 380, Import begin; 385, 
Import Update; 420, Import End.
int
NULL
DateTimeStart
The date and time at which this import was started.
datetime
NULL
TotalRecords
A count of all records within an import file.
int
NULL
GoodRecords
The number of records successfully imported so far.
int
NULL
BadRecords
The number of records that had errors while being 
imported.
int
NULL