A worker’s status and an assignment’s are separate fields a source reports separately, so this is never read off AssignmentStatus nor rolled up from the assignments a worker holds. Adding a member takes an ALTER TYPE ... ADD VALUE migration, the column being a native Postgres enum.
Members
No longer employed because the worker died.
Employed, and expected to return, while away.
No longer employed, for any reason but death.
The source carried no status, or one the connector does not recognise.