v_risk_y

V-RISK-Y is a short screening checklist for violence risk among youth and consists of 12 items, covering historical, clinical and risk management variables.

V-RISK-Y is a short screening checklist for violence risk among youth and consists of 12 items, covering historical, clinical and risk management variables.

Purpose. To record a structured assessment of short-term violence risk in adolescents aged 12–18 years based on the V-RISK-Y checklist, including scoring of individual risk factors and an overall clinical assessment.

Source

Columns

Constraints

check ((_1_prior_and_or_current_acts_of_violence_code is null and _1_prior_and_or_current_acts_of_violence_system is null and _1_prior_and_or_current_acts_of_violence_valueset_id is null and _1_prior_and_or_current_acts_of_violence is null) or (_1_prior_and_or_current_acts_of_violence is not null and _1_prior_and_or_current_acts_of_violence_code is not null and _1_prior_and_or_current_acts_of_violence_system is not null and _1_prior_and_or_current_acts_of_violence_valueset_id is not null))
check ((_2_prior_and_or_current_threats_of_violence_code is null and _2_prior_and_or_current_threats_of_violence_system is null and _2_prior_and_or_current_threats_of_violence_valueset_id is null and _2_prior_and_or_current_threats_of_violence is null) or (_2_prior_and_or_current_threats_of_violence is not null and _2_prior_and_or_current_threats_of_violence_code is not null and _2_prior_and_or_current_threats_of_violence_system is not null and _2_prior_and_or_current_threats_of_violence_valueset_id is not null))
check ((_3_prior_and_or_current_alcohol_or_substance_abuse_code is null and _3_prior_and_or_current_alcohol_or_substance_abuse_system is null and _3_prior_and_or_current_alcohol_or_substance_abuse_valueset_id is null and _3_prior_and_or_current_alcohol_or_substance_abuse is null) or (_3_prior_and_or_current_alcohol_or_substance_abuse is not null and _3_prior_and_or_current_alcohol_or_substance_abuse_code is not null and _3_prior_and_or_current_alcohol_or_substance_abuse_system is not null and _3_prior_and_or_current_alcohol_or_substance_abuse_valueset_id is not null))
check ((_4_prior_and_or_current_severe_symptoms_of_m_0d8d53_code is null and _4_prior_and_or_current_severe_symptoms_of_m_0d8d53_system is null and _4_prior_and_or_current_severe_symptoms_of_m_0d8d53_valueset_id is null and _4_prior_and_or_current_severe_symptoms_of_m_0d8d53 is null) or (_4_prior_and_or_current_severe_symptoms_of_m_0d8d53 is not null and _4_prior_and_or_current_severe_symptoms_of_m_0d8d53_code is not null and _4_prior_and_or_current_severe_symptoms_of_m_0d8d53_system is not null and _4_prior_and_or_current_severe_symptoms_of_m_0d8d53_valueset_id is not null))
check ((_5_disruptive_impulsive_behaviour_behavioura_9dee97_code is null and _5_disruptive_impulsive_behaviour_behavioura_9dee97_system is null and _5_disruptive_impulsive_behaviour_behavioura_9dee97_valueset_id is null and _5_disruptive_impulsive_behaviour_behavioura_9dee97 is null) or (_5_disruptive_impulsive_behaviour_behavioura_9dee97 is not null and _5_disruptive_impulsive_behaviour_behavioura_9dee97_code is not null and _5_disruptive_impulsive_behaviour_behavioura_9dee97_system is not null and _5_disruptive_impulsive_behaviour_behavioura_9dee97_valueset_id is not null))
check ((_6_has_poor_insight_into_the_mental_disorder_c53e7a_code is null and _6_has_poor_insight_into_the_mental_disorder_c53e7a_system is null and _6_has_poor_insight_into_the_mental_disorder_c53e7a_valueset_id is null and _6_has_poor_insight_into_the_mental_disorder_c53e7a is null) or (_6_has_poor_insight_into_the_mental_disorder_c53e7a is not null and _6_has_poor_insight_into_the_mental_disorder_c53e7a_code is not null and _6_has_poor_insight_into_the_mental_disorder_c53e7a_system is not null and _6_has_poor_insight_into_the_mental_disorder_c53e7a_valueset_id is not null))
check ((_7_suspicion_code is null and _7_suspicion_system is null and _7_suspicion_valueset_id is null and _7_suspicion is null) or (_7_suspicion is not null and _7_suspicion_code is not null and _7_suspicion_system is not null and _7_suspicion_valueset_id is not null))
check ((_8_demonstrates_lack_of_empathy_code is null and _8_demonstrates_lack_of_empathy_system is null and _8_demonstrates_lack_of_empathy_valueset_id is null and _8_demonstrates_lack_of_empathy is null) or (_8_demonstrates_lack_of_empathy is not null and _8_demonstrates_lack_of_empathy_code is not null and _8_demonstrates_lack_of_empathy_system is not null and _8_demonstrates_lack_of_empathy_valueset_id is not null))
check ((_9_unrealistic_planning_code is null and _9_unrealistic_planning_system is null and _9_unrealistic_planning_valueset_id is null and _9_unrealistic_planning is null) or (_9_unrealistic_planning is not null and _9_unrealistic_planning_code is not null and _9_unrealistic_planning_system is not null and _9_unrealistic_planning_valueset_id is not null))
check ((_10_future_stressful_situations_code is null and _10_future_stressful_situations_system is null and _10_future_stressful_situations_valueset_id is null and _10_future_stressful_situations is null) or (_10_future_stressful_situations is not null and _10_future_stressful_situations_code is not null and _10_future_stressful_situations_system is not null and _10_future_stressful_situations_valueset_id is not null))
check ((_11_prior_and_or_current_severe_trauma_code is null and _11_prior_and_or_current_severe_trauma_system is null and _11_prior_and_or_current_severe_trauma_valueset_id is null and _11_prior_and_or_current_severe_trauma is null) or (_11_prior_and_or_current_severe_trauma is not null and _11_prior_and_or_current_severe_trauma_code is not null and _11_prior_and_or_current_severe_trauma_system is not null and _11_prior_and_or_current_severe_trauma_valueset_id is not null))
check ((_12_the_youth_s_and_parents_guardians_own_pe_c35e7a_code is null and _12_the_youth_s_and_parents_guardians_own_pe_c35e7a_system is null and _12_the_youth_s_and_parents_guardians_own_pe_c35e7a_valueset_id is null and _12_the_youth_s_and_parents_guardians_own_pe_c35e7a is null) or (_12_the_youth_s_and_parents_guardians_own_pe_c35e7a is not null and _12_the_youth_s_and_parents_guardians_own_pe_c35e7a_code is not null and _12_the_youth_s_and_parents_guardians_own_pe_c35e7a_system is not null and _12_the_youth_s_and_parents_guardians_own_pe_c35e7a_valueset_id is not null))
check ((how_great_do_you_believe_the_risk_of_violenc_d6e692_code is null and how_great_do_you_believe_the_risk_of_violenc_d6e692_system is null and how_great_do_you_believe_the_risk_of_violenc_d6e692_valueset_id is null and how_great_do_you_believe_the_risk_of_violenc_d6e692 is null) or (how_great_do_you_believe_the_risk_of_violenc_d6e692 is not null and how_great_do_you_believe_the_risk_of_violenc_d6e692_code is not null and how_great_do_you_believe_the_risk_of_violenc_d6e692_system is not null and how_great_do_you_believe_the_risk_of_violenc_d6e692_valueset_id is not null))
check ((immediate_implementation_of_preventive_measures_code is null and immediate_implementation_of_preventive_measures_system is null and immediate_implementation_of_preventive_measures_valueset_id is null and immediate_implementation_of_preventive_measures is null) or (immediate_implementation_of_preventive_measures is not null and immediate_implementation_of_preventive_measures_code is not null and immediate_implementation_of_preventive_measures_system is not null and immediate_implementation_of_preventive_measures_valueset_id is not null))
check ((suggestions_for_additional_violence_risk_ass_a1fb7f_code is null and suggestions_for_additional_violence_risk_ass_a1fb7f_system is null and suggestions_for_additional_violence_risk_ass_a1fb7f_valueset_id is null and suggestions_for_additional_violence_risk_ass_a1fb7f is null) or (suggestions_for_additional_violence_risk_ass_a1fb7f is not null and suggestions_for_additional_violence_risk_ass_a1fb7f_code is not null and suggestions_for_additional_violence_risk_ass_a1fb7f_system is not null and suggestions_for_additional_violence_risk_ass_a1fb7f_valueset_id is not null))

Unique

• form_block_id

References

Indexes

• v_risk_y_form_id_idx on form_id

Value sets