Utility: Create tool to generate a report of holiday balance for any given date

[cwchriswilliams]

Generate utility which can receive data about staff holidays and return a report indicating staff balance on a given date.

Input:

• data of staff start-date, holiday-region and holiday-entitlement
• data of public holidays for staff regions
• data of personal holidays taken by staff members

Output:

• Report indicating holiday balance on given date

Holiday Entitlement:

• holiday-entitlement is pro-rata for periods worked (e.g. if start date in June, by Dec 31st, entitlement will be full-entitlement/2)
• holiday-entitlement is pro-rata for proportion of full-time hours worked (e.g. if working 20/40 hrs per week, holiday entitlement is full-entitlement/2)
• When less than 5 days per week are worked, holiday-entitlement is increased by public holidays in year / 5 * working days

Balance Accrual:

• balance is accrued from Jan 1st or employee start date (whichever is later)
• Balance accrues to holiday-entitlement Dec 31st
• Balance can be negative
• On Jan 1st a maximum number of carryover days can be carried over to the next year.

Deductions:

• When 5 days per week are worked, public holidays do not subtract from balance
• Public holidays will be defined by staff-member region on the given date
• Deductions can be less than 1 day