Schema reference / Tables / view MDX source
glasgow_outcome_scale_extended
A scale for assessing outcome after head injury and non-traumatic acute brain insults.
A scale for assessing outcome after head injury and non-traumatic acute brain insults.
Purpose. To record the result for each component parameter and the total score for Glasgow Outcome Scale - Extended.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1 | openEHR | defines this table |
Columns
| Column | Type | Null | Description | Source |
|---|---|---|---|---|
id | uuid primary key | no | Primary key. | — |
form_id | uuid → form | no | The form this entry was recorded on. | — |
form_block_id | uuid | yes | The block within the form, when the entry is bound to one. | — |
date_of_injury | date | yes | Date of injury | /data[at0001]/events[at0002]/data[at0003]/items[at0004] |
age_at_injury | interval | yes | Age at injury | /data[at0001]/events[at0002]/data[at0003]/items[at0005] |
interval_post_injury | interval | yes | Interval post-injury | /data[at0001]/events[at0002]/data[at0003]/items[at0006] |
respondentrespondent_coderespondent_systemrespondent_valueset_id | coded texttext, text, text, text | yes | Respondent | /data[at0001]/events[at0002]/data[at0003]/items[at0037] |
consciousness__1_is_the_head_injured_person__d0a18bconsciousness__1_is_the_head_injured_person__d0a18b_codeconsciousness__1_is_the_head_injured_person__d0a18b_systemconsciousness__1_is_the_head_injured_person__d0a18b_numericconsciousness__1_is_the_head_injured_person__d0a18b_valueset_id | coded texttext, text, text, numeric, text | yes | 1. Is the head injured person able to obey simple commands, or say any words? | /data[at0001]/events[at0002]/data[at0003]/items[at0008]/items[at0011] |
independence_in_the_home__2a_is_the_assistan_a5a77dindependence_in_the_home__2a_is_the_assistan_a5a77d_codeindependence_in_the_home__2a_is_the_assistan_a5a77d_systemindependence_in_the_home__2a_is_the_assistan_a5a77d_valueset_id | coded texttext, text, text, text | yes | 2a Is the assistance of another person at home essential every day for some activities of daily living? | /data[at0001]/events[at0002]/data[at0003]/items[at0010]/items[at0012] |
independence_in_the_home__2b_do_they_need_fr_bae299independence_in_the_home__2b_do_they_need_fr_bae299_codeindependence_in_the_home__2b_do_they_need_fr_bae299_systemindependence_in_the_home__2b_do_they_need_fr_bae299_numericindependence_in_the_home__2b_do_they_need_fr_bae299_valueset_id | coded texttext, text, text, numeric, text | yes | 2b Do they need frequent help or someone to be around at home most of the time? | /data[at0001]/events[at0002]/data[at0003]/items[at0010]/items[at0013] |
independence_in_the_home__2c_was_the_assista_90fe7bindependence_in_the_home__2c_was_the_assista_90fe7b_codeindependence_in_the_home__2c_was_the_assista_90fe7b_systemindependence_in_the_home__2c_was_the_assista_90fe7b_valueset_id | coded texttext, text, text, text | yes | 2c Was the assistance at home essential before the injury? | /data[at0001]/events[at0002]/data[at0003]/items[at0010]/items[at0014] |
independence_outside_the_home__3a_are_they_a_2b8435independence_outside_the_home__3a_are_they_a_2b8435_codeindependence_outside_the_home__3a_are_they_a_2b8435_systemindependence_outside_the_home__3a_are_they_a_2b8435_numericindependence_outside_the_home__3a_are_they_a_2b8435_valueset_id | coded texttext, text, text, numeric, text | yes | 3a Are they able to shop without assistance? | /data[at0001]/events[at0002]/data[at0003]/items[at0015]/items[at0016] |
independence_outside_the_home__3b_were_they__7469aaindependence_outside_the_home__3b_were_they__7469aa_codeindependence_outside_the_home__3b_were_they__7469aa_systemindependence_outside_the_home__3b_were_they__7469aa_valueset_id | coded texttext, text, text, text | yes | 3b Were they able to shop without assistance before the injury? | /data[at0001]/events[at0002]/data[at0003]/items[at0015]/items[at0017] |
independence_outside_the_home__4a_are_they_a_e8df33independence_outside_the_home__4a_are_they_a_e8df33_codeindependence_outside_the_home__4a_are_they_a_e8df33_systemindependence_outside_the_home__4a_are_they_a_e8df33_numericindependence_outside_the_home__4a_are_they_a_e8df33_valueset_id | coded texttext, text, text, numeric, text | yes | 4a Are they able to travel locally without assistance? | /data[at0001]/events[at0002]/data[at0003]/items[at0015]/items[at0018] |
independence_outside_the_home__4b_were_they__e6599bindependence_outside_the_home__4b_were_they__e6599b_codeindependence_outside_the_home__4b_were_they__e6599b_systemindependence_outside_the_home__4b_were_they__e6599b_valueset_id | coded texttext, text, text, text | yes | 4b Were they able to travel without assistance before the injury? | /data[at0001]/events[at0002]/data[at0003]/items[at0015]/items[at0019] |
work__5a_are_they_currently_able_to_work_to__d2542awork__5a_are_they_currently_able_to_work_to__d2542a_codework__5a_are_they_currently_able_to_work_to__d2542a_systemwork__5a_are_they_currently_able_to_work_to__d2542a_valueset_id | coded texttext, text, text, text | yes | 5a Are they currently able to work to their previous capacity? | /data[at0001]/events[at0002]/data[at0003]/items[at0020]/items[at0022] |
work__5b_how_restricted_are_theywork__5b_how_restricted_are_they_codework__5b_how_restricted_are_they_systemwork__5b_how_restricted_are_they_numericwork__5b_how_restricted_are_they_valueset_id | coded texttext, text, text, numeric, text | yes | 5b How restricted are they? | /data[at0001]/events[at0002]/data[at0003]/items[at0020]/items[at0023] |
work__5c_were_they_either_working_or_seeking_91e3b8work__5c_were_they_either_working_or_seeking_91e3b8_codework__5c_were_they_either_working_or_seeking_91e3b8_systemwork__5c_were_they_either_working_or_seeking_91e3b8_valueset_id | coded texttext, text, text, text | yes | 5c Were they either working or seeking employment before the injury (answer 'yes') or were they doing neither (answer 'no')? | /data[at0001]/events[at0002]/data[at0003]/items[at0020]/items[at0024] |
social_leisure_activities__6a_are_they_able__7cd498social_leisure_activities__6a_are_they_able__7cd498_codesocial_leisure_activities__6a_are_they_able__7cd498_systemsocial_leisure_activities__6a_are_they_able__7cd498_valueset_id | coded texttext, text, text, text | yes | 6a Are they able to resume regular social and leisure activities outside home? | /data[at0001]/events[at0002]/data[at0003]/items[at0025]/items[at0026] |
social_leisure_activities__6b_what_is_the_ex_6c40efsocial_leisure_activities__6b_what_is_the_ex_6c40ef_codesocial_leisure_activities__6b_what_is_the_ex_6c40ef_systemsocial_leisure_activities__6b_what_is_the_ex_6c40ef_numericsocial_leisure_activities__6b_what_is_the_ex_6c40ef_valueset_id | coded texttext, text, text, numeric, text | yes | 6b What is the extent of restricition on their social and leisure activities? | /data[at0001]/events[at0002]/data[at0003]/items[at0025]/items[at0027] |
social_leisure_activities__6c_did_they_engag_6858ccsocial_leisure_activities__6c_did_they_engag_6858cc_codesocial_leisure_activities__6c_did_they_engag_6858cc_systemsocial_leisure_activities__6c_did_they_engag_6858cc_valueset_id | coded texttext, text, text, text | yes | 6c Did they engage in regular social and leisure activities outside home before the injury? | /data[at0001]/events[at0002]/data[at0003]/items[at0025]/items[at0028] |
family_friendships__7a_have_there_been_psych_29e97bfamily_friendships__7a_have_there_been_psych_29e97b_codefamily_friendships__7a_have_there_been_psych_29e97b_systemfamily_friendships__7a_have_there_been_psych_29e97b_valueset_id | coded texttext, text, text, text | yes | 7a Have there been psychological problems which have resulted in ongoing family disruption or disruption to friendships? | /data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0030] |
family_friendships__7b_what_has_been_the_ext_fcd8b5family_friendships__7b_what_has_been_the_ext_fcd8b5_codefamily_friendships__7b_what_has_been_the_ext_fcd8b5_systemfamily_friendships__7b_what_has_been_the_ext_fcd8b5_numericfamily_friendships__7b_what_has_been_the_ext_fcd8b5_valueset_id | coded texttext, text, text, numeric, text | yes | 7b What has been the extent of disruption or strain? | /data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0031] |
family_friendships__7c_were_there_problems_w_72d998family_friendships__7c_were_there_problems_w_72d998_codefamily_friendships__7c_were_there_problems_w_72d998_systemfamily_friendships__7c_were_there_problems_w_72d998_valueset_id | coded texttext, text, text, text | yes | 7c Were there problems with family or friends before the injury? | /data[at0001]/events[at0002]/data[at0003]/items[at0029]/items[at0032] |
return_to_normal_life__8a_are_there_any_othe_289d14return_to_normal_life__8a_are_there_any_othe_289d14_codereturn_to_normal_life__8a_are_there_any_othe_289d14_systemreturn_to_normal_life__8a_are_there_any_othe_289d14_numericreturn_to_normal_life__8a_are_there_any_othe_289d14_valueset_id | coded texttext, text, text, numeric, text | yes | 8a Are there any other current problems relating to the injury which affect daily life? | /data[at0001]/events[at0002]/data[at0003]/items[at0033]/items[at0034] |
return_to_normal_life__8b_were_similar_probl_e26ad0return_to_normal_life__8b_were_similar_probl_e26ad0_codereturn_to_normal_life__8b_were_similar_probl_e26ad0_systemreturn_to_normal_life__8b_were_similar_probl_e26ad0_valueset_id | coded texttext, text, text, text | yes | 8b Were similar problems present before the injury? | /data[at0001]/events[at0002]/data[at0003]/items[at0033]/items[at0089] |
since_the_injury_has_the_head_injured_person_605fe3since_the_injury_has_the_head_injured_person_605fe3_codesince_the_injury_has_the_head_injured_person_605fe3_systemsince_the_injury_has_the_head_injured_person_605fe3_valueset_id | coded texttext, text, text, text | yes | Since the injury has the head injured person had any epileptic fits? | /data[at0001]/events[at0002]/data[at0003]/items[at0092] |
have_they_been_told_that_they_are_currently__8d3ea7have_they_been_told_that_they_are_currently__8d3ea7_codehave_they_been_told_that_they_are_currently__8d3ea7_systemhave_they_been_told_that_they_are_currently__8d3ea7_valueset_id | coded texttext, text, text, text | yes | Have they been told that they are currently at risk of developing epilepsy? | /data[at0001]/events[at0002]/data[at0003]/items[at0093] |
what_is_the_most_important_factor_in_outcomewhat_is_the_most_important_factor_in_outcome_codewhat_is_the_most_important_factor_in_outcome_systemwhat_is_the_most_important_factor_in_outcome_valueset_id | coded texttext, text, text, text | yes | What is the most important factor in outcome? | /data[at0001]/events[at0002]/data[at0003]/items[at0094] |
categorycategory_codecategory_systemcategory_numericcategory_valueset_id | coded texttext, text, text, numeric, text | yes | Category | /data[at0001]/events[at0002]/data[at0003]/items[at0036] |
Constraints
check ((respondent_code is null and respondent_system is null and respondent_valueset_id is null and respondent is null) or (respondent is not null and respondent_code is not null and respondent_system is not null and respondent_valueset_id is not null))
check ((consciousness__1_is_the_head_injured_person__d0a18b_code is null and consciousness__1_is_the_head_injured_person__d0a18b_system is null and consciousness__1_is_the_head_injured_person__d0a18b_numeric is null and consciousness__1_is_the_head_injured_person__d0a18b is null) or (consciousness__1_is_the_head_injured_person__d0a18b_valueset_id is not null and consciousness__1_is_the_head_injured_person__d0a18b_code is not null and consciousness__1_is_the_head_injured_person__d0a18b_system is not null and consciousness__1_is_the_head_injured_person__d0a18b_numeric is not null and consciousness__1_is_the_head_injured_person__d0a18b is not null))
check ((independence_in_the_home__2a_is_the_assistan_a5a77d_code is null and independence_in_the_home__2a_is_the_assistan_a5a77d_system is null and independence_in_the_home__2a_is_the_assistan_a5a77d_valueset_id is null and independence_in_the_home__2a_is_the_assistan_a5a77d is null) or (independence_in_the_home__2a_is_the_assistan_a5a77d is not null and independence_in_the_home__2a_is_the_assistan_a5a77d_code is not null and independence_in_the_home__2a_is_the_assistan_a5a77d_system is not null and independence_in_the_home__2a_is_the_assistan_a5a77d_valueset_id is not null))
check ((independence_in_the_home__2b_do_they_need_fr_bae299_code is null and independence_in_the_home__2b_do_they_need_fr_bae299_system is null and independence_in_the_home__2b_do_they_need_fr_bae299_numeric is null and independence_in_the_home__2b_do_they_need_fr_bae299 is null) or (independence_in_the_home__2b_do_they_need_fr_bae299_valueset_id is not null and independence_in_the_home__2b_do_they_need_fr_bae299_code is not null and independence_in_the_home__2b_do_they_need_fr_bae299_system is not null and independence_in_the_home__2b_do_they_need_fr_bae299_numeric is not null and independence_in_the_home__2b_do_they_need_fr_bae299 is not null))
check ((independence_in_the_home__2c_was_the_assista_90fe7b_code is null and independence_in_the_home__2c_was_the_assista_90fe7b_system is null and independence_in_the_home__2c_was_the_assista_90fe7b_valueset_id is null and independence_in_the_home__2c_was_the_assista_90fe7b is null) or (independence_in_the_home__2c_was_the_assista_90fe7b is not null and independence_in_the_home__2c_was_the_assista_90fe7b_code is not null and independence_in_the_home__2c_was_the_assista_90fe7b_system is not null and independence_in_the_home__2c_was_the_assista_90fe7b_valueset_id is not null))
check ((independence_outside_the_home__3a_are_they_a_2b8435_code is null and independence_outside_the_home__3a_are_they_a_2b8435_system is null and independence_outside_the_home__3a_are_they_a_2b8435_numeric is null and independence_outside_the_home__3a_are_they_a_2b8435 is null) or (independence_outside_the_home__3a_are_they_a_2b8435_valueset_id is not null and independence_outside_the_home__3a_are_they_a_2b8435_code is not null and independence_outside_the_home__3a_are_they_a_2b8435_system is not null and independence_outside_the_home__3a_are_they_a_2b8435_numeric is not null and independence_outside_the_home__3a_are_they_a_2b8435 is not null))
check ((independence_outside_the_home__3b_were_they__7469aa_code is null and independence_outside_the_home__3b_were_they__7469aa_system is null and independence_outside_the_home__3b_were_they__7469aa_valueset_id is null and independence_outside_the_home__3b_were_they__7469aa is null) or (independence_outside_the_home__3b_were_they__7469aa is not null and independence_outside_the_home__3b_were_they__7469aa_code is not null and independence_outside_the_home__3b_were_they__7469aa_system is not null and independence_outside_the_home__3b_were_they__7469aa_valueset_id is not null))
check ((independence_outside_the_home__4a_are_they_a_e8df33_code is null and independence_outside_the_home__4a_are_they_a_e8df33_system is null and independence_outside_the_home__4a_are_they_a_e8df33_numeric is null and independence_outside_the_home__4a_are_they_a_e8df33 is null) or (independence_outside_the_home__4a_are_they_a_e8df33_valueset_id is not null and independence_outside_the_home__4a_are_they_a_e8df33_code is not null and independence_outside_the_home__4a_are_they_a_e8df33_system is not null and independence_outside_the_home__4a_are_they_a_e8df33_numeric is not null and independence_outside_the_home__4a_are_they_a_e8df33 is not null))
check ((independence_outside_the_home__4b_were_they__e6599b_code is null and independence_outside_the_home__4b_were_they__e6599b_system is null and independence_outside_the_home__4b_were_they__e6599b_valueset_id is null and independence_outside_the_home__4b_were_they__e6599b is null) or (independence_outside_the_home__4b_were_they__e6599b is not null and independence_outside_the_home__4b_were_they__e6599b_code is not null and independence_outside_the_home__4b_were_they__e6599b_system is not null and independence_outside_the_home__4b_were_they__e6599b_valueset_id is not null))
check ((work__5a_are_they_currently_able_to_work_to__d2542a_code is null and work__5a_are_they_currently_able_to_work_to__d2542a_system is null and work__5a_are_they_currently_able_to_work_to__d2542a_valueset_id is null and work__5a_are_they_currently_able_to_work_to__d2542a is null) or (work__5a_are_they_currently_able_to_work_to__d2542a is not null and work__5a_are_they_currently_able_to_work_to__d2542a_code is not null and work__5a_are_they_currently_able_to_work_to__d2542a_system is not null and work__5a_are_they_currently_able_to_work_to__d2542a_valueset_id is not null))
check ((work__5b_how_restricted_are_they_code is null and work__5b_how_restricted_are_they_system is null and work__5b_how_restricted_are_they_numeric is null and work__5b_how_restricted_are_they is null) or (work__5b_how_restricted_are_they_valueset_id is not null and work__5b_how_restricted_are_they_code is not null and work__5b_how_restricted_are_they_system is not null and work__5b_how_restricted_are_they_numeric is not null and work__5b_how_restricted_are_they is not null))
check ((work__5c_were_they_either_working_or_seeking_91e3b8_code is null and work__5c_were_they_either_working_or_seeking_91e3b8_system is null and work__5c_were_they_either_working_or_seeking_91e3b8_valueset_id is null and work__5c_were_they_either_working_or_seeking_91e3b8 is null) or (work__5c_were_they_either_working_or_seeking_91e3b8 is not null and work__5c_were_they_either_working_or_seeking_91e3b8_code is not null and work__5c_were_they_either_working_or_seeking_91e3b8_system is not null and work__5c_were_they_either_working_or_seeking_91e3b8_valueset_id is not null))
check ((social_leisure_activities__6a_are_they_able__7cd498_code is null and social_leisure_activities__6a_are_they_able__7cd498_system is null and social_leisure_activities__6a_are_they_able__7cd498_valueset_id is null and social_leisure_activities__6a_are_they_able__7cd498 is null) or (social_leisure_activities__6a_are_they_able__7cd498 is not null and social_leisure_activities__6a_are_they_able__7cd498_code is not null and social_leisure_activities__6a_are_they_able__7cd498_system is not null and social_leisure_activities__6a_are_they_able__7cd498_valueset_id is not null))
check ((social_leisure_activities__6b_what_is_the_ex_6c40ef_code is null and social_leisure_activities__6b_what_is_the_ex_6c40ef_system is null and social_leisure_activities__6b_what_is_the_ex_6c40ef_numeric is null and social_leisure_activities__6b_what_is_the_ex_6c40ef is null) or (social_leisure_activities__6b_what_is_the_ex_6c40ef_valueset_id is not null and social_leisure_activities__6b_what_is_the_ex_6c40ef_code is not null and social_leisure_activities__6b_what_is_the_ex_6c40ef_system is not null and social_leisure_activities__6b_what_is_the_ex_6c40ef_numeric is not null and social_leisure_activities__6b_what_is_the_ex_6c40ef is not null))
check ((social_leisure_activities__6c_did_they_engag_6858cc_code is null and social_leisure_activities__6c_did_they_engag_6858cc_system is null and social_leisure_activities__6c_did_they_engag_6858cc_valueset_id is null and social_leisure_activities__6c_did_they_engag_6858cc is null) or (social_leisure_activities__6c_did_they_engag_6858cc is not null and social_leisure_activities__6c_did_they_engag_6858cc_code is not null and social_leisure_activities__6c_did_they_engag_6858cc_system is not null and social_leisure_activities__6c_did_they_engag_6858cc_valueset_id is not null))
check ((family_friendships__7a_have_there_been_psych_29e97b_code is null and family_friendships__7a_have_there_been_psych_29e97b_system is null and family_friendships__7a_have_there_been_psych_29e97b_valueset_id is null and family_friendships__7a_have_there_been_psych_29e97b is null) or (family_friendships__7a_have_there_been_psych_29e97b is not null and family_friendships__7a_have_there_been_psych_29e97b_code is not null and family_friendships__7a_have_there_been_psych_29e97b_system is not null and family_friendships__7a_have_there_been_psych_29e97b_valueset_id is not null))
check ((family_friendships__7b_what_has_been_the_ext_fcd8b5_code is null and family_friendships__7b_what_has_been_the_ext_fcd8b5_system is null and family_friendships__7b_what_has_been_the_ext_fcd8b5_numeric is null and family_friendships__7b_what_has_been_the_ext_fcd8b5 is null) or (family_friendships__7b_what_has_been_the_ext_fcd8b5_valueset_id is not null and family_friendships__7b_what_has_been_the_ext_fcd8b5_code is not null and family_friendships__7b_what_has_been_the_ext_fcd8b5_system is not null and family_friendships__7b_what_has_been_the_ext_fcd8b5_numeric is not null and family_friendships__7b_what_has_been_the_ext_fcd8b5 is not null))
check ((family_friendships__7c_were_there_problems_w_72d998_code is null and family_friendships__7c_were_there_problems_w_72d998_system is null and family_friendships__7c_were_there_problems_w_72d998_valueset_id is null and family_friendships__7c_were_there_problems_w_72d998 is null) or (family_friendships__7c_were_there_problems_w_72d998 is not null and family_friendships__7c_were_there_problems_w_72d998_code is not null and family_friendships__7c_were_there_problems_w_72d998_system is not null and family_friendships__7c_were_there_problems_w_72d998_valueset_id is not null))
check ((return_to_normal_life__8a_are_there_any_othe_289d14_code is null and return_to_normal_life__8a_are_there_any_othe_289d14_system is null and return_to_normal_life__8a_are_there_any_othe_289d14_numeric is null and return_to_normal_life__8a_are_there_any_othe_289d14 is null) or (return_to_normal_life__8a_are_there_any_othe_289d14_valueset_id is not null and return_to_normal_life__8a_are_there_any_othe_289d14_code is not null and return_to_normal_life__8a_are_there_any_othe_289d14_system is not null and return_to_normal_life__8a_are_there_any_othe_289d14_numeric is not null and return_to_normal_life__8a_are_there_any_othe_289d14 is not null))
check ((return_to_normal_life__8b_were_similar_probl_e26ad0_code is null and return_to_normal_life__8b_were_similar_probl_e26ad0_system is null and return_to_normal_life__8b_were_similar_probl_e26ad0_valueset_id is null and return_to_normal_life__8b_were_similar_probl_e26ad0 is null) or (return_to_normal_life__8b_were_similar_probl_e26ad0 is not null and return_to_normal_life__8b_were_similar_probl_e26ad0_code is not null and return_to_normal_life__8b_were_similar_probl_e26ad0_system is not null and return_to_normal_life__8b_were_similar_probl_e26ad0_valueset_id is not null))
check ((since_the_injury_has_the_head_injured_person_605fe3_code is null and since_the_injury_has_the_head_injured_person_605fe3_system is null and since_the_injury_has_the_head_injured_person_605fe3_valueset_id is null and since_the_injury_has_the_head_injured_person_605fe3 is null) or (since_the_injury_has_the_head_injured_person_605fe3 is not null and since_the_injury_has_the_head_injured_person_605fe3_code is not null and since_the_injury_has_the_head_injured_person_605fe3_system is not null and since_the_injury_has_the_head_injured_person_605fe3_valueset_id is not null))
check ((have_they_been_told_that_they_are_currently__8d3ea7_code is null and have_they_been_told_that_they_are_currently__8d3ea7_system is null and have_they_been_told_that_they_are_currently__8d3ea7_valueset_id is null and have_they_been_told_that_they_are_currently__8d3ea7 is null) or (have_they_been_told_that_they_are_currently__8d3ea7 is not null and have_they_been_told_that_they_are_currently__8d3ea7_code is not null and have_they_been_told_that_they_are_currently__8d3ea7_system is not null and have_they_been_told_that_they_are_currently__8d3ea7_valueset_id is not null))
check ((what_is_the_most_important_factor_in_outcome_code is null and what_is_the_most_important_factor_in_outcome_system is null and what_is_the_most_important_factor_in_outcome_valueset_id is null and what_is_the_most_important_factor_in_outcome is null) or (what_is_the_most_important_factor_in_outcome is not null and what_is_the_most_important_factor_in_outcome_code is not null and what_is_the_most_important_factor_in_outcome_system is not null and what_is_the_most_important_factor_in_outcome_valueset_id is not null))
check ((category_code is null and category_system is null and category_numeric is null and category is null) or (category_valueset_id is not null and category_code is not null and category_system is not null and category_numeric is not null and category is not null))Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
respondent_valueset_id, respondent_code, respondent_system, respondent | valueset_code | restrict |
consciousness__1_is_the_head_injured_person__d0a18b_valueset_id, consciousness__1_is_the_head_injured_person__d0a18b_code, consciousness__1_is_the_head_injured_person__d0a18b_system, consciousness__1_is_the_head_injured_person__d0a18b, consciousness__1_is_the_head_injured_person__d0a18b_numeric | valueset_code | restrict |
independence_in_the_home__2a_is_the_assistan_a5a77d_valueset_id, independence_in_the_home__2a_is_the_assistan_a5a77d_code, independence_in_the_home__2a_is_the_assistan_a5a77d_system, independence_in_the_home__2a_is_the_assistan_a5a77d | valueset_code | restrict |
independence_in_the_home__2b_do_they_need_fr_bae299_valueset_id, independence_in_the_home__2b_do_they_need_fr_bae299_code, independence_in_the_home__2b_do_they_need_fr_bae299_system, independence_in_the_home__2b_do_they_need_fr_bae299, independence_in_the_home__2b_do_they_need_fr_bae299_numeric | valueset_code | restrict |
independence_in_the_home__2c_was_the_assista_90fe7b_valueset_id, independence_in_the_home__2c_was_the_assista_90fe7b_code, independence_in_the_home__2c_was_the_assista_90fe7b_system, independence_in_the_home__2c_was_the_assista_90fe7b | valueset_code | restrict |
independence_outside_the_home__3a_are_they_a_2b8435_valueset_id, independence_outside_the_home__3a_are_they_a_2b8435_code, independence_outside_the_home__3a_are_they_a_2b8435_system, independence_outside_the_home__3a_are_they_a_2b8435, independence_outside_the_home__3a_are_they_a_2b8435_numeric | valueset_code | restrict |
independence_outside_the_home__3b_were_they__7469aa_valueset_id, independence_outside_the_home__3b_were_they__7469aa_code, independence_outside_the_home__3b_were_they__7469aa_system, independence_outside_the_home__3b_were_they__7469aa | valueset_code | restrict |
independence_outside_the_home__4a_are_they_a_e8df33_valueset_id, independence_outside_the_home__4a_are_they_a_e8df33_code, independence_outside_the_home__4a_are_they_a_e8df33_system, independence_outside_the_home__4a_are_they_a_e8df33, independence_outside_the_home__4a_are_they_a_e8df33_numeric | valueset_code | restrict |
independence_outside_the_home__4b_were_they__e6599b_valueset_id, independence_outside_the_home__4b_were_they__e6599b_code, independence_outside_the_home__4b_were_they__e6599b_system, independence_outside_the_home__4b_were_they__e6599b | valueset_code | restrict |
work__5a_are_they_currently_able_to_work_to__d2542a_valueset_id, work__5a_are_they_currently_able_to_work_to__d2542a_code, work__5a_are_they_currently_able_to_work_to__d2542a_system, work__5a_are_they_currently_able_to_work_to__d2542a | valueset_code | restrict |
work__5b_how_restricted_are_they_valueset_id, work__5b_how_restricted_are_they_code, work__5b_how_restricted_are_they_system, work__5b_how_restricted_are_they, work__5b_how_restricted_are_they_numeric | valueset_code | restrict |
work__5c_were_they_either_working_or_seeking_91e3b8_valueset_id, work__5c_were_they_either_working_or_seeking_91e3b8_code, work__5c_were_they_either_working_or_seeking_91e3b8_system, work__5c_were_they_either_working_or_seeking_91e3b8 | valueset_code | restrict |
social_leisure_activities__6a_are_they_able__7cd498_valueset_id, social_leisure_activities__6a_are_they_able__7cd498_code, social_leisure_activities__6a_are_they_able__7cd498_system, social_leisure_activities__6a_are_they_able__7cd498 | valueset_code | restrict |
social_leisure_activities__6b_what_is_the_ex_6c40ef_valueset_id, social_leisure_activities__6b_what_is_the_ex_6c40ef_code, social_leisure_activities__6b_what_is_the_ex_6c40ef_system, social_leisure_activities__6b_what_is_the_ex_6c40ef, social_leisure_activities__6b_what_is_the_ex_6c40ef_numeric | valueset_code | restrict |
social_leisure_activities__6c_did_they_engag_6858cc_valueset_id, social_leisure_activities__6c_did_they_engag_6858cc_code, social_leisure_activities__6c_did_they_engag_6858cc_system, social_leisure_activities__6c_did_they_engag_6858cc | valueset_code | restrict |
family_friendships__7a_have_there_been_psych_29e97b_valueset_id, family_friendships__7a_have_there_been_psych_29e97b_code, family_friendships__7a_have_there_been_psych_29e97b_system, family_friendships__7a_have_there_been_psych_29e97b | valueset_code | restrict |
family_friendships__7b_what_has_been_the_ext_fcd8b5_valueset_id, family_friendships__7b_what_has_been_the_ext_fcd8b5_code, family_friendships__7b_what_has_been_the_ext_fcd8b5_system, family_friendships__7b_what_has_been_the_ext_fcd8b5, family_friendships__7b_what_has_been_the_ext_fcd8b5_numeric | valueset_code | restrict |
family_friendships__7c_were_there_problems_w_72d998_valueset_id, family_friendships__7c_were_there_problems_w_72d998_code, family_friendships__7c_were_there_problems_w_72d998_system, family_friendships__7c_were_there_problems_w_72d998 | valueset_code | restrict |
return_to_normal_life__8a_are_there_any_othe_289d14_valueset_id, return_to_normal_life__8a_are_there_any_othe_289d14_code, return_to_normal_life__8a_are_there_any_othe_289d14_system, return_to_normal_life__8a_are_there_any_othe_289d14, return_to_normal_life__8a_are_there_any_othe_289d14_numeric | valueset_code | restrict |
return_to_normal_life__8b_were_similar_probl_e26ad0_valueset_id, return_to_normal_life__8b_were_similar_probl_e26ad0_code, return_to_normal_life__8b_were_similar_probl_e26ad0_system, return_to_normal_life__8b_were_similar_probl_e26ad0 | valueset_code | restrict |
since_the_injury_has_the_head_injured_person_605fe3_valueset_id, since_the_injury_has_the_head_injured_person_605fe3_code, since_the_injury_has_the_head_injured_person_605fe3_system, since_the_injury_has_the_head_injured_person_605fe3 | valueset_code | restrict |
have_they_been_told_that_they_are_currently__8d3ea7_valueset_id, have_they_been_told_that_they_are_currently__8d3ea7_code, have_they_been_told_that_they_are_currently__8d3ea7_system, have_they_been_told_that_they_are_currently__8d3ea7 | valueset_code | restrict |
what_is_the_most_important_factor_in_outcome_valueset_id, what_is_the_most_important_factor_in_outcome_code, what_is_the_most_important_factor_in_outcome_system, what_is_the_most_important_factor_in_outcome | valueset_code | restrict |
category_valueset_id, category_code, category_system, category, category_numeric | valueset_code | restrict |
Indexes
glasgow_outcome_scale_extended_form_id_idxonform_id
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_1_is_the_head_injured_person_able_to_obey_simple_commands_or_say_any_words | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_2a_is_the_assistance_of_another_person_at_home_essential_every_day_for_some_activities_of_daily_living | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_2b_do_they_need_frequent_help_or_someone_to_be_around_at_home_most_of_the_time | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_2c_was_the_assistance_at_home_essential_before_the_injury | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_3a_are_they_able_to_shop_without_assistance | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_3b_were_they_able_to_shop_without_assistance_before_the_injury | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_4a_are_they_able_to_travel_locally_without_assistance | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_4b_were_they_able_to_travel_without_assistance_before_the_injury | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_5a_are_they_currently_able_to_work_to_their_previous_capacity | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_5b_how_restricted_are_they | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_5c_were_they_either_working_or_seeking_employment_before_the_injury_answer_yes_or_were_they_doing_neither_answer_no | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_6a_are_they_able_to_resume_regular_social_and_leisure_activities_outside_home | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_6b_what_is_the_extent_of_restricition_on_their_social_and_leisure_activities | 3 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_6c_did_they_engage_in_regular_social_and_leisure_activities_outside_home_before_the_injury | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_7a_have_there_been_psychological_problems_which_have_resulted_in_ongoing_family_disruption_or_disruption_to_friendships | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_7b_what_has_been_the_extent_of_disruption_or_strain | 3 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_7c_were_there_problems_with_family_or_friends_before_the_injury | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_8a_are_there_any_other_current_problems_relating_to_the_injury_which_affect_daily_life | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/_8b_were_similar_problems_present_before_the_injury | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/category | 8 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/have_they_been_told_that_they_are_currently_at_risk_of_developing_epilepsy | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/respondent | 3 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/since_the_injury_has_the_head_injured_person_had_any_epileptic_fits | 2 |
org.openehr::openEHR-EHR-OBSERVATION.glasgow_outcome_scale_extended.v1/what_is_the_most_important_factor_in_outcome | 3 |