guss_icu

An assessment score used for the identification of post-extubation dysphagia and aspiration risk in the intensive care unit (ICU).

An assessment score used for the identification of post-extubation dysphagia and aspiration risk in the intensive care unit (ICU).

Purpose. To record the result for each component parameter and the total sum for the Gugging Swallowing Screen for Intensive Care Units (GUSS-ICU).

Source

ModelLegRole
openEHR-EHR-OBSERVATION.guss_icu.v1openEHRdefines this table

Columns

ColumnTypeNullDescriptionSource
iduuid primary keynoPrimary key.
form_iduuidformnoThe form this entry was recorded on.
form_block_iduuidyesThe block within the form, when the entry is bound to one.
preliminary_investigation_indirect_swallowin_d0b616
preliminary_investigation_indirect_swallowin_d0b616_code
preliminary_investigation_indirect_swallowin_d0b616_system
preliminary_investigation_indirect_swallowin_d0b616_numeric
preliminary_investigation_indirect_swallowin_d0b616_valueset_id
coded text
text, text, text, numeric, text
yesRASS from 0 to +2/data[at0001]/events[at0002]/data[at0003]/items[at0004]/items[at0005]
preliminary_investigation_indirect_swallowin_4fb426
preliminary_investigation_indirect_swallowin_4fb426_code
preliminary_investigation_indirect_swallowin_4fb426_system
preliminary_investigation_indirect_swallowin_4fb426_numeric
preliminary_investigation_indirect_swallowin_4fb426_valueset_id
coded text
text, text, text, numeric, text
yesStridor present/data[at0001]/events[at0002]/data[at0003]/items[at0004]/items[at0035]
preliminary_investigation_indirect_swallowin_520355
preliminary_investigation_indirect_swallowin_520355_code
preliminary_investigation_indirect_swallowin_520355_system
preliminary_investigation_indirect_swallowin_520355_numeric
preliminary_investigation_indirect_swallowin_520355_valueset_id
coded text
text, text, text, numeric, text
yesCoughing and/or throat clearing efficiently/data[at0001]/events[at0002]/data[at0003]/items[at0004]/items[at0008]
preliminary_investigation_indirect_swallowin_18853a
preliminary_investigation_indirect_swallowin_18853a_code
preliminary_investigation_indirect_swallowin_18853a_system
preliminary_investigation_indirect_swallowin_18853a_numeric
preliminary_investigation_indirect_swallowin_18853a_valueset_id
coded text
text, text, text, numeric, text
yesSwallowing saliva possible/data[at0001]/events[at0002]/data[at0003]/items[at0004]/items[at0009]
preliminary_investigation_indirect_swallowin_9f9299
preliminary_investigation_indirect_swallowin_9f9299_code
preliminary_investigation_indirect_swallowin_9f9299_system
preliminary_investigation_indirect_swallowin_9f9299_numeric
preliminary_investigation_indirect_swallowin_9f9299_valueset_id
coded text
text, text, text, numeric, text
yesDrooling (saliva)/data[at0001]/events[at0002]/data[at0003]/items[at0004]/items[at0010]
preliminary_investigation_indirect_swallowin_e8b6dc
preliminary_investigation_indirect_swallowin_e8b6dc_code
preliminary_investigation_indirect_swallowin_e8b6dc_system
preliminary_investigation_indirect_swallowin_e8b6dc_numeric
preliminary_investigation_indirect_swallowin_e8b6dc_valueset_id
coded text
text, text, text, numeric, text
yesChange of voice after swallowing saliva/data[at0001]/events[at0002]/data[at0003]/items[at0004]/items[at0011]
preliminary_investigation_indirect_swallowing_test_sumintegeryesSum/data[at0001]/events[at0002]/data[at0003]/items[at0004]/items[at0020]
direct_swallowing_test_4_subtests_semisolid
direct_swallowing_test_4_subtests_semisolid_code
direct_swallowing_test_4_subtests_semisolid_system
direct_swallowing_test_4_subtests_semisolid_numeric
direct_swallowing_test_4_subtests_semisolid_valueset_id
coded text
text, text, text, numeric, text
yesSemisolid/data[at0001]/events[at0002]/data[at0003]/items[at0021]/items[at0022]
direct_swallowing_test_4_subtests_liquids
direct_swallowing_test_4_subtests_liquids_code
direct_swallowing_test_4_subtests_liquids_system
direct_swallowing_test_4_subtests_liquids_numeric
direct_swallowing_test_4_subtests_liquids_valueset_id
coded text
text, text, text, numeric, text
yesLiquids/data[at0001]/events[at0002]/data[at0003]/items[at0021]/items[at0023]
direct_swallowing_test_4_subtests_solids
direct_swallowing_test_4_subtests_solids_code
direct_swallowing_test_4_subtests_solids_system
direct_swallowing_test_4_subtests_solids_numeric
direct_swallowing_test_4_subtests_solids_valueset_id
coded text
text, text, text, numeric, text
yesSolids/data[at0001]/events[at0002]/data[at0003]/items[at0021]/items[at0024]
direct_swallowing_test_4_subtests_liquids_solids
direct_swallowing_test_4_subtests_liquids_solids_code
direct_swallowing_test_4_subtests_liquids_solids_system
direct_swallowing_test_4_subtests_liquids_solids_numeric
direct_swallowing_test_4_subtests_liquids_solids_valueset_id
coded text
text, text, text, numeric, text
yesLiquids & Solids/data[at0001]/events[at0002]/data[at0003]/items[at0021]/items[at0025]
direct_swallowing_test_4_subtests_sumintegeryesSum/data[at0001]/events[at0002]/data[at0003]/items[at0021]/items[at0026]
total_sumintegeryesTotal sum/data[at0001]/events[at0002]/data[at0003]/items[at0027]
severity_code
severity_code_code
severity_code_system
severity_code_valueset_id
coded text
text, text, text, text
yesSeverity code/data[at0001]/events[at0002]/data[at0003]/items[at0030]

