A father-of-one who absconded from a psychiatric unit on the grounds of a Dublin hospital was last seen alive by a gravedigger.