map_hand

A patient-reported assessment tool for evaluating hand activity performance (MAP-Hand).

A patient-reported assessment tool for evaluating hand activity performance (MAP-Hand).

Purpose. To record the results of the MAP-Hand tool.

Source

Columns

Constraints

check ((_1_buttoning_buttons_code is null and _1_buttoning_buttons_system is null and _1_buttoning_buttons_numeric is null and _1_buttoning_buttons is null) or (_1_buttoning_buttons_valueset_id is not null and _1_buttoning_buttons_code is not null and _1_buttoning_buttons_system is not null and _1_buttoning_buttons_numeric is not null and _1_buttoning_buttons is not null))
check ((_2_putting_on_socks_or_tights_code is null and _2_putting_on_socks_or_tights_system is null and _2_putting_on_socks_or_tights_numeric is null and _2_putting_on_socks_or_tights is null) or (_2_putting_on_socks_or_tights_valueset_id is not null and _2_putting_on_socks_or_tights_code is not null and _2_putting_on_socks_or_tights_system is not null and _2_putting_on_socks_or_tights_numeric is not null and _2_putting_on_socks_or_tights is not null))
check ((_3_tying_shoelaces_code is null and _3_tying_shoelaces_system is null and _3_tying_shoelaces_numeric is null and _3_tying_shoelaces is null) or (_3_tying_shoelaces_valueset_id is not null and _3_tying_shoelaces_code is not null and _3_tying_shoelaces_system is not null and _3_tying_shoelaces_numeric is not null and _3_tying_shoelaces is not null))
check ((_4_squeezing_out_of_tubes_e_g_toothpaste_code is null and _4_squeezing_out_of_tubes_e_g_toothpaste_system is null and _4_squeezing_out_of_tubes_e_g_toothpaste_numeric is null and _4_squeezing_out_of_tubes_e_g_toothpaste is null) or (_4_squeezing_out_of_tubes_e_g_toothpaste_valueset_id is not null and _4_squeezing_out_of_tubes_e_g_toothpaste_code is not null and _4_squeezing_out_of_tubes_e_g_toothpaste_system is not null and _4_squeezing_out_of_tubes_e_g_toothpaste_numeric is not null and _4_squeezing_out_of_tubes_e_g_toothpaste is not null))
check ((_5_brushing_teeth_code is null and _5_brushing_teeth_system is null and _5_brushing_teeth_numeric is null and _5_brushing_teeth is null) or (_5_brushing_teeth_valueset_id is not null and _5_brushing_teeth_code is not null and _5_brushing_teeth_system is not null and _5_brushing_teeth_numeric is not null and _5_brushing_teeth is not null))
check ((_6_wiping_yourself_after_using_the_toilet_code is null and _6_wiping_yourself_after_using_the_toilet_system is null and _6_wiping_yourself_after_using_the_toilet_numeric is null and _6_wiping_yourself_after_using_the_toilet is null) or (_6_wiping_yourself_after_using_the_toilet_valueset_id is not null and _6_wiping_yourself_after_using_the_toilet_code is not null and _6_wiping_yourself_after_using_the_toilet_system is not null and _6_wiping_yourself_after_using_the_toilet_numeric is not null and _6_wiping_yourself_after_using_the_toilet is not null))
check ((_7_opening_bottle_screw_tops_code is null and _7_opening_bottle_screw_tops_system is null and _7_opening_bottle_screw_tops_numeric is null and _7_opening_bottle_screw_tops is null) or (_7_opening_bottle_screw_tops_valueset_id is not null and _7_opening_bottle_screw_tops_code is not null and _7_opening_bottle_screw_tops_system is not null and _7_opening_bottle_screw_tops_numeric is not null and _7_opening_bottle_screw_tops is not null))
check ((_8_opening_hermetic_cans_code is null and _8_opening_hermetic_cans_system is null and _8_opening_hermetic_cans_numeric is null and _8_opening_hermetic_cans is null) or (_8_opening_hermetic_cans_valueset_id is not null and _8_opening_hermetic_cans_code is not null and _8_opening_hermetic_cans_system is not null and _8_opening_hermetic_cans_numeric is not null and _8_opening_hermetic_cans is not null))
check ((_9_opening_jam_jars_code is null and _9_opening_jam_jars_system is null and _9_opening_jam_jars_numeric is null and _9_opening_jam_jars is null) or (_9_opening_jam_jars_valueset_id is not null and _9_opening_jam_jars_code is not null and _9_opening_jam_jars_system is not null and _9_opening_jam_jars_numeric is not null and _9_opening_jam_jars is not null))
check ((_10_slicing_bread_using_a_knife_code is null and _10_slicing_bread_using_a_knife_system is null and _10_slicing_bread_using_a_knife_numeric is null and _10_slicing_bread_using_a_knife is null) or (_10_slicing_bread_using_a_knife_valueset_id is not null and _10_slicing_bread_using_a_knife_code is not null and _10_slicing_bread_using_a_knife_system is not null and _10_slicing_bread_using_a_knife_numeric is not null and _10_slicing_bread_using_a_knife is not null))
check ((_11_peeling_raw_vegetables_code is null and _11_peeling_raw_vegetables_system is null and _11_peeling_raw_vegetables_numeric is null and _11_peeling_raw_vegetables is null) or (_11_peeling_raw_vegetables_valueset_id is not null and _11_peeling_raw_vegetables_code is not null and _11_peeling_raw_vegetables_system is not null and _11_peeling_raw_vegetables_numeric is not null and _11_peeling_raw_vegetables is not null))
check ((_12_stirring_food_in_a_pan_code is null and _12_stirring_food_in_a_pan_system is null and _12_stirring_food_in_a_pan_numeric is null and _12_stirring_food_in_a_pan is null) or (_12_stirring_food_in_a_pan_valueset_id is not null and _12_stirring_food_in_a_pan_code is not null and _12_stirring_food_in_a_pan_system is not null and _12_stirring_food_in_a_pan_numeric is not null and _12_stirring_food_in_a_pan is not null))
check ((_13_wringing_out_cloths_code is null and _13_wringing_out_cloths_system is null and _13_wringing_out_cloths_numeric is null and _13_wringing_out_cloths is null) or (_13_wringing_out_cloths_valueset_id is not null and _13_wringing_out_cloths_code is not null and _13_wringing_out_cloths_system is not null and _13_wringing_out_cloths_numeric is not null and _13_wringing_out_cloths is not null))
check ((_14_carrying_shopping_bags_code is null and _14_carrying_shopping_bags_system is null and _14_carrying_shopping_bags_numeric is null and _14_carrying_shopping_bags is null) or (_14_carrying_shopping_bags_valueset_id is not null and _14_carrying_shopping_bags_code is not null and _14_carrying_shopping_bags_system is not null and _14_carrying_shopping_bags_numeric is not null and _14_carrying_shopping_bags is not null))
check ((_15_writing_by_hand_code is null and _15_writing_by_hand_system is null and _15_writing_by_hand_numeric is null and _15_writing_by_hand is null) or (_15_writing_by_hand_valueset_id is not null and _15_writing_by_hand_code is not null and _15_writing_by_hand_system is not null and _15_writing_by_hand_numeric is not null and _15_writing_by_hand is not null))
check ((_16_typing_on_a_computer_code is null and _16_typing_on_a_computer_system is null and _16_typing_on_a_computer_numeric is null and _16_typing_on_a_computer is null) or (_16_typing_on_a_computer_valueset_id is not null and _16_typing_on_a_computer_code is not null and _16_typing_on_a_computer_system is not null and _16_typing_on_a_computer_numeric is not null and _16_typing_on_a_computer is not null))
check ((_17_pushing_with_hands_when_getting_up_from_a_chair_code is null and _17_pushing_with_hands_when_getting_up_from_a_chair_system is null and _17_pushing_with_hands_when_getting_up_from_a_chair_numeric is null and _17_pushing_with_hands_when_getting_up_from_a_chair is null) or (_17_pushing_with_hands_when_getting_up_from_a_chair_valueset_id is not null and _17_pushing_with_hands_when_getting_up_from_a_chair_code is not null and _17_pushing_with_hands_when_getting_up_from_a_chair_system is not null and _17_pushing_with_hands_when_getting_up_from_a_chair_numeric is not null and _17_pushing_with_hands_when_getting_up_from_a_chair is not null))
check ((_18_carrying_heavy_objects_like_suitcases_an_18726a_code is null and _18_carrying_heavy_objects_like_suitcases_an_18726a_system is null and _18_carrying_heavy_objects_like_suitcases_an_18726a_numeric is null and _18_carrying_heavy_objects_like_suitcases_an_18726a is null) or (_18_carrying_heavy_objects_like_suitcases_an_18726a_valueset_id is not null and _18_carrying_heavy_objects_like_suitcases_an_18726a_code is not null and _18_carrying_heavy_objects_like_suitcases_an_18726a_system is not null and _18_carrying_heavy_objects_like_suitcases_an_18726a_numeric is not null and _18_carrying_heavy_objects_like_suitcases_an_18726a is not null))
check ((mean_score_of_predefined_activities_magnitude is null and mean_score_of_predefined_activities_units is null) or (mean_score_of_predefined_activities_magnitude is not null and mean_score_of_predefined_activities_units is not null))
check (mean_score_of_predefined_activities_magnitude is null or (mean_score_of_predefined_activities_units = '1' and mean_score_of_predefined_activities_magnitude between 1 and 4))
check ((mean_score_of_self_defined_activites_magnitude is null and mean_score_of_self_defined_activites_units is null) or (mean_score_of_self_defined_activites_magnitude is not null and mean_score_of_self_defined_activites_units is not null))
check (mean_score_of_self_defined_activites_magnitude is null or (mean_score_of_self_defined_activites_units = '1' and mean_score_of_self_defined_activites_magnitude between 1 and 4))

Unique

• form_block_id

References

Referenced by

• map_hand_self_defined_activities via map_hand_id

Indexes

• map_hand_form_id_idx on form_id

Child tables

1 table hang off map_hand, one row per repetition.

map_hand_self_defined_activities

Child table — one row per repetition, deleted with its parent.

Constraints

check ((grading_code is null and grading_system is null and grading_numeric is null and grading is null) or (grading_valueset_id is not null and grading_code is not null and grading_system is not null and grading_numeric is not null and grading is not null))

Unique

• map_hand_id, position

References

Value sets