---
title: "functional_support_requirements"
description: "Summary information about the supports needed to enable or assist an individual in performing an activity."
---

Summary information about the supports needed to enable or assist an individual in performing an activity.

**Purpose.** To record summary information about the supports required to enable or assist an individual to perform an activity.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-EVALUATION.functional_support_requirements.v0` | openEHR | defines this table |

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `form_id` | `uuid` → [`form`](/docs/tables/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. | — |
| `activity_name`<br />`activity_name_code`<br />`activity_name_system`<br />`activity_name_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Activity name | `/data[at0001]/items[at0002]` |
| `support_description` | `text` | yes | Support description | `/data[at0001]/items[at0003]` |
| `assistive_devices_description` | `text` | yes | Assistive devices description | `/data[at0001]/items[at0025]` |
| `assistance_type`<br />`assistance_type_code`<br />`assistance_type_system`<br />`assistance_type_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Assistance type | `/data[at0001]/items[at0005]` |
| `physical_assistance_type`<br />`physical_assistance_type_code`<br />`physical_assistance_type_system`<br />`physical_assistance_type_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Physical assistance type | `/data[at0001]/items[at0011]` |
| `number_of_people` | `integer` | yes | Number of people | `/data[at0001]/items[at0018]` |
| `comment` | `text` | yes | Comment | `/data[at0001]/items[at0022]` |
| `last_updated` | `timestamptz` | yes | Last updated | `/protocol[at0004]/items[at0023]` |

## Constraints

```sql
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 ((assistance_type_code is null and assistance_type_system is null and assistance_type_valueset_id is null) or (assistance_type is not null and assistance_type_code is not null and assistance_type_system is not null and assistance_type_valueset_id is not null))
check ((physical_assistance_type_code is null and physical_assistance_type_system is null and physical_assistance_type_valueset_id is null and physical_assistance_type is null) or (physical_assistance_type is not null and physical_assistance_type_code is not null and physical_assistance_type_system is not null and physical_assistance_type_valueset_id is not null))
```

## Unique

- `form_block_id`

## References

| Columns | Target | On delete |
|---|---|---|
| `form_id` | [`form`](/docs/tables/form) | cascade |
| `form_id, form_block_id` | [`form_block`](/docs/tables/form_block) | cascade |
| `activity_name_valueset_id, activity_name_code, activity_name_system, activity_name` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `assistance_type_valueset_id, assistance_type_code, assistance_type_system, assistance_type` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `physical_assistance_type_valueset_id, physical_assistance_type_code, physical_assistance_type_system, physical_assistance_type` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

- [`functional_support_requirements_assistive_device_details`](/docs/tables/functional_support_requirements_assistive_device_details) via `functional_support_requirements_id`
- [`functional_support_requirements_support_person_details`](/docs/tables/functional_support_requirements_support_person_details) via `functional_support_requirements_id`

## Indexes

- `functional_support_requirements_form_id_idx` on `form_id`

## Child tables

2 tables hang off `functional_support_requirements`, one row per repetition.

### `functional_support_requirements_assistive_device_details`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `functional_support_requirements_id` | `uuid` → [`functional_support_requirements`](/docs/tables/functional_support_requirements) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `device_id` | `uuid` | no | Assistive device details | `/data[at0001]/items[at0020]` |

#### Unique

- `functional_support_requirements_id, position`
- `functional_support_requirements_id, device_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `functional_support_requirements_id` | [`functional_support_requirements`](/docs/tables/functional_support_requirements) | cascade |
| `device_id` | [`device`](/docs/tables/device) | no action |

#### Indexes

- `functional_support_requirements_assistive_device_details_482c7a` on `device_id`

### `functional_support_requirements_support_person_details`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `functional_support_requirements_id` | `uuid` → [`functional_support_requirements`](/docs/tables/functional_support_requirements) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `person_id` | `uuid` | no | Support person details | `/data[at0001]/items[at0019]` |

#### Unique

- `functional_support_requirements_id, position`
- `functional_support_requirements_id, person_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `functional_support_requirements_id` | [`functional_support_requirements`](/docs/tables/functional_support_requirements) | cascade |
| `person_id` | [`person`](/docs/tables/person) | no action |

#### Indexes

- `functional_support_requirements_support_person_details_p_e10c98` on `person_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-EVALUATION.functional_support_requirements.v0/assistance_type` | 5 |
| `org.openehr::openEHR-EHR-EVALUATION.functional_support_requirements.v0/physical_assistance_type` | 6 |