McDewey

Keys and NULL Option Data Type Description Field 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 Business_Hours_Real_Time This table provides the current status of the business hour and the reason code as a real time report. Related Tables • Business_Hours, on page 108 (through BusinessHoursID) • Business_Hours_Reason, on page 111 (through ReasonCode) Table 78: Indexes for Business_Hours_Real_Time Table index_keys index_description index_name BusinessHoursID Primary key XPKBusiness_Hours_Real_Time Table 79: Fields in Business_Hours_Real_Time Table Keys and NULL Option Data Type Description Field PK NOT NULL DBINT Foreign key from Business Hours table. BusinessHoursID NOT NULL DBDATETIME Date and time when this data was last updated. It represents the updated time stamp. DateTime NULL DBINT Indicates whether the business hour is open or closed. • 0 indicates that the business hour is closed. • 1 indicates that the business hour is open. ScheduleStatus Database Schema Handbook for Cisco Unified Contact Center Enterprise, Release 15.0(1) 110 All Tables Business_Hours_Real_Time