added triggers for rank and designation update