Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 620
Recovery Table
This table is in the 
. To see database rules for these tables, click 
Central database only.
Contains internal status information for each table in the database.
Table 150: Indexes for Recovery Table
index_keys
index_description
index_name
RecoveryKey
nonclustered, unique, unique key
located on PRIMARY
XAK1Recovery
DateTime
nonclustered located on PRIMARY
XIE1Recovery
RecoveryKey
clustered, unique, primary key
located on PRIMARY
XPKRecovery
Fields in Recovery Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
IE-1 NOT NULL
DBDATETIME
Date and time of the checkpoint.
DateTime
NULL
DBDATETIME
Ending time.
EndTime
NULL
DBFLT8
Starting recovery key value.
FromRecoveryKey
PK, AK-1 NOT NULL
DBFLT8
A unique ID assigned to each record and used internally by the
ICM/IPCC Enterprise software to track the record.
RecoveryKey
NULL
DBINT
Number of rows copied.
RowsCopied
NULL
DBDATETIME
Starting time.
StartTime
NOT NULL
VNAME32
Name of the table that caused a checkpoint.
TableName
NOT NULL
DBFLT8
Ending recovery key value.
ToRecoveryKey
NOT NULL
VNAME32
Type of record.
Type
Recurring_Schedule_Map Table
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
270
Chapter 2:  All Tables
Recovery Table