This table contains a list of days that are exceptions to the pattern of working and non-working days.
|Column Name||Column Description|
|CalendarName||Business calendar name to which the exception applies.|
|ExceptionIndicator||A value of 0 indicates that an ExceptionDate is a non-business day, and a value of 1 indicates that an ExceptionDate is a business day.|
|ExceptionDate||An ExceptionDate must fall within the Teradata calendar (January 1, 1900, to December 31, 2100). If the ExceptionDate is outside that period, it is not accepted.|
|ExceptionReason||The reason for the exception. For example, December 25, 2012 (a Tuesday) is normally a working day, but it is also the Christmas holiday, so the ExceptionReason is “Christmas.” The ExceptionReason may be NULL.|
|CreatorName||The name of the user who created the exception.|
|CreationTime||The timestamp of the exception creation.|
- An OFF exception: A typical working day is a day off (for example, Monday, September 5, 2011, is the Labor Day holiday).
- An ON exception: A typical day off is a working day (for example, everyone at your job is required to work on Saturday, July 30, 2011).
You do not need to validate whether an OFF-exception falls on a business day and an ON-exception falls on a non-business day. Just set the exception, and specify an ExceptionReason. For example, Monday, July 4, is a holiday, but the Barbeque Bonanza store is open and your ExceptionReason is Independence Day Sale.