Можно ещё так сказать: "Does he work here?" "Only theoretically." Или "Theoretically, he's supposed to work here, but I am yet to see him at his desk."