staff_configuration

-1 rows


Description

Stores Key worker basic details, including status and capacity.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
staff_id int8 19 null

The unique staff identifier for Key worker in core OMS

capacity int4 10 null

Standard number of offenders that can be allocated to Key worker

status_id int8 19 null
reference_data.id key_worker_status_id_fkey R
allow_auto_allocation bool 1 null
reactivate_on date 13 null
policy_code varchar 16 null
policy.code staff_configuration_policy_code_fkey R
id uuid 2147483647 gen_random_uuid()

Indexes

Constraint Name Type Sort Column(s)
staff_configuration_pkey Primary key Asc id
staff_configuration_staff_id_policy_code Must be unique Asc/Asc staff_id + policy_code

Relationships