No, to me, those are quite opposite. 'He is absent' has an implication that he is absent without leave. If he was away with approval, it would be more normal to say 'He is away from work'.
Yes, I think that 'a leave of absence' works. Perhaps with a formal style like that, it would be more appropriate to use 'he applies' instead, to match the register.