McDewey

Storage Description Field Name lvarchar (70) NULL The description of the calendar that is configured in the Unified CCX Administration Calendar Management. description nvarchar (50) NOT NULL The time zone of the calendar. timezone smallint NOT NULL Indicates the type of calendar. • 1—Full time • 2—Flexible caltype boolean NOT NULL Indicates the availability of the special days. hasspecialdays boolean NOT NULL Indicates the availability of the holidays. hasholidays boolean NOT NULL Indicates whether the record is currently active or not. f = Inactive t = Active active DATETIME year to second NULL Date and time of the record when it is marked as inactive. dateinactive CCHolidays Database table name: CCHolidays This table stores the configured business holidays of a calendar. Table 17: CCHolidays Table Fields Storage Description Field Name serial NOT NULL Primary Key A unique identifier for the record. recordid int NOT NULL A unique identifier for the calendar. calid Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 24 Database Schema CCHolidays