McDewey

Keys and NULL Option Data Type Description Name NOT NULL DBSMALLINT The second of the minute at which the schedule expires. The value is 0 if the schedule has no end time. EndSecond NOT NULL DBINT The year in which the schedule expires. The value is 0 if the schedule has no end date. EndYear PK, FK NOT NULL DBINT The scheduled administrative script. MasterScriptID NOT NULL DBSMALLINT Indicates to which month the schedule applies: • 0 = Applies to every month • 1-12 = Specifies the month of year MonthOfYear NOT NULL DBSMALLINT The granularity of the script frequency interval: • 0 = hours • 1 = minutes • 2 = seconds Recurrence NOT NULL DBINT Specifies how many recurrence intervals occur between successive operations. RecurrenceFreq PK NOT NULL DBINT Index for schedules associated with a specific master script. SequenceNumber NOT NULL DBSMALLINT The day of the month on which the schedule goes into effect (1 through 31). StartDay NOT NULL DBSMALLINT The hour of the day at which the schedule goes into effect. StartHour NOT NULL DBSMALLINT The minute of the hour at which the schedule goes into effect. StartMinute NOT NULL DBSMALLINT The month in which the schedule goes into effect (1 through 12). StartMonth NOT NULL DBSMALLINT The second of the minute at which the schedule goes into effect. StartSecond NOT NULL DBINT The year in which the schedule goes into effect StartYear Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 16 All Tables Admin_Script_Schedule_Map