DBC.BusinessCalendarPattern Table - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

This table records calendar information about patterns of business and non-business days.

Column Name Column Description
CalendarName Business calendar name.
PatternType Identifies the pattern as weekly, monthly, quarterly, or yearly. Only the weekly pattern is supported. Pattern “W” indicates a weekly pattern.
DayNumber The days in the week are numbered from 1 to 7, starting with Sunday as 1 and ending with Saturday as 7. There is one row in the table for each day, and the ON/OFF status for the day is stored in the Pattern column.
Pattern A weekly pattern describes 7 rows, each set to 1 (business day) or 0 (nonbusiness day).
PatternComment A description of the pattern.
CreatorName The name of the user who created or modified the pattern. For system-defined business calendars, this is DBC.
LastModified The timestamp of the last pattern change.