EN
Español
English
Português
    APMO_HOLIDAY

    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