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. Currently, 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 or 0. For each DayNumber, this column stores the status, whether it is a business day (1) or a non-business day (0). |
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. |