McDewey

Table 40: DateShiftMap 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 nvarchar (50) NOT NULL Name of the calendar. name DATETIME YEAR TO DAY NOT NULL Date of the special day. caldate nvarchar (25) NOT NULL The shift name configured for the specific day of the week. shiftname smallint NOT NULL Type of the shift. shifttype int NOT NULL Shift start time. fromtime int NOT NULL Shift end time. totime 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 DayShiftMap Database Table Name: DayShiftMap This table stores the custom weekly business days configured for calendars. Cisco Unified Contact Center Express Database Schema Guide, Release 12.5(1) SU1 59 Database Schema DayShiftMap