Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| identified_need_id | uuid | 2147483647 | null |
|
|
Public primary key |
|||||
| plan_id | uuid | 2147483647 | null |
|
|
Parent plan foreign key which is the shared primary key with csip_record and therefore uses the same value as csip_record.record_id |
|||||
| identified_need | text | 2147483647 | null |
|
|
Details of the need identified in the CSIP plan. Maps to OFFENDER_CSIP_PLANS.IDENTIFIED_NEED which has a 1000 character limit |
|||||
| responsible_person | varchar | 100 | null |
|
|
The name of the person who is responsible for taking action on the intervention. Free text so not guaranteed to match any user information. Maps to OFFENDER_CSIP_PLANS.BY_WHOM which has a 100 character limit |
|||||
| created_date | date | 13 | null |
|
|
The date the need was identified. Maps to OFFENDER_CSIP_PLANS.CREATE_DATE |
|||||
| target_date | date | 13 | null |
|
|
The target date the need should be progressed or resolved. Maps to OFFENDER_CSIP_PLANS.TARGET_DATE |
|||||
| closed_date | date | 13 | √ | null |
|
|
The date the identified need was resolved and closed. Maps to OFFENDER_CSIP_PLANS.CLOSED_DATE |
||||
| intervention | text | 2147483647 | null |
|
|
The planned intervention for the identified need. Maps to OFFENDER_CSIP_PLANS.INTERVENTION which has a 4000 character limit |
|||||
| progression | text | 2147483647 | √ | null |
|
|
How the plan to address the identified need is progressing. Maps to OFFENDER_CSIP_PLANS.PROGRESSION which has a 4000 character limit |
||||
| version | int4 | 10 | null |
|
|
Supports optimistic locking preventing unnecessary select queries for new entities |
|||||
| legacy_id | int8 | 19 | √ | null |
|
|
The NOMIS OFFENDER_CSIP_PLANS.PLAN_ID primary key value. Stored to guarantee uniqueness via sync. Not returned by API |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| identified_need_pkey | Primary key | Asc | identified_need_id |
| identified_need_legacy_id_key | Must be unique | Asc | legacy_id |
| idx_identified_need_record_id | Performance | Asc | plan_id |