A member earns its place when a source actually sends it, so a source’s finer distinctions map onto the member they fall under and the nuance is carried elsewhere: a separation’s reason on SeparationType, a leave’s kind on LeaveType. Adding a member takes an ALTER TYPE ... ADD VALUE migration, the column being a native Postgres enum.
Members
Held, and the worker is at work under it.
No longer held because the worker died.
Held, and expected to resume, while the worker is away.
Agreed, and due to begin.
No longer held, for any reason but the worker’s death.
The source carried no status, or one the connector does not recognise.