table for logging exceptions generated in the AFLS calendar functionality.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| caex_date* | DATETIME | Exception log date generated in calendar functionality. |
| caex_id* | INT | Primary Table Key |
| caex_is_restriction* | BIT | Sets a restriction on the exception in case reassignment is required. |
| cale_id | INT | The identifier of the calendar configured for corresponding exception association. |
Primary Key
| PK_AFLS_CALENDAR_EXCEPTION |
|---|
| caex_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| cale_id | dbo.AFLS_CALENDAR | cale_id | FK01_AFLS_CALENDAR_EXCEPTION |