/mcpTable 77: Fields in Business_Hours Table Keys and NULL Option Data Type Description Field PK NOT NULL DBINT Unique ID of the business schedule object BusinessHoursID AK NOT NULL VNAME32 An enterprise name for this business hour. The name must be unique among all the business hours within the business entity. EnterpriseName FK, IE NULL DBINT Displays the foreign key from the Department table. NULL for global department. DepartmentID NULL DESCRIPTION Additional information about this business hour. Description NOT NULL DBTINYINT If this field is 0, the system uses the business hour configured for that department and time zone. You can override the default business hour with the following: • 1=force closes the current business hour. • 2=force opens a business hour. ManualOverride FK NULL DBINT Foreign key from the Business Hours Reason table. BusinessHourReasonID NOT NULL DBTINYINT Defines the type of the business hour. • 0 indicates that the business hour is open for 24 hours on all seven days of the week. • 1 indicates that the business hour will fall within a custom time period you define. To define the time period, select the Custom option under Business Hours > Regular Hours in the Unified CCE Administration console. Default value is 0. BusinessHourType FK, IE NOT NULL DBINT The timezone that the schedule will be based on. Displays the foreign key from the Time Zone Location table. TimeZoneLocationID NULL DBDATETIME Records the date and time when a record is added or updated. DateTimeStamp Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 109 All Tables Business_Hours