17.10 - DBC.BusinessCalendarException Table - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.
There are two types of exceptions:
  • 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.