---
title: "stratify_no"
description: "Assessment tool for identifying falls risk in elderly patients admitted to hospital or other 24h healthcare institutions."
---

Assessment tool for identifying falls risk in elderly patients admitted to hospital or other 24h healthcare institutions. This version of the tool is based on a modified Norwegian translation, which has been deployed by the The Norwegian Patient Safety Programme.

**Purpose.** For screening for falls risk in patients over 65 years of age, and other adults with neurological or cognitive conditions or significant visual impairment.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.stratify_no.v1` | 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. | — |
| `falls_during_the_last_three_months`<br />`falls_during_the_last_three_months_code`<br />`falls_during_the_last_three_months_system`<br />`falls_during_the_last_three_months_numeric`<br />`falls_during_the_last_three_months_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Falls during the last three months | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]` |
| `visual_impairments`<br />`visual_impairments_code`<br />`visual_impairments_system`<br />`visual_impairments_numeric`<br />`visual_impairments_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Visual impairments | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]` |
| `agitation`<br />`agitation_code`<br />`agitation_system`<br />`agitation_numeric`<br />`agitation_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Agitation | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]` |
| `frequent_toileting`<br />`frequent_toileting_code`<br />`frequent_toileting_system`<br />`frequent_toileting_numeric`<br />`frequent_toileting_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Frequent toileting | `/data[at0001]/events[at0002]/data[at0003]/items[at0007]` |
| `transfer_mobility_transfer`<br />`transfer_mobility_transfer_code`<br />`transfer_mobility_transfer_system`<br />`transfer_mobility_transfer_numeric`<br />`transfer_mobility_transfer_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Transfer | `/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0023]` |
| `transfer_mobility_mobility`<br />`transfer_mobility_mobility_code`<br />`transfer_mobility_mobility_system`<br />`transfer_mobility_mobility_numeric`<br />`transfer_mobility_mobility_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Mobility | `/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0024]` |
| `transfer_mobility_points` | `integer` | yes | Points | `/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0025]` |
| `total_score` | `integer` | yes | Total score | `/data[at0001]/events[at0002]/data[at0003]/items[at0009]` |

## Constraints

```sql
check ((falls_during_the_last_three_months_code is null and falls_during_the_last_three_months_system is null and falls_during_the_last_three_months_numeric is null and falls_during_the_last_three_months is null) or (falls_during_the_last_three_months_valueset_id is not null and falls_during_the_last_three_months_code is not null and falls_during_the_last_three_months_system is not null and falls_during_the_last_three_months_numeric is not null and falls_during_the_last_three_months is not null))
check ((visual_impairments_code is null and visual_impairments_system is null and visual_impairments_numeric is null and visual_impairments is null) or (visual_impairments_valueset_id is not null and visual_impairments_code is not null and visual_impairments_system is not null and visual_impairments_numeric is not null and visual_impairments is not null))
check ((agitation_code is null and agitation_system is null and agitation_numeric is null and agitation is null) or (agitation_valueset_id is not null and agitation_code is not null and agitation_system is not null and agitation_numeric is not null and agitation is not null))
check ((frequent_toileting_code is null and frequent_toileting_system is null and frequent_toileting_numeric is null and frequent_toileting is null) or (frequent_toileting_valueset_id is not null and frequent_toileting_code is not null and frequent_toileting_system is not null and frequent_toileting_numeric is not null and frequent_toileting is not null))
check ((transfer_mobility_transfer_code is null and transfer_mobility_transfer_system is null and transfer_mobility_transfer_numeric is null and transfer_mobility_transfer is null) or (transfer_mobility_transfer_valueset_id is not null and transfer_mobility_transfer_code is not null and transfer_mobility_transfer_system is not null and transfer_mobility_transfer_numeric is not null and transfer_mobility_transfer is not null))
check ((transfer_mobility_mobility_code is null and transfer_mobility_mobility_system is null and transfer_mobility_mobility_numeric is null and transfer_mobility_mobility is null) or (transfer_mobility_mobility_valueset_id is not null and transfer_mobility_mobility_code is not null and transfer_mobility_mobility_system is not null and transfer_mobility_mobility_numeric is not null and transfer_mobility_mobility is not null))
check (transfer_mobility_points is null or transfer_mobility_points between 0 and 1)
check (total_score is null or total_score between 0 and 5)
```

## 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 |
| `falls_during_the_last_three_months_valueset_id, falls_during_the_last_three_months_code, falls_during_the_last_three_months_system, falls_during_the_last_three_months, falls_during_the_last_three_months_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `visual_impairments_valueset_id, visual_impairments_code, visual_impairments_system, visual_impairments, visual_impairments_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `agitation_valueset_id, agitation_code, agitation_system, agitation, agitation_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `frequent_toileting_valueset_id, frequent_toileting_code, frequent_toileting_system, frequent_toileting, frequent_toileting_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `transfer_mobility_transfer_valueset_id, transfer_mobility_transfer_code, transfer_mobility_transfer_system, transfer_mobility_transfer, transfer_mobility_transfer_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `transfer_mobility_mobility_valueset_id, transfer_mobility_mobility_code, transfer_mobility_mobility_system, transfer_mobility_mobility, transfer_mobility_mobility_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Indexes

- `stratify_no_form_id_idx` on `form_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-OBSERVATION.stratify_no.v1/agitation` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.stratify_no.v1/falls_during_the_last_three_months` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.stratify_no.v1/frequent_toileting` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.stratify_no.v1/mobility` | 4 |
| `org.openehr::openEHR-EHR-OBSERVATION.stratify_no.v1/transfer` | 4 |
| `org.openehr::openEHR-EHR-OBSERVATION.stratify_no.v1/visual_impairments` | 2 |

