Schema reference / Tables / view MDX source
stratify_no
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 | 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_monthsfalls_during_the_last_three_months_codefalls_during_the_last_three_months_systemfalls_during_the_last_three_months_numericfalls_during_the_last_three_months_valueset_id | coded texttext, text, text, numeric, text | yes | Falls during the last three months | /data[at0001]/events[at0002]/data[at0003]/items[at0004] |
visual_impairmentsvisual_impairments_codevisual_impairments_systemvisual_impairments_numericvisual_impairments_valueset_id | coded texttext, text, text, numeric, text | yes | Visual impairments | /data[at0001]/events[at0002]/data[at0003]/items[at0006] |
agitationagitation_codeagitation_systemagitation_numericagitation_valueset_id | coded texttext, text, text, numeric, text | yes | Agitation | /data[at0001]/events[at0002]/data[at0003]/items[at0005] |
frequent_toiletingfrequent_toileting_codefrequent_toileting_systemfrequent_toileting_numericfrequent_toileting_valueset_id | coded texttext, text, text, numeric, text | yes | Frequent toileting | /data[at0001]/events[at0002]/data[at0003]/items[at0007] |
transfer_mobility_transfertransfer_mobility_transfer_codetransfer_mobility_transfer_systemtransfer_mobility_transfer_numerictransfer_mobility_transfer_valueset_id | coded texttext, text, text, numeric, text | yes | Transfer | /data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0023] |
transfer_mobility_mobilitytransfer_mobility_mobility_codetransfer_mobility_mobility_systemtransfer_mobility_mobility_numerictransfer_mobility_mobility_valueset_id | coded texttext, 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
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 | cascade |
form_id, form_block_id | 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 | restrict |
visual_impairments_valueset_id, visual_impairments_code, visual_impairments_system, visual_impairments, visual_impairments_numeric | valueset_code | restrict |
agitation_valueset_id, agitation_code, agitation_system, agitation, agitation_numeric | valueset_code | restrict |
frequent_toileting_valueset_id, frequent_toileting_code, frequent_toileting_system, frequent_toileting, frequent_toileting_numeric | 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 | restrict |
transfer_mobility_mobility_valueset_id, transfer_mobility_mobility_code, transfer_mobility_mobility_system, transfer_mobility_mobility, transfer_mobility_mobility_numeric | valueset_code | restrict |
Indexes
stratify_no_form_id_idxonform_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 |