---
title: "msfc_score"
description: "The Multiple Sclerosis Functional Composite (MSFC) is a three-part, quantitative, and standardised assessment instrument for use in clinical studies and trials of Multiple Scleros…"
---

The Multiple Sclerosis Functional Composite (MSFC) is a three-part, quantitative, and standardised assessment instrument for use in clinical studies and trials of Multiple Sclerosis.

**Purpose.** To record the MSFC Score for an individual with respect to a reference population.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.msfc_score.v2` | 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. | — |
| `msfc_score_magnitude`<br />`msfc_score_units` | quantity<br />`numeric`, `text` | yes | MSFC score | `/data[at0001]/events[at0010]/data[at0003]/items[at0004]` |
| `reference_population` | `text` | yes | Reference population | `/protocol[at0005]/items[at0006]` |
| `timed_25_foot_walk_record` | `text` | yes | Timed 25-Foot walk record | `/protocol[at0005]/items[at0007]` |
| `nine_hole_peg_test_record` | `text` | yes | Nine hole peg test record | `/protocol[at0005]/items[at0008]` |
| `paced_auditory_serial_addition_test_record` | `text` | yes | Paced auditory serial addition test record | `/protocol[at0005]/items[at0009]` |

## Constraints

```sql
check ((msfc_score_magnitude is null and msfc_score_units is null) or (msfc_score_magnitude is not null and msfc_score_units is not null))
check (msfc_score_magnitude is null or (msfc_score_units = '1' and msfc_score_magnitude between -100 and 100))
```

## 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 |

## Indexes

- `msfc_score_form_id_idx` on `form_id`