Table: dbo.Holiday_Definition_Default
Columns
NameTypeConstraintsDescription
holiday_definition_default_KEYint (4)NOT NULLPrimary key of this table
holiday_namevarchar (50)NOT NULLName of the holiday.
holiday_descriptionvarchar (150)NOT NULLDescription of the holiday.
use_for_date_adjustmentbit (1)NOT NULLThis holiday is used for date adjustment calculations (via ScheduleCreator).
holiday_monthint (4)NOT NULLMonth in which the holiday is located Jan = 1, Dec = 12
holiday_dayint (4)NOT NULLSpecific day the holiday is on.
day_of_weekint (4)NOT NULLDay of the week holiday is on Sunday = 0, Saturday = 6
week_of_monthint (4)NOT NULLWeek of the month holiday located in. 1, 2, 3, 4
day_of_week_on_or_afterbit (1)NOT NULLFlag indicationg that the holiday is calculated on or after the weekday occuring after the date specification.
weekday_on_or_afterbit (1)NOT NULLFlag indicating that the holiday is calculated on the first weekday on or after the date specification.
last_full_week_of_monthbit (1)NOT NULLflag indicating that holiday is calculated using the last full week of the month.
after_holidayvarchar (50)NOT NULLThe name of the holiday this holiday is calculated as occuring after.
days_after_holidayint (4)NOT NULLThe number of days after a specified holiday this holiday occurs.
every_x_yearsint (4)NOT NULLHoliday occurs every this many years. If the holiday occurs every year, use zero.
start_yearint (4)NOT NULLIf 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.
easterbit (1)NOT NULLCalculate this holiday using the algorithm for Wester Easter.
use_for_banking_holidaybit (1)NOT NULLHoliday is used in banking day calculations.
Primary key
NameColumnsDescription
PK_Holiday_Definition_Defaultholiday_definition_default_KEY

Schema diagram