functional_ability

An assessment of an individual’s ability to perform an activity safely and consistently without human assistance.

An assessment of an individual’s ability to perform an activity safely and consistently without human assistance.

Purpose. To record an assessment of an individual’s ability to independently perform a single identified activity at a point in time.

Source

Columns

Constraints

check ((activity_name_code is null and activity_name_system is null and activity_name_valueset_id is null) or (activity_name is not null and activity_name_code is not null and activity_name_system is not null and activity_name_valueset_id is not null))
check ((ability_code is null and ability_system is null and ability_valueset_id is null) or (ability is not null and ability_code is not null and ability_system is not null and ability_valueset_id is not null))
check ((difficulty_code is null and difficulty_system is null and difficulty_valueset_id is null) or (difficulty is not null and difficulty_code is not null and difficulty_system is not null and difficulty_valueset_id is not null))

Unique

• form_block_id

References

Referenced by

• functional_ability_assistive_device via functional_ability_id

Indexes

• functional_ability_form_id_idx on form_id

Child tables

1 table hang off functional_ability, one row per repetition.

functional_ability_assistive_device

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

Unique

• functional_ability_id, position
• functional_ability_id, device_id

References

Indexes

• functional_ability_assistive_device_device_id_idx on device_id

Value sets