Schema reference / Tables / view MDX source
msfc_score
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 | 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_magnitudemsfc_score_units | quantitynumeric, 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
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 | cascade |
form_id, form_block_id | form_block | cascade |
Indexes
msfc_score_form_id_idxonform_id