15.10 - BusinessCalendarExceptions - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

Sys_Calendar

 

View Column

Data Type

Format

Source Table.Column

CalendarName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

BusinessCalendarException.CalendarName

ExceptionIndicator

VARCHAR(3)

UNICODE

X(3)

BusinessCalendarException.ExceptionIndicator

ExceptionDate

DATE

NOT NULL

YY/MM/DD

BusinessCalendarException.ExceptionDate

ExceptionReason

VARCHAR(1024)

UNICODE

X(1024)

BusinessCalendarException.ExceptionReason

CreatorName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

BusinessCalendarException.CreatorName

CreationTime

TIMESTAMP(0)

NOT NULL

YYYY-MM-DDBHH:MI: SS

BusinessCalendarException.CreationTime

ExceptionData

The date specified in the ExceptionData column must be within the calendar period (that is, the value specified in the BusinessCalendar view YearEnd column).

ExceptionReason

The value of the ExceptionReason column can be NULL.