Cisco Cisco IP Contact Center Release 4.6.2 Technical References
C H A P T E R
2-1
Cisco ICM Software Database Schema Handbook
78-11677-04
2
Table Details
This chapter provides detailed information abotu the fields in each table. To locate a specific field, see
the Field Index at the end of this manual.
the Field Index at the end of this manual.
Admin_Script_Schedule_Map Table
Each row describes the schedule associated with an administrative script.
Use the Administrative Manager facility of the Script Editor to add, update, and delete
Admin_Script_Schedule_Map records.
Admin_Script_Schedule_Map records.
Table 2-1
Admin_Script_Schedule_Map Table
Field Name
Description
Data Type
Keys and Null
Option
Option
MasterScriptID
The scheduled administrative script.
int
PK, FK, NOT
NULL
NULL
SequenceNumber
Index for schedules associated with a specific
master script.
master script.
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
1 - 12 = Specifies the month of year
smallint
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
smallint
NOT NULL
DayType
Indicates to which day the schedule applies:
0 - 6 = Specifies a day (Sunday through Monday)
7 = Every day
8 = Every weekday
9 = Every weekend day
7 = Every day
8 = Every weekday
9 = Every weekend day
smallint
NOT NULL