Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| plan_id | uuid | 2147483647 | null |
|
|
Shared primary key with csip_record. Uses the same value as csip_record.record_id |
|||||||||||||||||
| case_manager | varchar | 100 | √ | null |
|
|
The case manager assigned to the CSIP plan. Free text so not guaranteed to match any user information. Maps to OFFENDER_CSIP_REPORTS.CASE_MANAGER which has a 100 character limit |
||||||||||||||||
| reason_for_plan | varchar | 240 | √ | null |
|
|
The reasons motivating the creation of a CSIP plan. Maps to OFFENDER_CSIP_REPORTS.REASON which has a 240 character limit |
||||||||||||||||
| first_case_review_date | date | 13 | √ | null |
|
|
The first date the CSIP plan should be reviewed. Maps to OFFENDER_CSIP_REPORTS.CASE_REV_DATE |
||||||||||||||||
| version | int4 | 10 | null |
|
|
Supports optimistic locking preventing unnecessary select queries for new entities |
|||||||||||||||||
| next_review_date | date | 13 | √ | null |
|
|
The next date the plan should be reviewed. Set as the review.review_date value from the latest review. On the plan entity for query optimisation |
||||||||||||||||
| closed_date | date | 13 | √ | null |
|
|
The date the plan was closed. Set as the review.csip_closed_date value from the first review containing an action to close the CSIP. On the plan entity for query optimisation |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| plan_pkey | Primary key | Asc | plan_id |
| idx_plan_next_review_date | Performance | Asc | next_review_date |