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

ModelLegRole
openEHR-EHR-OBSERVATION.stratify_no.v1openEHRdefines this table

Columns

ColumnTypeNullDescriptionSource
iduuid primary keynoPrimary key.
form_iduuidformnoThe form this entry was recorded on.
form_block_iduuidyesThe block within the form, when the entry is bound to one.
falls_during_the_last_three_months
falls_during_the_last_three_months_code
falls_during_the_last_three_months_system
falls_during_the_last_three_months_numeric
falls_during_the_last_three_months_valueset_id
coded text
text, text, text, numeric, text
yesFalls during the last three months/data[at0001]/events[at0002]/data[at0003]/items[at0004]
visual_impairments
visual_impairments_code
visual_impairments_system
visual_impairments_numeric
visual_impairments_valueset_id
coded text
text, text, text, numeric, text
yesVisual impairments/data[at0001]/events[at0002]/data[at0003]/items[at0006]
agitation
agitation_code
agitation_system
agitation_numeric
agitation_valueset_id
coded text
text, text, text, numeric, text
yesAgitation/data[at0001]/events[at0002]/data[at0003]/items[at0005]
frequent_toileting
frequent_toileting_code
frequent_toileting_system
frequent_toileting_numeric
frequent_toileting_valueset_id
coded text
text, text, text, numeric, text
yesFrequent toileting/data[at0001]/events[at0002]/data[at0003]/items[at0007]
transfer_mobility_transfer
transfer_mobility_transfer_code
transfer_mobility_transfer_system
transfer_mobility_transfer_numeric
transfer_mobility_transfer_valueset_id
coded text
text, text, text, numeric, text
yesTransfer/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0023]
transfer_mobility_mobility
transfer_mobility_mobility_code
transfer_mobility_mobility_system
transfer_mobility_mobility_numeric
transfer_mobility_mobility_valueset_id
coded text
text, text, text, numeric, text
yesMobility/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0024]
transfer_mobility_pointsintegeryesPoints/data[at0001]/events[at0002]/data[at0003]/items[at0022]/items[at0025]
total_scoreintegeryesTotal 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

References

ColumnsTargetOn delete
form_idformcascade
form_id, form_block_idform_blockcascade
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_numericvalueset_coderestrict
visual_impairments_valueset_id, visual_impairments_code, visual_impairments_system, visual_impairments, visual_impairments_numericvalueset_coderestrict
agitation_valueset_id, agitation_code, agitation_system, agitation, agitation_numericvalueset_coderestrict
frequent_toileting_valueset_id, frequent_toileting_code, frequent_toileting_system, frequent_toileting, frequent_toileting_numericvalueset_coderestrict
transfer_mobility_transfer_valueset_id, transfer_mobility_transfer_code, transfer_mobility_transfer_system, transfer_mobility_transfer, transfer_mobility_transfer_numericvalueset_coderestrict
transfer_mobility_mobility_valueset_id, transfer_mobility_mobility_code, transfer_mobility_mobility_system, transfer_mobility_mobility, transfer_mobility_mobility_numericvalueset_coderestrict

Indexes

Value sets

Value setCodes
org.openehr::openEHR-EHR-OBSERVATION.stratify_no.v1/agitation2
org.openehr::openEHR-EHR-OBSERVATION.stratify_no.v1/falls_during_the_last_three_months2
org.openehr::openEHR-EHR-OBSERVATION.stratify_no.v1/frequent_toileting2
org.openehr::openEHR-EHR-OBSERVATION.stratify_no.v1/mobility4
org.openehr::openEHR-EHR-OBSERVATION.stratify_no.v1/transfer4
org.openehr::openEHR-EHR-OBSERVATION.stratify_no.v1/visual_impairments2