Cisco Cisco E-Mail Manager Unity Integration Option Technical References
2-2
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
Chapter 2 Table Details
Admin_Script_Schedule_Map Table
DayPosition
In conjunction with DayType, the position of a day
within a month:
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
DBDBSMALLINT
NOT NULL
DayType
Indicates to which day the schedule applies:
0 - 6 = Specifies a day (Sunday through Monday,
respectively)
7 = Every day
8 = Every weekday
9 = Every weekend day
respectively)
7 = Every day
8 = Every weekday
9 = Every weekend day
DBDBSMALLINT
NOT NULL
Description
Additional information about the schedule.
DESCRIPTION
NULL
EndDay
The day of the month on which the schedule
expires. The value is 0 if the schedule has no end
date.
expires. The value is 0 if the schedule has no end
date.
DBDBSMALLINT
NOT NULL
EndHour
The hour of the day at which the schedule expires.
The value is 0 if the schedule has no end time.
The value is 0 if the schedule has no end time.
DBDBSMALLINT
NOT NULL
EndMinute
The minute of the hour at which the schedule
expires. The value is 0 if the schedule has no end
time.
expires. The value is 0 if the schedule has no end
time.
DBDBSMALLINT
NOT NULL
EndMonth
The month in which the schedule expires. The
value is 0 if the schedule has no end date.
value is 0 if the schedule has no end date.
DBDBSMALLINT
NOT NULL
EndSecond
The second of the minute at which the schedule
expires. The value is 0 if the schedule has no end
time.
expires. The value is 0 if the schedule has no end
time.
DBDBSMALLINT
NOT NULL
EndYear
The year in which the schedule expires. The value
is 0 if the schedule has no end date.
is 0 if the schedule has no end date.
DBINT
NOT NULL
MasterScriptID
The scheduled administrative script.
DBINT
PK, FK
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
DBDBSMALLINT
NOT NULL
Recurrence
The granularity of the script frequency interval:
0 = hours
1 = minutes
2 = seconds
1 = minutes
2 = seconds
DBSMALLINT
NOT NULL
RecurrenceFreq
Specifies how many recurrence intervals occur
between successive executions.
between successive executions.
DBINT
NOT NULL
Table 2-2
Admin_Script_Schedule_Map Table (continued)
Field Name
Description
ICM Data Type
Keys and
Null Option
Null Option