Trying to make an overview for holidays per employee. Running into the following problem:
Regulations are in the sp_indicator table but different per employee. The valid from date differs as users may be later on the payroll than start of the year.
As I try to make a list of remaining holidays from last year or holidays for contractual rights the indicator type is different from the indicator_type_id field. To get the correct data I used the If statement in the overview table... however, I need a latest date per employee for each indicator type.