guss

An assessment score used for the identification of dysphagia and aspiration risk.

An assessment score used for the identification of dysphagia and aspiration risk.

Purpose. To record the result for each component parameter and the total sum for the Gugging Swallowing Screen (GUSS).

Source

Columns

Constraints

check ((preliminary_investigation_indirect_swallowin_68390b_code is null and preliminary_investigation_indirect_swallowin_68390b_system is null and preliminary_investigation_indirect_swallowin_68390b_numeric is null and preliminary_investigation_indirect_swallowin_68390b is null) or (preliminary_investigation_indirect_swallowin_68390b_valueset_id is not null and preliminary_investigation_indirect_swallowin_68390b_code is not null and preliminary_investigation_indirect_swallowin_68390b_system is not null and preliminary_investigation_indirect_swallowin_68390b_numeric is not null and preliminary_investigation_indirect_swallowin_68390b is not null))
check ((preliminary_investigation_indirect_swallowin_f880a4_code is null and preliminary_investigation_indirect_swallowin_f880a4_system is null and preliminary_investigation_indirect_swallowin_f880a4_numeric is null and preliminary_investigation_indirect_swallowin_f880a4 is null) or (preliminary_investigation_indirect_swallowin_f880a4_valueset_id is not null and preliminary_investigation_indirect_swallowin_f880a4_code is not null and preliminary_investigation_indirect_swallowin_f880a4_system is not null and preliminary_investigation_indirect_swallowin_f880a4_numeric is not null and preliminary_investigation_indirect_swallowin_f880a4 is not null))
check ((preliminary_investigation_indirect_swallowin_679071_code is null and preliminary_investigation_indirect_swallowin_679071_system is null and preliminary_investigation_indirect_swallowin_679071_numeric is null and preliminary_investigation_indirect_swallowin_679071 is null) or (preliminary_investigation_indirect_swallowin_679071_valueset_id is not null and preliminary_investigation_indirect_swallowin_679071_code is not null and preliminary_investigation_indirect_swallowin_679071_system is not null and preliminary_investigation_indirect_swallowin_679071_numeric is not null and preliminary_investigation_indirect_swallowin_679071 is not null))
check ((preliminary_investigation_indirect_swallowin_ec09e9_code is null and preliminary_investigation_indirect_swallowin_ec09e9_system is null and preliminary_investigation_indirect_swallowin_ec09e9_numeric is null and preliminary_investigation_indirect_swallowin_ec09e9 is null) or (preliminary_investigation_indirect_swallowin_ec09e9_valueset_id is not null and preliminary_investigation_indirect_swallowin_ec09e9_code is not null and preliminary_investigation_indirect_swallowin_ec09e9_system is not null and preliminary_investigation_indirect_swallowin_ec09e9_numeric is not null and preliminary_investigation_indirect_swallowin_ec09e9 is not null))
check ((preliminary_investigation_indirect_swallowin_4f613a_code is null and preliminary_investigation_indirect_swallowin_4f613a_system is null and preliminary_investigation_indirect_swallowin_4f613a_numeric is null and preliminary_investigation_indirect_swallowin_4f613a is null) or (preliminary_investigation_indirect_swallowin_4f613a_valueset_id is not null and preliminary_investigation_indirect_swallowin_4f613a_code is not null and preliminary_investigation_indirect_swallowin_4f613a_system is not null and preliminary_investigation_indirect_swallowin_4f613a_numeric is not null and preliminary_investigation_indirect_swallowin_4f613a is not null))
check (preliminary_investigation_indirect_swallowing_test_sum is null or preliminary_investigation_indirect_swallowing_test_sum between 0 and 5)
check ((semisolid_deglutition_code is null and semisolid_deglutition_system is null and semisolid_deglutition_numeric is null and semisolid_deglutition is null) or (semisolid_deglutition_valueset_id is not null and semisolid_deglutition_code is not null and semisolid_deglutition_system is not null and semisolid_deglutition_numeric is not null and semisolid_deglutition is not null))
check ((semisolid_coughing_involuntary_code is null and semisolid_coughing_involuntary_system is null and semisolid_coughing_involuntary_numeric is null and semisolid_coughing_involuntary is null) or (semisolid_coughing_involuntary_valueset_id is not null and semisolid_coughing_involuntary_code is not null and semisolid_coughing_involuntary_system is not null and semisolid_coughing_involuntary_numeric is not null and semisolid_coughing_involuntary is not null))
check ((semisolid_drooling_code is null and semisolid_drooling_system is null and semisolid_drooling_numeric is null and semisolid_drooling is null) or (semisolid_drooling_valueset_id is not null and semisolid_drooling_code is not null and semisolid_drooling_system is not null and semisolid_drooling_numeric is not null and semisolid_drooling is not null))
check ((semisolid_voice_change_code is null and semisolid_voice_change_system is null and semisolid_voice_change_numeric is null and semisolid_voice_change is null) or (semisolid_voice_change_valueset_id is not null and semisolid_voice_change_code is not null and semisolid_voice_change_system is not null and semisolid_voice_change_numeric is not null and semisolid_voice_change is not null))
check (semisolid_sum is null or semisolid_sum between 0 and 5)
check ((liquid_deglutition_code is null and liquid_deglutition_system is null and liquid_deglutition_numeric is null and liquid_deglutition is null) or (liquid_deglutition_valueset_id is not null and liquid_deglutition_code is not null and liquid_deglutition_system is not null and liquid_deglutition_numeric is not null and liquid_deglutition is not null))
check ((liquid_coughing_involuntary_code is null and liquid_coughing_involuntary_system is null and liquid_coughing_involuntary_numeric is null and liquid_coughing_involuntary is null) or (liquid_coughing_involuntary_valueset_id is not null and liquid_coughing_involuntary_code is not null and liquid_coughing_involuntary_system is not null and liquid_coughing_involuntary_numeric is not null and liquid_coughing_involuntary is not null))
check ((liquid_drooling_code is null and liquid_drooling_system is null and liquid_drooling_numeric is null and liquid_drooling is null) or (liquid_drooling_valueset_id is not null and liquid_drooling_code is not null and liquid_drooling_system is not null and liquid_drooling_numeric is not null and liquid_drooling is not null))
check ((liquid_voice_change_code is null and liquid_voice_change_system is null and liquid_voice_change_numeric is null and liquid_voice_change is null) or (liquid_voice_change_valueset_id is not null and liquid_voice_change_code is not null and liquid_voice_change_system is not null and liquid_voice_change_numeric is not null and liquid_voice_change is not null))
check (liquid_sum is null or liquid_sum between 0 and 5)
check ((solid_deglutition_code is null and solid_deglutition_system is null and solid_deglutition_numeric is null and solid_deglutition is null) or (solid_deglutition_valueset_id is not null and solid_deglutition_code is not null and solid_deglutition_system is not null and solid_deglutition_numeric is not null and solid_deglutition is not null))
check ((solid_coughing_involuntary_code is null and solid_coughing_involuntary_system is null and solid_coughing_involuntary_numeric is null and solid_coughing_involuntary is null) or (solid_coughing_involuntary_valueset_id is not null and solid_coughing_involuntary_code is not null and solid_coughing_involuntary_system is not null and solid_coughing_involuntary_numeric is not null and solid_coughing_involuntary is not null))
check ((solid_drooling_code is null and solid_drooling_system is null and solid_drooling_numeric is null and solid_drooling is null) or (solid_drooling_valueset_id is not null and solid_drooling_code is not null and solid_drooling_system is not null and solid_drooling_numeric is not null and solid_drooling is not null))
check ((solid_voice_change_code is null and solid_voice_change_system is null and solid_voice_change_numeric is null and solid_voice_change is null) or (solid_voice_change_valueset_id is not null and solid_voice_change_code is not null and solid_voice_change_system is not null and solid_voice_change_numeric is not null and solid_voice_change is not null))
check (solid_sum is null or solid_sum between 0 and 5)
check (sum is null or sum between 0 and 20)
check ((results_and_severity_code_code is null and results_and_severity_code_system is null and results_and_severity_code_valueset_id is null and results_and_severity_code is null) or (results_and_severity_code is not null and results_and_severity_code_code is not null and results_and_severity_code_system is not null and results_and_severity_code_valueset_id is not null))

Unique

• form_block_id

References

Indexes

• guss_form_id_idx on form_id

Value sets