prison_configuration

12 rows


Description

Records the prisons have can be supported by this service and which have been migrated

Columns

Column Type Size Nulls Auto Default Children Parents Comments
prison_code varchar 6 null
prison_migration_date_history.prison_code Implied Constraint R

Prison ID (NOMIS column is Agency ID)

allow_auto_allocation bool 1 false

Indicates that the prisons supports auto allocation

is_enabled bool 1 false

Indicates if the prison keyworker data has been migrated

capacity int4 10 null

Default capacity for keyworkers at this prison

maximum_capacity int4 10 null

Default extended capacity for keyworkers at this prison

frequency_in_weeks int4 10 null

Key worker session frequency for the prison

has_prisoners_with_high_complexity_needs bool 1 false
policy_code varchar 16 null
policy.code prison_configuration_policy_code_fkey R
id uuid 2147483647 gen_random_uuid()

Indexes

Constraint Name Type Sort Column(s)
prison_configuration_pkey Primary key Asc id
prison_configuration_prison_code_policy_code Must be unique Asc/Asc prison_code + policy_code

Relationships