csip_summary

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

prison_number

varchar

√

null

person_summary.prison_number

Implied Constraint

first_name

varchar

√

null

last_name

varchar

√

null

restricted_patient

bool

√

null

prison_code

varchar

√

null

cell_location

varchar

√

null

supporting_prison_code

varchar

√

null

referral_date

date

√

null

incident_type

varchar

√

null

next_review_date

date

√

null

case_manager

varchar

100

√

null

uuid

2147483647

√

null

log_code

varchar

√

null

closed_date

date

√

null

priority

int4

√

null

status_code

varchar

√

null

status_description

varchar

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT person.prison_number,
    person.first_name,
    person.last_name,
    person.restricted_patient,
    person.prison_code,
    person.cell_location,
    person.supporting_prison_code,
    ref.referral_date,
    inc.description AS incident_type,
    p.next_review_date,
    p.case_manager,
    csip.record_id AS id,
    csip.log_code,
        CASE
            WHEN ((st.code)::text = 'CSIP_CLOSED'::text) THEN p.closed_date
            ELSE NULL::date
        END AS closed_date,
        CASE
            WHEN ((st.code)::text = 'CSIP_OPEN'::text) THEN 1
            WHEN ((st.code)::text = 'CSIP_CLOSED'::text) THEN 3
            WHEN ((st.code)::text = ANY ((ARRAY['NO_FURTHER_ACTION'::character varying, 'SUPPORT_OUTSIDE_CSIP'::character varying])::text[])) THEN 4
            ELSE 2
        END AS priority,
    st.code AS status_code,
    st.description AS status_description
   FROM (((((csip_record csip
     JOIN person_summary person ON (((person.prison_number)::text = (csip.prison_number)::text)))
     JOIN referral ref ON ((ref.referral_id = csip.record_id)))
     JOIN reference_data inc ON ((inc.reference_data_id = ref.incident_type_id)))
     LEFT JOIN plan p ON ((p.plan_id = csip.record_id)))
     JOIN reference_data st ON ((st.reference_data_id = csip.status_id)));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views