McDewey

Table 487: Fields in Week_Day_Schedule Table Keys and NULL Option Data Type Description Field PK NOT NULL DBINT The ID of the each week day schedule. WeekDayScheduleID FK, IE NOT NULL DBINT Unique ID of the business schedule object BusinessHoursID IE NOT NULL DBSMALLINT Values range from 0 to 6, assigned to each day in a week starting from Sunday. DayType NOT NULL DBSMALLINT Specifies the hour the business hour starts in a weekday. StartHour NOT NULL DBSMALLINT Specifies the minute the business hours starts in a weekday. StartMinute NOT NULL DBSMALLINT Specifies the second the business hours starts in a weekday. Default value is 0. StartSecond NOT NULL DBSMALLINT Specifies the hour the business hour ends in a weekday. EndHour NOT NULL DBSMALLINT Specifies the minute the business hours ends in a weekday. EndMinute NOT NULL DBSMALLINT Specifies the second the business hours ends in a weekday. Default value is 0. EndSecond NULL DBDATETIME Records the date and time when the record was added or updated DateTimeStamp NOT NULL CHANGESTAMP Incremented when the record is changed in the central database. ChangeStamp NULL DBINT Future Use FutureUseInt1 NULL DBINT Future Use FutureUseInt2 NULL VARCHAR(64) Future Use FutureUseVarChar1 NULL VARCHAR(64) Future Use FutureUseVarChar2 Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 613 All Tables Week_Day_Schedule