Category: Operations
Database: Sys_Calendar
View Column | Data Type | Format | Comment |
---|---|---|---|
CalendarName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The BusinessCalendarPatterns.CalendarName returns the name of the business calendar. |
DayName | VARCHAR(9) UNICODE NOT CASESPECIFIC | X(9) | The BusinessCalendarPatterns.DayName returns day name like SUNDAY, MONDAY, etc. |
Pattern | VARCHAR(3) UNICODE NOT CASESPECIFIC | X(3) | The BusinessCalendarPatterns.Pattern returns ON(working day) or OFF(Non working day) for each day. |
PatternComment | VARCHAR(1024) UNICODE NOT CASESPECIFIC | X(1024) | The BusinessCalendarPatterns.PatternComment returns the comment for each day in the pattern. |
CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The BusinessCalendarPatterns.CreatorName returns the user name who created/modified the pattern. |
LastModified | TIMESTAMP(0) NOT NULL | YYYY-MM-DDBHH:MI:SS | The BusinessCalendarPatterns.LastModified returns the timestamp when the pattern is last modified. |