---
title: "clinical_frailty_scale2"
description: "An assessment scale used to screen for frailty and to broadly stratify degrees of fitness and frailty in an individual over the age of 65."
---

An assessment scale used to screen for frailty and to broadly stratify degrees of fitness and frailty in an individual over the age of 65.

**Purpose.** To record the Clinical Frailty Scale (CFS) 2.0 assessment.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.clinical_frailty_scale2.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. | — |
| `assessment`<br />`assessment_code`<br />`assessment_system`<br />`assessment_numeric`<br />`assessment_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Assessment | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]` |

## Constraints

```sql
check ((assessment_code is null and assessment_system is null and assessment_numeric is null and assessment is null) or (assessment_valueset_id is not null and assessment_code is not null and assessment_system is not null and assessment_numeric is not null and assessment 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 |
| `assessment_valueset_id, assessment_code, assessment_system, assessment, assessment_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Indexes

- `clinical_frailty_scale2_form_id_idx` on `form_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-OBSERVATION.clinical_frailty_scale2.v1/assessment` | 9 |