decision_and_actions

-1 rows


Description

Record of the decision and any actions expected as a result. Recording a decision is an optional step 4 of the CSIP process following an investigation

Columns

Column Type Size Nulls Auto Default Children Parents Comments
decision_and_actions_id uuid 2147483647 null
referral.referral_id decision_and_actions_decision_and_actions_id_fkey R

Shared primary key with csip_record. Uses the same value as csip_record.record_id
conclusion text 2147483647 √ null

The conclusion and reasons for the decision. Maps to OFFENDER_CSIP_REPORTS.INV_CONCLUSION which has a 4000 character limit
outcome_id int4 10 √ null
reference_data.reference_data_id decision_and_actions_outcome_id_fkey R

Foreign key to reference data using the ‘DECISION_OUTCOME_TYPE’ domain for the selected decision. The reference_data.code value maps to OFFENDER_CSIP_REPORTS.INV_OUTCOME
signed_off_by_role_id int4 10 √ null
reference_data.reference_data_id decision_and_actions_signed_off_by_role_id_fkey R

Foreign key to reference data using the ‘DECISION_SIGNER_ROLE’ domain for the role of the person who signed off the decision. The reference_data.code value maps to OFFENDER_CSIP_REPORTS.INV_SIGNED_OFF_BY
recorded_by varchar 100 √ null

The username of the user who recorded the decision. Maps to OFFENDER_CSIP_REPORTS.INV_OUTCOME_RECORDED_BY
recorded_by_display_name varchar 255 √ null

The first and last name of the user who recorded the decision. Does not update if their name changes
date date 13 √ null

The date the decision was made. Maps to OFFENDER_CSIP_REPORTS.INV_OUTCOME_DATE
next_steps text 2147483647 √ null

The next steps that should be taken following the decision. Maps to OFFENDER_CSIP_REPORTS.INV_NEXT_STEPS which has a 4000 character limit
actions _varchar 2147483647 null

An enumeration of actions that have been recommended. CSIP to NOMIS mappings: ‘OPEN_CSIP_ALERT’ -> OFFENDER_CSIP_REPORTS.OPEN_CSIP_ALERT, ‘NON_ASSOCIATIONS_UPDATED’ -> OFFENDER_CSIP_REPORTS.INV_NON_ASSOC_BOOKED, ‘OBSERVATION_BOOK’ -> OFFENDER_CSIP_REPORTS.INV_OBSERVATION_BOOK, ‘UNIT_OR_CELL_MOVE’ -> OFFENDER_CSIP_REPORTS.INV_MOVE, ‘CSRA_OR_RSRA_REVIEW’ -> OFFENDER_CSIP_REPORTS.INV_REVIEW, ‘SERVICE_REFERRAL’ -> OFFENDER_CSIP_REPORTS.INV_SERVICE_REFERRAL, ‘SIM_REFERRAL’ -> OFFENDER_CSIP_REPORTS.INV_SIM_REFERRAL. Only populated via NOMIS and retained for sync and reporting
action_other text 2147483647 √ null

Any other actions that are recommended to be considered. Maps to OFFENDER_CSIP_REPORTS.INV_OTHER which has a 4000 character limit
version int4 10 null

Supports optimistic locking preventing unnecessary select queries for new entities

Indexes

Constraint Name Type Sort Column(s)
decision_and_actions_pkey Primary key Asc decision_and_actions_id
idx_decision_and_actions_outcome_id Performance Asc outcome_id
idx_decision_and_actions_signed_off_role_id Performance Asc signed_off_by_role_id

Check Constraints

Constraint Name Constraint
actions_enum_check ((actions <@ ARRAY['OPEN_CSIP_ALERT'::character varying, 'NON_ASSOCIATIONS_UPDATED'::character varying, 'OBSERVATION_BOOK'::character varying, 'UNIT_OR_CELL_MOVE'::character varying, 'CSRA_OR_RSRA_REVIEW'::character varying, 'SERVICE_REFERRAL'::character varying, 'SIM_REFERRAL'::character varying]))

Relationships

Close relationships within degrees of separation