Category: Operations
Database: Sys_Calendar
View Column | Data Type | Format | Comment |
---|---|---|---|
CalendarName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The BusinessCalendarExceptions.CalendarName returns the name of the business calendar. |
ExceptionIndicator | VARCHAR(3) UNICODE NOT CASESPECIFIC | X(3) | The BusinessCalendarExceptions.ExceptionIndicator returns ON(working day) or OFF(Non working day) for each exception date. |
ExceptionDate | DATE NOT NULL | YY/MM/DD | The BusinessCalendarExceptions.ExceptionDate returns the exception date for which exception is created. |
ExceptionReason | VARCHAR(1024) UNICODE NOT CASESPECIFIC | X(1024) | The BusinessCalendarExceptions.ExceptionReason returns the reason for the exception date. |
CreatorName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The BusinessCalendarExceptions.CreatorName returns the user name who created the exception. |
CreationTime | TIMESTAMP(0) NOT NULL | YYYY-MM-DDBHH:MI:SS | The BusinessCalendarExceptions.CreationTime returns the timestamp when the exception is created. |