Table: dbo.Holiday_Definition_Default
Columns
Name | Type | Constraints | Description
holiday_definition_default_KEY | int (4) | NOT NULL | Primary key of this table
holiday_name | varchar (50) | NOT NULL | Name of the holiday.
holiday_description | varchar (150) | NOT NULL | Description of the holiday.
use_for_date_adjustment | bit (1) | NOT NULL | This holiday is used for date adjustment calculations (via ScheduleCreator).
holiday_month | int (4) | NOT NULL | Month in which the holiday is located Jan = 1, Dec = 12
holiday_day | int (4) | NOT NULL | Specific day the holiday is on.
day_of_week | int (4) | NOT NULL | Day of the week holiday is on Sunday = 0, Saturday = 6
week_of_month | int (4) | NOT NULL | Week of the month holiday located in. 1, 2, 3, 4
day_of_week_on_or_after | bit (1) | NOT NULL | Flag indicationg that the holiday is calculated on or after the weekday occuring after the date specification.
weekday_on_or_after | bit (1) | NOT NULL | Flag indicating that the holiday is calculated on the first weekday on or after the date specification.
last_full_week_of_month | bit (1) | NOT NULL | flag indicating that holiday is calculated using the last full week of the month.
after_holiday | varchar (50) | NOT NULL | The name of the holiday this holiday is calculated as occuring after.
days_after_holiday | int (4) | NOT NULL | The number of days after a specified holiday this holiday occurs.
every_x_years | int (4) | NOT NULL | Holiday occurs every this many years. If the holiday occurs every year, use zero.
start_year | int (4) | NOT NULL | If every_x_years is not zero, this is the starting year for the year skipping calculation. If every_x_years is zero, this will be the first year that the holiday is observed. If this is zero, the holiday will apply to all years.
easter | bit (1) | NOT NULL | Calculate this holiday using the algorithm for Wester Easter.
use_for_banking_holiday | bit (1) | NOT NULL | Holiday is used in banking day calculations.

Primary key
Name | Columns | Description
PK_Holiday_Definition_Default | holiday_definition_default_KEY |