This view provides information about exceptions defined for a calendar, such as a holiday on Monday, which is normally a working day. You can query the view to check the exceptions.
| View Column Name | Description | Data Type | Format |
|---|---|---|---|
| CalendarName | The name of the calendar. | VARCHAR(128) | X(128) |
| ExceptionIndicator | Returns ON for a working day and OFF for a nonworking day. | VARCHAR(3) | X(3) |
| ExceptionDate | The exception date set for the calendar. | DATE | YY/MM/DD |
| ExceptionReason | The reason for the exception. | VARCHAR(1024) | X(1024) |
| CreatorName | The user who created the exception. | VARCHAR(128) | X(128) |
| CreationTime | The timestamp of exception creation. | TIMESTAMP(0) | YYYY-MM-DDBHH:MI:SS |