How do you do it in SQL? What ever you do in SQL could be done here.
So they always switch department on an exact year boundary. Nobody ever moves from one department to the other on May 4th for example?
I think it would be better to have a date rather than a year.