Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IP Contact Center Release 4.6.1
  5. Technical References

Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Download
Page of 557
Keys and Null Option:
Data Type:
Description:
Field Name:
AK-1 NOT NULL
DBINT
Reason code used by agents (configurable).
ReasonCode
PK NOT NULL
DBINT
A unique identifier created by the schema.
ReasonCodeID
NOT NULL
varchar(40)
Text associated with the reason code numeric value.
ReasonText
Recovery Table
Central database only.
Contains internal status information for each table in the database.
Table 149: 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 Release 7.2(1)
228
Chapter 2: -  All Tables
Recovery Table