15.10 - BusinessCalendarPatterns - 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)

BusinessCalendarPattern.CalendarName

DayName

VARCHAR(9)

UNICODE

X(9)

BusinessCalendarPattern.DayNumber

Pattern

VARCHAR(3)

UNICODE

X(3)

BusinessCalendarPattern.Pattern

PatternComment

VARCHAR(1024)

UNICODE

X(1024)

BusinessCalendarPattern.PatternComment

CreatorName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

BusinessCalendarPattern.CreatorName

LastModified

TIMESTAMP(0)

NOT NULL

YYYY-MM-DDBHH:MI: SS

BusinessCalendarPattern.LastModified

CreatorName

A CreatorName column value of DBC indicates a system-defined business calendar.