Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 404
 
2-185
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Schedule_Import Table
Schedule_Import Table
Contains the schedule data imported from a source system. Only specific fields within this table are 
meaningful for any schedule type. The meaning of the imported data is described by the ICR_View and 
View_Column tables.
Table 2-147 ISchedule_Import 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
Long8
An imported value.
int
NULL
Long9
An imported value.
int
NULL
Long10
An imported value.
int
NULL
Long11
An imported value.
int
NULL
Long12
An imported value.
int
NULL
Long13
An imported value.
int
NULL
Long14
An imported value.
int
NULL
Long15
An imported value.
int
NULL
Double1
An imported value.
float
NULL
Double2
An imported value.
float
NULL
Double3
An imported value.
float
NULL
Double4
An imported value.
float
NULL
Double5
An imported value.
float
NULL
Double6
An imported value.
float
NULL
Double7
An imported value.
float
NULL
Double8
An imported value.
float
NULL
Double9
An imported value.
float
NULL
Double10
An imported value.
float
NULL