Constraints

check ((preliminary_investigation_indirect_swallowin_d0b616_code is null and preliminary_investigation_indirect_swallowin_d0b616_system is null and preliminary_investigation_indirect_swallowin_d0b616_numeric is null and preliminary_investigation_indirect_swallowin_d0b616 is null) or (preliminary_investigation_indirect_swallowin_d0b616_valueset_id is not null and preliminary_investigation_indirect_swallowin_d0b616_code is not null and preliminary_investigation_indirect_swallowin_d0b616_system is not null and preliminary_investigation_indirect_swallowin_d0b616_numeric is not null and preliminary_investigation_indirect_swallowin_d0b616 is not null))
check ((preliminary_investigation_indirect_swallowin_4fb426_code is null and preliminary_investigation_indirect_swallowin_4fb426_system is null and preliminary_investigation_indirect_swallowin_4fb426_numeric is null and preliminary_investigation_indirect_swallowin_4fb426 is null) or (preliminary_investigation_indirect_swallowin_4fb426_valueset_id is not null and preliminary_investigation_indirect_swallowin_4fb426_code is not null and preliminary_investigation_indirect_swallowin_4fb426_system is not null and preliminary_investigation_indirect_swallowin_4fb426_numeric is not null and preliminary_investigation_indirect_swallowin_4fb426 is not null))
check ((preliminary_investigation_indirect_swallowin_520355_code is null and preliminary_investigation_indirect_swallowin_520355_system is null and preliminary_investigation_indirect_swallowin_520355_numeric is null and preliminary_investigation_indirect_swallowin_520355 is null) or (preliminary_investigation_indirect_swallowin_520355_valueset_id is not null and preliminary_investigation_indirect_swallowin_520355_code is not null and preliminary_investigation_indirect_swallowin_520355_system is not null and preliminary_investigation_indirect_swallowin_520355_numeric is not null and preliminary_investigation_indirect_swallowin_520355 is not null))
check ((preliminary_investigation_indirect_swallowin_18853a_code is null and preliminary_investigation_indirect_swallowin_18853a_system is null and preliminary_investigation_indirect_swallowin_18853a_numeric is null and preliminary_investigation_indirect_swallowin_18853a is null) or (preliminary_investigation_indirect_swallowin_18853a_valueset_id is not null and preliminary_investigation_indirect_swallowin_18853a_code is not null and preliminary_investigation_indirect_swallowin_18853a_system is not null and preliminary_investigation_indirect_swallowin_18853a_numeric is not null and preliminary_investigation_indirect_swallowin_18853a is not null))
check ((preliminary_investigation_indirect_swallowin_9f9299_code is null and preliminary_investigation_indirect_swallowin_9f9299_system is null and preliminary_investigation_indirect_swallowin_9f9299_numeric is null and preliminary_investigation_indirect_swallowin_9f9299 is null) or (preliminary_investigation_indirect_swallowin_9f9299_valueset_id is not null and preliminary_investigation_indirect_swallowin_9f9299_code is not null and preliminary_investigation_indirect_swallowin_9f9299_system is not null and preliminary_investigation_indirect_swallowin_9f9299_numeric is not null and preliminary_investigation_indirect_swallowin_9f9299 is not null))
check ((preliminary_investigation_indirect_swallowin_e8b6dc_code is null and preliminary_investigation_indirect_swallowin_e8b6dc_system is null and preliminary_investigation_indirect_swallowin_e8b6dc_numeric is null and preliminary_investigation_indirect_swallowin_e8b6dc is null) or (preliminary_investigation_indirect_swallowin_e8b6dc_valueset_id is not null and preliminary_investigation_indirect_swallowin_e8b6dc_code is not null and preliminary_investigation_indirect_swallowin_e8b6dc_system is not null and preliminary_investigation_indirect_swallowin_e8b6dc_numeric is not null and preliminary_investigation_indirect_swallowin_e8b6dc is not null))
check (preliminary_investigation_indirect_swallowing_test_sum is null or preliminary_investigation_indirect_swallowing_test_sum between 0 and 6)
check ((direct_swallowing_test_4_subtests_semisolid_code is null and direct_swallowing_test_4_subtests_semisolid_system is null and direct_swallowing_test_4_subtests_semisolid_numeric is null and direct_swallowing_test_4_subtests_semisolid is null) or (direct_swallowing_test_4_subtests_semisolid_valueset_id is not null and direct_swallowing_test_4_subtests_semisolid_code is not null and direct_swallowing_test_4_subtests_semisolid_system is not null and direct_swallowing_test_4_subtests_semisolid_numeric is not null and direct_swallowing_test_4_subtests_semisolid is not null))
check ((direct_swallowing_test_4_subtests_liquids_code is null and direct_swallowing_test_4_subtests_liquids_system is null and direct_swallowing_test_4_subtests_liquids_numeric is null and direct_swallowing_test_4_subtests_liquids is null) or (direct_swallowing_test_4_subtests_liquids_valueset_id is not null and direct_swallowing_test_4_subtests_liquids_code is not null and direct_swallowing_test_4_subtests_liquids_system is not null and direct_swallowing_test_4_subtests_liquids_numeric is not null and direct_swallowing_test_4_subtests_liquids is not null))
check ((direct_swallowing_test_4_subtests_solids_code is null and direct_swallowing_test_4_subtests_solids_system is null and direct_swallowing_test_4_subtests_solids_numeric is null and direct_swallowing_test_4_subtests_solids is null) or (direct_swallowing_test_4_subtests_solids_valueset_id is not null and direct_swallowing_test_4_subtests_solids_code is not null and direct_swallowing_test_4_subtests_solids_system is not null and direct_swallowing_test_4_subtests_solids_numeric is not null and direct_swallowing_test_4_subtests_solids is not null))
check ((direct_swallowing_test_4_subtests_liquids_solids_code is null and direct_swallowing_test_4_subtests_liquids_solids_system is null and direct_swallowing_test_4_subtests_liquids_solids_numeric is null and direct_swallowing_test_4_subtests_liquids_solids is null) or (direct_swallowing_test_4_subtests_liquids_solids_valueset_id is not null and direct_swallowing_test_4_subtests_liquids_solids_code is not null and direct_swallowing_test_4_subtests_liquids_solids_system is not null and direct_swallowing_test_4_subtests_liquids_solids_numeric is not null and direct_swallowing_test_4_subtests_liquids_solids is not null))
check (direct_swallowing_test_4_subtests_sum is null or direct_swallowing_test_4_subtests_sum between 0 and 4)
check (total_sum is null or total_sum between 0 and 10)
check ((severity_code_code is null and severity_code_system is null and severity_code_valueset_id is null and severity_code is null) or (severity_code is not null and severity_code_code is not null and severity_code_system is not null and severity_code_valueset_id is not null))

