Schema reference / Tables / view MDX source
berg_balance_scale
A performance-based assessment of static and dynamic balance ability, consisting of 14 tasks scored on a five-point ordinal scale.
A performance-based assessment of static and dynamic balance ability, consisting of 14 tasks scored on a five-point ordinal scale.
Purpose. Use to record the component task scores and total score for the Berg Balance Scale.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-OBSERVATION.berg_balance_scale.v0 | 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. | — |
_1_sitting_to_standing_1_sitting_to_standing_code_1_sitting_to_standing_system_1_sitting_to_standing_numeric_1_sitting_to_standing_valueset_id | coded texttext, text, text, numeric, text | yes | 1. Sitting to standing | /data[at0001]/events[at0002]/data[at0003]/items[at0004] |
_2_standing_unsupported_2_standing_unsupported_code_2_standing_unsupported_system_2_standing_unsupported_numeric_2_standing_unsupported_valueset_id | coded texttext, text, text, numeric, text | yes | 2. Standing unsupported | /data[at0001]/events[at0002]/data[at0003]/items[at0010] |
_3_sitting_with_back_unsupported_but_feet_su_1dc69c_3_sitting_with_back_unsupported_but_feet_su_1dc69c_code_3_sitting_with_back_unsupported_but_feet_su_1dc69c_system_3_sitting_with_back_unsupported_but_feet_su_1dc69c_numeric_3_sitting_with_back_unsupported_but_feet_su_1dc69c_valueset_id | coded texttext, text, text, numeric, text | yes | 3. Sitting with back unsupported but feet supported on floor or on a stool | /data[at0001]/events[at0002]/data[at0003]/items[at0016] |
_4_standing_to_sitting_4_standing_to_sitting_code_4_standing_to_sitting_system_4_standing_to_sitting_numeric_4_standing_to_sitting_valueset_id | coded texttext, text, text, numeric, text | yes | 4. Standing to sitting | /data[at0001]/events[at0002]/data[at0003]/items[at0022] |
_5_transfers_5_transfers_code_5_transfers_system_5_transfers_numeric_5_transfers_valueset_id | coded texttext, text, text, numeric, text | yes | 5. Transfers | /data[at0001]/events[at0002]/data[at0003]/items[at0028] |
_6_standing_unsupported_with_eyes_closed_6_standing_unsupported_with_eyes_closed_code_6_standing_unsupported_with_eyes_closed_system_6_standing_unsupported_with_eyes_closed_numeric_6_standing_unsupported_with_eyes_closed_valueset_id | coded texttext, text, text, numeric, text | yes | 6. Standing unsupported with eyes closed | /data[at0001]/events[at0002]/data[at0003]/items[at0034] |
_7_standing_unsupported_with_feet_together_7_standing_unsupported_with_feet_together_code_7_standing_unsupported_with_feet_together_system_7_standing_unsupported_with_feet_together_numeric_7_standing_unsupported_with_feet_together_valueset_id | coded texttext, text, text, numeric, text | yes | 7. Standing unsupported with feet together | /data[at0001]/events[at0002]/data[at0003]/items[at0040] |
_8_reaching_forward_with_outstretched_arm_wh_6b605d_8_reaching_forward_with_outstretched_arm_wh_6b605d_code_8_reaching_forward_with_outstretched_arm_wh_6b605d_system_8_reaching_forward_with_outstretched_arm_wh_6b605d_numeric_8_reaching_forward_with_outstretched_arm_wh_6b605d_valueset_id | coded texttext, text, text, numeric, text | yes | 8. Reaching forward with outstretched arm while standing | /data[at0001]/events[at0002]/data[at0003]/items[at0046] |
_9_pick_up_object_from_the_floor_from_a_stan_97a5d2_9_pick_up_object_from_the_floor_from_a_stan_97a5d2_code_9_pick_up_object_from_the_floor_from_a_stan_97a5d2_system_9_pick_up_object_from_the_floor_from_a_stan_97a5d2_numeric_9_pick_up_object_from_the_floor_from_a_stan_97a5d2_valueset_id | coded texttext, text, text, numeric, text | yes | 9. Pick up object from the floor from a standing position | /data[at0001]/events[at0002]/data[at0003]/items[at0052] |
_10_turning_to_look_behind_over_left_and_rig_0b0c3f_10_turning_to_look_behind_over_left_and_rig_0b0c3f_code_10_turning_to_look_behind_over_left_and_rig_0b0c3f_system_10_turning_to_look_behind_over_left_and_rig_0b0c3f_numeric_10_turning_to_look_behind_over_left_and_rig_0b0c3f_valueset_id | coded texttext, text, text, numeric, text | yes | 10. Turning to look behind over left and right shoulders while standing | /data[at0001]/events[at0002]/data[at0003]/items[at0058] |
_11_turn_360_degrees_11_turn_360_degrees_code_11_turn_360_degrees_system_11_turn_360_degrees_numeric_11_turn_360_degrees_valueset_id | coded texttext, text, text, numeric, text | yes | 11. Turn 360 degrees | /data[at0001]/events[at0002]/data[at0003]/items[at0064] |
_12_place_alternate_foot_on_step_or_stool_wh_17ff5b_12_place_alternate_foot_on_step_or_stool_wh_17ff5b_code_12_place_alternate_foot_on_step_or_stool_wh_17ff5b_system_12_place_alternate_foot_on_step_or_stool_wh_17ff5b_numeric_12_place_alternate_foot_on_step_or_stool_wh_17ff5b_valueset_id | coded texttext, text, text, numeric, text | yes | 12. Place alternate foot on step or stool while standing unsupported | /data[at0001]/events[at0002]/data[at0003]/items[at0070] |
_13_standing_unsupported_one_foot_in_front_13_standing_unsupported_one_foot_in_front_code_13_standing_unsupported_one_foot_in_front_system_13_standing_unsupported_one_foot_in_front_numeric_13_standing_unsupported_one_foot_in_front_valueset_id | coded texttext, text, text, numeric, text | yes | 13. Standing unsupported one foot in front | /data[at0001]/events[at0002]/data[at0003]/items[at0076] |
_14_standing_on_one_leg_14_standing_on_one_leg_code_14_standing_on_one_leg_system_14_standing_on_one_leg_numeric_14_standing_on_one_leg_valueset_id | coded texttext, text, text, numeric, text | yes | 14. Standing on one leg | /data[at0001]/events[at0002]/data[at0003]/items[at0082] |
total_score | integer | yes | Total score | /data[at0001]/events[at0002]/data[at0003]/items[at0088] |
Constraints
check ((_1_sitting_to_standing_code is null and _1_sitting_to_standing_system is null and _1_sitting_to_standing_numeric is null and _1_sitting_to_standing is null) or (_1_sitting_to_standing_valueset_id is not null and _1_sitting_to_standing_code is not null and _1_sitting_to_standing_system is not null and _1_sitting_to_standing_numeric is not null and _1_sitting_to_standing is not null))
check ((_2_standing_unsupported_code is null and _2_standing_unsupported_system is null and _2_standing_unsupported_numeric is null and _2_standing_unsupported is null) or (_2_standing_unsupported_valueset_id is not null and _2_standing_unsupported_code is not null and _2_standing_unsupported_system is not null and _2_standing_unsupported_numeric is not null and _2_standing_unsupported is not null))
check ((_3_sitting_with_back_unsupported_but_feet_su_1dc69c_code is null and _3_sitting_with_back_unsupported_but_feet_su_1dc69c_system is null and _3_sitting_with_back_unsupported_but_feet_su_1dc69c_numeric is null and _3_sitting_with_back_unsupported_but_feet_su_1dc69c is null) or (_3_sitting_with_back_unsupported_but_feet_su_1dc69c_valueset_id is not null and _3_sitting_with_back_unsupported_but_feet_su_1dc69c_code is not null and _3_sitting_with_back_unsupported_but_feet_su_1dc69c_system is not null and _3_sitting_with_back_unsupported_but_feet_su_1dc69c_numeric is not null and _3_sitting_with_back_unsupported_but_feet_su_1dc69c is not null))
check ((_4_standing_to_sitting_code is null and _4_standing_to_sitting_system is null and _4_standing_to_sitting_numeric is null and _4_standing_to_sitting is null) or (_4_standing_to_sitting_valueset_id is not null and _4_standing_to_sitting_code is not null and _4_standing_to_sitting_system is not null and _4_standing_to_sitting_numeric is not null and _4_standing_to_sitting is not null))
check ((_5_transfers_code is null and _5_transfers_system is null and _5_transfers_numeric is null and _5_transfers is null) or (_5_transfers_valueset_id is not null and _5_transfers_code is not null and _5_transfers_system is not null and _5_transfers_numeric is not null and _5_transfers is not null))
check ((_6_standing_unsupported_with_eyes_closed_code is null and _6_standing_unsupported_with_eyes_closed_system is null and _6_standing_unsupported_with_eyes_closed_numeric is null and _6_standing_unsupported_with_eyes_closed is null) or (_6_standing_unsupported_with_eyes_closed_valueset_id is not null and _6_standing_unsupported_with_eyes_closed_code is not null and _6_standing_unsupported_with_eyes_closed_system is not null and _6_standing_unsupported_with_eyes_closed_numeric is not null and _6_standing_unsupported_with_eyes_closed is not null))
check ((_7_standing_unsupported_with_feet_together_code is null and _7_standing_unsupported_with_feet_together_system is null and _7_standing_unsupported_with_feet_together_numeric is null and _7_standing_unsupported_with_feet_together is null) or (_7_standing_unsupported_with_feet_together_valueset_id is not null and _7_standing_unsupported_with_feet_together_code is not null and _7_standing_unsupported_with_feet_together_system is not null and _7_standing_unsupported_with_feet_together_numeric is not null and _7_standing_unsupported_with_feet_together is not null))
check ((_8_reaching_forward_with_outstretched_arm_wh_6b605d_code is null and _8_reaching_forward_with_outstretched_arm_wh_6b605d_system is null and _8_reaching_forward_with_outstretched_arm_wh_6b605d_numeric is null and _8_reaching_forward_with_outstretched_arm_wh_6b605d is null) or (_8_reaching_forward_with_outstretched_arm_wh_6b605d_valueset_id is not null and _8_reaching_forward_with_outstretched_arm_wh_6b605d_code is not null and _8_reaching_forward_with_outstretched_arm_wh_6b605d_system is not null and _8_reaching_forward_with_outstretched_arm_wh_6b605d_numeric is not null and _8_reaching_forward_with_outstretched_arm_wh_6b605d is not null))
check ((_9_pick_up_object_from_the_floor_from_a_stan_97a5d2_code is null and _9_pick_up_object_from_the_floor_from_a_stan_97a5d2_system is null and _9_pick_up_object_from_the_floor_from_a_stan_97a5d2_numeric is null and _9_pick_up_object_from_the_floor_from_a_stan_97a5d2 is null) or (_9_pick_up_object_from_the_floor_from_a_stan_97a5d2_valueset_id is not null and _9_pick_up_object_from_the_floor_from_a_stan_97a5d2_code is not null and _9_pick_up_object_from_the_floor_from_a_stan_97a5d2_system is not null and _9_pick_up_object_from_the_floor_from_a_stan_97a5d2_numeric is not null and _9_pick_up_object_from_the_floor_from_a_stan_97a5d2 is not null))
check ((_10_turning_to_look_behind_over_left_and_rig_0b0c3f_code is null and _10_turning_to_look_behind_over_left_and_rig_0b0c3f_system is null and _10_turning_to_look_behind_over_left_and_rig_0b0c3f_numeric is null and _10_turning_to_look_behind_over_left_and_rig_0b0c3f is null) or (_10_turning_to_look_behind_over_left_and_rig_0b0c3f_valueset_id is not null and _10_turning_to_look_behind_over_left_and_rig_0b0c3f_code is not null and _10_turning_to_look_behind_over_left_and_rig_0b0c3f_system is not null and _10_turning_to_look_behind_over_left_and_rig_0b0c3f_numeric is not null and _10_turning_to_look_behind_over_left_and_rig_0b0c3f is not null))
check ((_11_turn_360_degrees_code is null and _11_turn_360_degrees_system is null and _11_turn_360_degrees_numeric is null and _11_turn_360_degrees is null) or (_11_turn_360_degrees_valueset_id is not null and _11_turn_360_degrees_code is not null and _11_turn_360_degrees_system is not null and _11_turn_360_degrees_numeric is not null and _11_turn_360_degrees is not null))
check ((_12_place_alternate_foot_on_step_or_stool_wh_17ff5b_code is null and _12_place_alternate_foot_on_step_or_stool_wh_17ff5b_system is null and _12_place_alternate_foot_on_step_or_stool_wh_17ff5b_numeric is null and _12_place_alternate_foot_on_step_or_stool_wh_17ff5b is null) or (_12_place_alternate_foot_on_step_or_stool_wh_17ff5b_valueset_id is not null and _12_place_alternate_foot_on_step_or_stool_wh_17ff5b_code is not null and _12_place_alternate_foot_on_step_or_stool_wh_17ff5b_system is not null and _12_place_alternate_foot_on_step_or_stool_wh_17ff5b_numeric is not null and _12_place_alternate_foot_on_step_or_stool_wh_17ff5b is not null))
check ((_13_standing_unsupported_one_foot_in_front_code is null and _13_standing_unsupported_one_foot_in_front_system is null and _13_standing_unsupported_one_foot_in_front_numeric is null and _13_standing_unsupported_one_foot_in_front is null) or (_13_standing_unsupported_one_foot_in_front_valueset_id is not null and _13_standing_unsupported_one_foot_in_front_code is not null and _13_standing_unsupported_one_foot_in_front_system is not null and _13_standing_unsupported_one_foot_in_front_numeric is not null and _13_standing_unsupported_one_foot_in_front is not null))
check ((_14_standing_on_one_leg_code is null and _14_standing_on_one_leg_system is null and _14_standing_on_one_leg_numeric is null and _14_standing_on_one_leg is null) or (_14_standing_on_one_leg_valueset_id is not null and _14_standing_on_one_leg_code is not null and _14_standing_on_one_leg_system is not null and _14_standing_on_one_leg_numeric is not null and _14_standing_on_one_leg is not null))
check (total_score is null or total_score between 0 and 56)Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
_1_sitting_to_standing_valueset_id, _1_sitting_to_standing_code, _1_sitting_to_standing_system, _1_sitting_to_standing, _1_sitting_to_standing_numeric | valueset_code | restrict |
_2_standing_unsupported_valueset_id, _2_standing_unsupported_code, _2_standing_unsupported_system, _2_standing_unsupported, _2_standing_unsupported_numeric | valueset_code | restrict |
_3_sitting_with_back_unsupported_but_feet_su_1dc69c_valueset_id, _3_sitting_with_back_unsupported_but_feet_su_1dc69c_code, _3_sitting_with_back_unsupported_but_feet_su_1dc69c_system, _3_sitting_with_back_unsupported_but_feet_su_1dc69c, _3_sitting_with_back_unsupported_but_feet_su_1dc69c_numeric | valueset_code | restrict |
_4_standing_to_sitting_valueset_id, _4_standing_to_sitting_code, _4_standing_to_sitting_system, _4_standing_to_sitting, _4_standing_to_sitting_numeric | valueset_code | restrict |
_5_transfers_valueset_id, _5_transfers_code, _5_transfers_system, _5_transfers, _5_transfers_numeric | valueset_code | restrict |
_6_standing_unsupported_with_eyes_closed_valueset_id, _6_standing_unsupported_with_eyes_closed_code, _6_standing_unsupported_with_eyes_closed_system, _6_standing_unsupported_with_eyes_closed, _6_standing_unsupported_with_eyes_closed_numeric | valueset_code | restrict |
_7_standing_unsupported_with_feet_together_valueset_id, _7_standing_unsupported_with_feet_together_code, _7_standing_unsupported_with_feet_together_system, _7_standing_unsupported_with_feet_together, _7_standing_unsupported_with_feet_together_numeric | valueset_code | restrict |
_8_reaching_forward_with_outstretched_arm_wh_6b605d_valueset_id, _8_reaching_forward_with_outstretched_arm_wh_6b605d_code, _8_reaching_forward_with_outstretched_arm_wh_6b605d_system, _8_reaching_forward_with_outstretched_arm_wh_6b605d, _8_reaching_forward_with_outstretched_arm_wh_6b605d_numeric | valueset_code | restrict |
_9_pick_up_object_from_the_floor_from_a_stan_97a5d2_valueset_id, _9_pick_up_object_from_the_floor_from_a_stan_97a5d2_code, _9_pick_up_object_from_the_floor_from_a_stan_97a5d2_system, _9_pick_up_object_from_the_floor_from_a_stan_97a5d2, _9_pick_up_object_from_the_floor_from_a_stan_97a5d2_numeric | valueset_code | restrict |
_10_turning_to_look_behind_over_left_and_rig_0b0c3f_valueset_id, _10_turning_to_look_behind_over_left_and_rig_0b0c3f_code, _10_turning_to_look_behind_over_left_and_rig_0b0c3f_system, _10_turning_to_look_behind_over_left_and_rig_0b0c3f, _10_turning_to_look_behind_over_left_and_rig_0b0c3f_numeric | valueset_code | restrict |
_11_turn_360_degrees_valueset_id, _11_turn_360_degrees_code, _11_turn_360_degrees_system, _11_turn_360_degrees, _11_turn_360_degrees_numeric | valueset_code | restrict |
_12_place_alternate_foot_on_step_or_stool_wh_17ff5b_valueset_id, _12_place_alternate_foot_on_step_or_stool_wh_17ff5b_code, _12_place_alternate_foot_on_step_or_stool_wh_17ff5b_system, _12_place_alternate_foot_on_step_or_stool_wh_17ff5b, _12_place_alternate_foot_on_step_or_stool_wh_17ff5b_numeric | valueset_code | restrict |
_13_standing_unsupported_one_foot_in_front_valueset_id, _13_standing_unsupported_one_foot_in_front_code, _13_standing_unsupported_one_foot_in_front_system, _13_standing_unsupported_one_foot_in_front, _13_standing_unsupported_one_foot_in_front_numeric | valueset_code | restrict |
_14_standing_on_one_leg_valueset_id, _14_standing_on_one_leg_code, _14_standing_on_one_leg_system, _14_standing_on_one_leg, _14_standing_on_one_leg_numeric | valueset_code | restrict |
Indexes
berg_balance_scale_form_id_idxonform_id
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_10_turning_to_look_behind_over_left_and_right_shoulders_while_standing | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_11_turn_360_degrees | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_12_place_alternate_foot_on_step_or_stool_while_standing_unsupported | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_13_standing_unsupported_one_foot_in_front | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_14_standing_on_one_leg | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_1_sitting_to_standing | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_2_standing_unsupported | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_3_sitting_with_back_unsupported_but_feet_supported_on_floor_or_on_a_stool | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_4_standing_to_sitting | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_5_transfers | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_6_standing_unsupported_with_eyes_closed | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_7_standing_unsupported_with_feet_together | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_8_reaching_forward_with_outstretched_arm_while_standing | 5 |
org.openehr::openEHR-EHR-OBSERVATION.berg_balance_scale.v0/_9_pick_up_object_from_the_floor_from_a_standing_position | 5 |