I've started to implement a holiday/absence request system. Using employee and a holiday table.
I'm up to the point where I've calculated how many days a person has accrued from two dates located on the employee, holiday year start and holiday year end. Currently set to 1/1/18 to 31/12/18.
What's confusing me now is how do these figures refresh for the next year? I'm not sure I've designed this efficently.
Also how can I show holidays left for the current year, not taking into account past years?
Would it be best showing these "statistics" on the employee record or within each holiday line?