Current holidays.csv has no calendar code - so all queries will use the same holidays.
To make it more generic, the holiday data needs to have an associated calendar code.
Refer to the CalendarData.xlsx
There are calendar codes for AU, and AU-TAS, AU-VIC, etc.
Also, holiday types for School vs Public Holiday. Maybe actually need to have a high school vs primary school?
So a Victorian school will use AU + AU-VIC and Public Holiday + School.
Whereas a business in QLD will use AU + AU-QLD with PublicHoliday type.
Current holidays.csv has no calendar code - so all queries will use the same holidays. To make it more generic, the holiday data needs to have an associated calendar code. Refer to the CalendarData.xlsx There are calendar codes for AU, and AU-TAS, AU-VIC, etc. Also, holiday types for School vs Public Holiday. Maybe actually need to have a high school vs primary school? So a Victorian school will use AU + AU-VIC and Public Holiday + School. Whereas a business in QLD will use AU + AU-QLD with PublicHoliday type.