Schema reference / Tables / view MDX source
clinical_frailty_scale2
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 | 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. | — |
assessmentassessment_codeassessment_systemassessment_numericassessment_valueset_id | coded texttext, text, text, numeric, text | yes | Assessment | /data[at0001]/events[at0002]/data[at0003]/items[at0004] |
Constraints
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 | cascade |
form_id, form_block_id | form_block | cascade |
assessment_valueset_id, assessment_code, assessment_system, assessment, assessment_numeric | valueset_code | restrict |
Indexes
clinical_frailty_scale2_form_id_idxonform_id
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-OBSERVATION.clinical_frailty_scale2.v1/assessment | 9 |