Cisco Cisco IPCC Web Option Technical References
2-248
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Recurring_Schedule_Map Table
Recurring_Schedule_Map Table
Each row describes a periodic schedule used, for example, by a scheduled target.
Use the Workforce Management Integration System to create, update, and delete recurring schedules.
Table 2-266 Recurring_Schedule_Map Table Constraints
Constraint
Field Name(s)
PK
ScheduleID
SequenceNumber
SequenceNumber
FK
ScheduleID
Table 2-267 Recurring_Schedule_Map Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
Bool1
Reserved for future use.
DBCHAR
NULL
Bool2
Reserved for future use.
DBCHAR
NULL
DayFlags
A bit mask specifying the days on which the
schedule is active:
schedule is active:
0x01 = Sunday
0x02 = Monday
0x04 = Tuesday
0x08 = Wednesday
0x10 = Thursday
0x20 = Friday
0x40 = Saturday
0x02 = Monday
0x04 = Tuesday
0x08 = Wednesday
0x10 = Thursday
0x20 = Friday
0x40 = Saturday
DBINT
NOT NULL
DayOfMonth
Indicates to which day of month the schedule
applies.
applies.
0 = Applies to every day.
1- 31 = Specifies the day of month.
1- 31 = Specifies the day of month.
DBSMALLINT
NOT NULL
DayPosition
In conjunction with DayType, indicates the
position of a day within a month:
position of a day within a month:
0 = first day of the type
1 = second day of the type
2 = third day of the type
3 = fourth day of the type
4 = last day of the type
5 = every day of the type
1 = second day of the type
2 = third day of the type
3 = fourth day of the type
4 = last day of the type
5 = every day of the type
DBSMALLINT
NOT NULL
DayType
Indicates to which day the schedule applies:
0- 6 = A specific a day of the week (0 is Sunday, 1
is Monday, etc.)
7 = every day
8 = every weekday
9 = every weekend day
is Monday, etc.)
7 = every day
8 = every weekday
9 = every weekend day
DBSMALLINT
NOT NULL