Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IPCC Web Option
  5. Technical References

Cisco Cisco IPCC Web Option Technical References

Download
Page of 404
 
2-152
Cisco ICM Software Database Schema Handbook
78-11677-04
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-131 Recurring_Schedule_Map Table
Field Name
Description
Data Type
Keys and Null 
Option
ScheduleID
Identifies the schedule that recurs.
int
PK, FK, NOT 
NULL
SequenceNumber
Index for schedules associated with a specific service.
int
PK, NOT NULL
Type
The type of schedule. 
smallint
NOT NULL
MonthOfYear
Indicates to which month the schedule applies:
0 = Applies to every month.
1- 12 = Specifies the month of year.
smallint
NOT NULL
DayOfMonth
Indicates to which day of month the schedule applies. 
0 = Applies to every day.
1- 31 = Specifies the day of month.
smallint
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
smallint
NOT NULL
DayPosition
In conjunction with DayType, indicates the 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
smallint
NOT NULL
DayFlags
A bit mask specifying the days on which the schedule is 
active: 
0x01 = Sunday
0x02 = Monday
0x04 = Tuesday
0x08 = Wednesday
0x10 = Thursday
0x20 = Friday
0x40 = Saturday
int
NOT NULL
StartMonth
The month in which the schedule goes into effect (1 
through 12).
smallint
NOT NULL
StartDay
The day of the month on which the schedule goes into 
effect (1 through 31).
smallint
NOT NULL