keyworker_stats

-1 rows


Description

Records the results of each statistic snapshot

Columns

Column Type Size Nulls Auto Default Children Parents Comments
keyworker_stats_id bigserial 19 nextval('keyworker_stats_keyworker_stats_id_seq'::regclass)

Primary key ID

prison_id varchar 6 null

Prison ID

snapshot_date timestamp 29,6 null

Timestamp of date for which stats apply

num_prisoners_assigned_kw int4 10 null

Number of prisoner who have been assigned a Key worker

total_num_prisoners int4 10 null

Total number of prisoners in the prison on this date

num_kw_sessions int4 10 null

Number of Key worker case note sessions

num_kw_entries int4 10 null

Number of Key worker case note entries

num_active_keyworkers int4 10 null

Number of active keyworkers

recpt_to_alloc_days int4 10 null

Number of days (avg) between reception and allocation of a keyworker

recpt_to_kw_session_days int4 10 null

Number of days (avg) between reception and first Key worker session

total_num_eligible_prisoners int4 10 null
high_complexity_of_need_prisoners int4 10 null

Indexes

Constraint Name Type Sort Column(s)
keyworker_stats_pk Primary key Asc keyworker_stats_id
keyworker_stats_idx1 Must be unique Asc/Asc prison_id + snapshot_date
keyworker_stats_idx2 Performance Asc snapshot_date

Relationships