Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | √ | nextval('keyworker_stats_keyworker_stats_id_seq'::regclass) |
|
|
Primary key ID |
||||
| prison_code | varchar | 6 | null |
|
|
Prison ID |
|||||
| statistic_date | timestamp | 29,6 | null |
|
|
Timestamp of date for which stats apply |
|||||
| prisoners_assigned_count | int4 | 10 | null |
|
|
Number of prisoner who have been assigned a Key worker |
|||||
| prisoner_count | int4 | 10 | null |
|
|
Total number of prisoners in the prison on this date |
|||||
| recorded_session_count | int4 | 10 | √ | null |
|
|
Number of Key worker case note sessions |
||||
| recorded_entry_count | int4 | 10 | √ | null |
|
|
Number of Key worker case note entries |
||||
| eligible_staff_count | int4 | 10 | √ | null |
|
|
Number of active keyworkers |
||||
| reception_to_allocation_days | int4 | 10 | √ | null |
|
|
Number of days (avg) between reception and allocation of a keyworker |
||||
| reception_to_recorded_event_days | int4 | 10 | √ | null |
|
|
Number of days (avg) between reception and first Key worker session |
||||
| eligible_prisoner_count | int4 | 10 | null |
|
|
||||||
| high_complexity_of_need_prisoner_count | int4 | 10 | null |
|
|
||||||
| policy_code | varchar | 16 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_prison_statistic | Primary key | Asc | id |
| idx_prison_statistic_date_prison | Performance | Asc/Asc | statistic_date + prison_code |