Holidays associated with a module’s work calendar; the capacity calculation discounts them as non-working days
Data model
Fields
| Field | Type | Description |
|---|---|---|
| calendar_id* | UNIQUEIDENTIFIER | Working calendar to which the holiday belongs |
| holiday_date* | DATE | Date of the holiday |
| holiday_id* | UNIQUEIDENTIFIER | Unique identifier of the holiday |
| holiday_name* | VARCHAR (150) | Name of the holiday |
| is_active* | BIT | Logical Deletion: 1 = Active Record, 0 = Retired |
| is_recurring* | BIT | Indicates whether the holiday is repeated every year |
Primary Key
| PK_APMO_HOLIDAY |
|---|
| holiday_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| calendar_id* | dbo.APMO_CALENDAR | calendar_id | FK01_APMO_HOLIDAY |