Unique

References

ColumnsTargetOn delete
form_idformcascade
form_id, form_block_idform_blockcascade
preliminary_investigation_indirect_swallowin_d0b616_valueset_id, preliminary_investigation_indirect_swallowin_d0b616_code, preliminary_investigation_indirect_swallowin_d0b616_system, preliminary_investigation_indirect_swallowin_d0b616, preliminary_investigation_indirect_swallowin_d0b616_numericvalueset_coderestrict
preliminary_investigation_indirect_swallowin_4fb426_valueset_id, preliminary_investigation_indirect_swallowin_4fb426_code, preliminary_investigation_indirect_swallowin_4fb426_system, preliminary_investigation_indirect_swallowin_4fb426, preliminary_investigation_indirect_swallowin_4fb426_numericvalueset_coderestrict
preliminary_investigation_indirect_swallowin_520355_valueset_id, preliminary_investigation_indirect_swallowin_520355_code, preliminary_investigation_indirect_swallowin_520355_system, preliminary_investigation_indirect_swallowin_520355, preliminary_investigation_indirect_swallowin_520355_numericvalueset_coderestrict
preliminary_investigation_indirect_swallowin_18853a_valueset_id, preliminary_investigation_indirect_swallowin_18853a_code, preliminary_investigation_indirect_swallowin_18853a_system, preliminary_investigation_indirect_swallowin_18853a, preliminary_investigation_indirect_swallowin_18853a_numericvalueset_coderestrict
preliminary_investigation_indirect_swallowin_9f9299_valueset_id, preliminary_investigation_indirect_swallowin_9f9299_code, preliminary_investigation_indirect_swallowin_9f9299_system, preliminary_investigation_indirect_swallowin_9f9299, preliminary_investigation_indirect_swallowin_9f9299_numericvalueset_coderestrict
preliminary_investigation_indirect_swallowin_e8b6dc_valueset_id, preliminary_investigation_indirect_swallowin_e8b6dc_code, preliminary_investigation_indirect_swallowin_e8b6dc_system, preliminary_investigation_indirect_swallowin_e8b6dc, preliminary_investigation_indirect_swallowin_e8b6dc_numericvalueset_coderestrict
direct_swallowing_test_4_subtests_semisolid_valueset_id, direct_swallowing_test_4_subtests_semisolid_code, direct_swallowing_test_4_subtests_semisolid_system, direct_swallowing_test_4_subtests_semisolid, direct_swallowing_test_4_subtests_semisolid_numericvalueset_coderestrict
direct_swallowing_test_4_subtests_liquids_valueset_id, direct_swallowing_test_4_subtests_liquids_code, direct_swallowing_test_4_subtests_liquids_system, direct_swallowing_test_4_subtests_liquids, direct_swallowing_test_4_subtests_liquids_numericvalueset_coderestrict
direct_swallowing_test_4_subtests_solids_valueset_id, direct_swallowing_test_4_subtests_solids_code, direct_swallowing_test_4_subtests_solids_system, direct_swallowing_test_4_subtests_solids, direct_swallowing_test_4_subtests_solids_numericvalueset_coderestrict
direct_swallowing_test_4_subtests_liquids_solids_valueset_id, direct_swallowing_test_4_subtests_liquids_solids_code, direct_swallowing_test_4_subtests_liquids_solids_system, direct_swallowing_test_4_subtests_liquids_solids, direct_swallowing_test_4_subtests_liquids_solids_numericvalueset_coderestrict
severity_code_valueset_id, severity_code_code, severity_code_system, severity_codevalueset_coderestrict

Indexes

Value sets

Value setCodes
org.openehr::openEHR-EHR-OBSERVATION.guss_icu.v1/change_of_voice_after_swallowing_saliva2
org.openehr::openEHR-EHR-OBSERVATION.guss_icu.v1/coughing_and_or_throat_clearing_efficiently2
org.openehr::openEHR-EHR-OBSERVATION.guss_icu.v1/drooling_saliva2
org.openehr::openEHR-EHR-OBSERVATION.guss_icu.v1/liquids2
org.openehr::openEHR-EHR-OBSERVATION.guss_icu.v1/liquids_solids2
org.openehr::openEHR-EHR-OBSERVATION.guss_icu.v1/rass_from_0_to_22
org.openehr::openEHR-EHR-OBSERVATION.guss_icu.v1/semisolid2
org.openehr::openEHR-EHR-OBSERVATION.guss_icu.v1/severity_code5
org.openehr::openEHR-EHR-OBSERVATION.guss_icu.v1/solids2
org.openehr::openEHR-EHR-OBSERVATION.guss_icu.v1/stridor_present2
org.openehr::openEHR-EHR-OBSERVATION.guss_icu.v1/swallowing_saliva_possible2