Skip to main content
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

2
required
Employed, and at work.
5
required
No longer employed because the worker died.
3
required
Employed, and expected to return, while away.
1
required
Hired, and due to start.
4
required
No longer employed, for any reason but death.
0
required
The source carried no status, or one the connector does not recognise.