safer_custody_screening_outcome

-1 rows


Description

The result of the referral screening process undertaken by the Safer Custody team. Screening is step 2 of the CSIP process which can end if the decision is not to proceed further

Columns

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

Shared primary key with csip_record. Uses the same value as csip_record.record_id
outcome_id int4 10 null
reference_data.reference_data_id safer_custody_screening_outcome_outcome_id_fkey R

Foreign key to reference data using the ‘SCREENING_OUTCOME_TYPE’ domain for the selected screening outcome. The reference_data.code value maps to OFFENDER_CSIP_REPORTS.CDR_OUTCOME
recorded_by varchar 100 null

The username of the user who recorded the safer custody screening outcome. Maps to OFFENDER_CSIP_REPORTS.CDR_OUTCOME_RECORDED_BY
recorded_by_display_name varchar 255 null

The first and last name of the user who recorded the safer custody screening outcome. Does not update if their name changes
date date 13 null

The date of the safer custody screening outcome. Maps to OFFENDER_CSIP_REPORTS.CDR_OUTCOME_DATE
reason_for_decision text 2147483647 √ null

The reasons for the safer custody screening outcome decision. Maps to OFFENDER_CSIP_REPORTS.CDR_DECISION_REASON 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)
safer_custody_screening_outcome_pkey Primary key Asc safer_custody_screening_outcome_id
idx_safer_custody_screening_outcome_outcome_id Performance Asc outcome_id

Relationships

Close relationships within degrees of separation