RFL200041: How to populate the RayFlow Holidays table so that they can be excluded from the SLA calculation?

RayFlow 1.7 to 1.10.x

The attached 14_country_holidays.sql file will allow you to populate the RayFlow database's Holidays table with 2015 holiday entries for Australia (AU), Austria (AT), Belgium (BE), Canada (CA), France (FR), Germany (DE), India (IN),
Ireland (IR), Luxemburg (LX), Netherlands (NL), Poland (PL), Switzerland (CH), United Kingdom (UK), & United States of America (USA),
based off of information provided by http://www.officeholidays.com/countries/<country name>/ 

If a calender entry was initially created for a country that has two or more different holiday names for that date, the names have been separated by the "/" character. 

Example = 'Vasant Panchami / Sir Chhotu Ram Jayanti'  

That countries regions that relate to each holiday name are found between the "()" characters and are also separated by the "/" character. 

Example = --IN (Haryana, Odisha,Tripura, West Bengal only / Haryana only)  

If two or more countries share the same holiday name on a date that other countries have a different holiday name, then those countries are grouped between the "[]" characters. 

Example = 'Day after New Years Day' --[CA (Quebec only), UK (Scotland)], CH (Berchtolds Day)   

If a country has a different holiday name for a date, that name will be found between the "()" characters. 

Example = CH (Berchtolds Day)

If that country's holiday does not pertain to the entire country, then the associated regions are found between "()" characters within the country's "()" characters. 

Example = CH (Berchtolds Day (Aargau, Bern, Fribourg, Glarus, Jura, Lucerne, Neuchâtel, Obwalden, Schaffhausen, Solothurn, Thurgau, Vaud, Zug, Zurich))


NOTE 1:  The SLA calculation only takes holidays into effect once a package task has entered that holidays date, and does not perform post SLA calculation if a holiday which has already passed is entered into the Holidays table.   

NOTE 2:  The Holidays table currently does not offer the possibility to differentiate between holidays based on region and location of the task within the workflow.


Feel free to select the holidays that apply to your RayFlow system, and modify the queries if the initial holiday name is not the one that you require.