Cisco Cisco IP Contact Center Release 4.6.2 Technical References

Page of 404
 
2-186
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Schedule_Import_Real_Time Table
Related tables:
Schedule (viaScheduleID)
Schedule_Import_Real_Time Table
Local database only.
The scheduling data for the current time period as imported from an external source.
String1
An imported value.
varchar(255)
NULL
String2
An imported value.
varchar(255)
NULL
String3
An imported value.
varchar(255)
NULL
String4
An imported value.
varchar(255)
NULL
String5
An imported value.
varchar(255)
NULL
DateTime1
An imported value.
datetime
NULL
DateTime2
An imported value.
datetime
NULL
DateTime3
An imported value.
datetime
NULL
Bool1
An imported value.
char(1)
NULL
Bool2
An imported value.
char(1)
NULL
RecoveryKey
A value used internally by the ICM software to track virtual 
time.
float
AK1, NOT 
NULL
Table 2-147 ISchedule_Import Table (continued)
Field Name
Description
Data Type
Keys and Null 
Option
Table 2-148 Schedule_Import_Real_Time Table
Field Name
Description
Data Type
Keys and Null 
Option
DateTime
The date and time at which the schedule data in the 
record becomes effective.
datetime
PK, NOT NULL
ScheduleID
Foreign key to the Schedule for which the data are 
imported.
int
PK, FK, NOT 
NULL
TimeZone
The time zone for the date and time. The value is the 
offset in minutes from GMT.
int
PK, NOT NULL
Long1
An imported value.
int
NULL
Long2
An imported value.
int
NULL
Long3
An imported value.
int
NULL
Long4
An imported value.
int
NULL
Long5
An imported value.
int
NULL
Long6
An imported value.
int
NULL
Long7
An imported value.
int
NULL