holiday_definition_KEY | int (4) | NOT NULL | Primary key of this table |
client_KEY | int (4) | NOT NULL | Key to client associated with this holiday definition |
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. |