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.