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 548
   
2-286
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2      Table Details
Schedule Table
Schedule Table
Each row describes a schedule to be imported from an external system. Imported data are stored in the 
Schedule_Import and Schedule_Import_Real_Time tables.
Use the Workforce Management System Import tool to create, delete, or modify Schedule rows.
Table 2-297 Schedule Table Constraints
Constraint
Field Name(s)
PK
ScheduleID
AK-1
EnterpriseName
EntityID
FK
EntityID
ICRViewID
ScheduleReportID
ScheduleSourceID
IE-1
ScheduleReportID
IE-2
ScheduleSourceID
IE-3
EntityID
Table 2-298 Schedule Table
Field Name
Description
Data Type
Keys and 
Null Option
ChangeStamp
Incremented when the record is changed in the 
central database.
CHANGESTAMP
NOT NULL
Deleted
Deleted Flag. Stored as a character:
Y = Yes
N = No
DBCHAR
NOT NULL
Description
Additional information about the schedule.
VNAME32
NULL
EnterpriseName
A unique name for the schedule.
GLOBALID
AK-1
NOT NULL
EntityID
If partitioning is enabled, indicates the business 
entity to which the schedule belongs.
DBINT
AK-1, FK
NOT NULL
ICRViewID
Foreign key to a description of how the ICM 
software interprets the Schedule_Import data for 
the schedule.
DBINT
FK, IE-3
NULL
ScheduleID
A unique identifier for the schedule.
DBINT
PK
NOT NULL
SchedulePeriod
The number of minutes in each scheduling 
interval. A schedule can contain different data for 
each interval.
DBINT
NOT NULL