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