braden_scale

The Braden scale is a tool used to assess the risk of pressure ulcer development in adults and children over the age of five years.

The Braden scale is a tool used to assess the risk of pressure ulcer development in adults and children over the age of five years.

Purpose. To record information about factors used to assess the risk of pressure ulcer development, and the total Braden Scale score.

Source

ModelLegRole
openEHR-EHR-OBSERVATION.braden_scale.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.
sensory_perception
sensory_perception_code
sensory_perception_system
sensory_perception_numeric
sensory_perception_valueset_id
coded text
text, text, text, numeric, text
yesSensory perception/data[at0001]/events[at0002]/data[at0003]/items[at0004]
moisture
moisture_code
moisture_system
moisture_numeric
moisture_valueset_id
coded text
text, text, text, numeric, text
yesMoisture/data[at0001]/events[at0002]/data[at0003]/items[at0009]
activity
activity_code
activity_system
activity_numeric
activity_valueset_id
coded text
text, text, text, numeric, text
yesActivity/data[at0001]/events[at0002]/data[at0003]/items[at0010]
mobility
mobility_code
mobility_system
mobility_numeric
mobility_valueset_id
coded text
text, text, text, numeric, text
yesMobility/data[at0001]/events[at0002]/data[at0003]/items[at0019]
nutrition
nutrition_code
nutrition_system
nutrition_numeric
nutrition_valueset_id
coded text
text, text, text, numeric, text
yesNutrition/data[at0001]/events[at0002]/data[at0003]/items[at0020]
friction_and_shear
friction_and_shear_code
friction_and_shear_system
friction_and_shear_numeric
friction_and_shear_valueset_id
coded text
text, text, text, numeric, text
yesFriction and shear/data[at0001]/events[at0002]/data[at0003]/items[at0021]
commenttextyesComment/data[at0001]/events[at0002]/data[at0003]/items[at0034]
total_scoreintegeryesTotal score/data[at0001]/events[at0002]/data[at0003]/items[at0022]

Constraints

check ((sensory_perception_code is null and sensory_perception_system is null and sensory_perception_numeric is null and sensory_perception is null) or (sensory_perception_valueset_id is not null and sensory_perception_code is not null and sensory_perception_system is not null and sensory_perception_numeric is not null and sensory_perception is not null))
check ((moisture_code is null and moisture_system is null and moisture_numeric is null and moisture is null) or (moisture_valueset_id is not null and moisture_code is not null and moisture_system is not null and moisture_numeric is not null and moisture is not null))
check ((activity_code is null and activity_system is null and activity_numeric is null and activity is null) or (activity_valueset_id is not null and activity_code is not null and activity_system is not null and activity_numeric is not null and activity is not null))
check ((mobility_code is null and mobility_system is null and mobility_numeric is null and mobility is null) or (mobility_valueset_id is not null and mobility_code is not null and mobility_system is not null and mobility_numeric is not null and mobility is not null))
check ((nutrition_code is null and nutrition_system is null and nutrition_numeric is null and nutrition is null) or (nutrition_valueset_id is not null and nutrition_code is not null and nutrition_system is not null and nutrition_numeric is not null and nutrition is not null))
check ((friction_and_shear_code is null and friction_and_shear_system is null and friction_and_shear_numeric is null and friction_and_shear is null) or (friction_and_shear_valueset_id is not null and friction_and_shear_code is not null and friction_and_shear_system is not null and friction_and_shear_numeric is not null and friction_and_shear is not null))
check (total_score is null or total_score between 6 and 23)

Unique

References

ColumnsTargetOn delete
form_idformcascade
form_id, form_block_idform_blockcascade
sensory_perception_valueset_id, sensory_perception_code, sensory_perception_system, sensory_perception, sensory_perception_numericvalueset_coderestrict
moisture_valueset_id, moisture_code, moisture_system, moisture, moisture_numericvalueset_coderestrict
activity_valueset_id, activity_code, activity_system, activity, activity_numericvalueset_coderestrict
mobility_valueset_id, mobility_code, mobility_system, mobility, mobility_numericvalueset_coderestrict
nutrition_valueset_id, nutrition_code, nutrition_system, nutrition, nutrition_numericvalueset_coderestrict
friction_and_shear_valueset_id, friction_and_shear_code, friction_and_shear_system, friction_and_shear, friction_and_shear_numericvalueset_coderestrict

Indexes

Value sets

Value setCodes
org.openehr::openEHR-EHR-OBSERVATION.braden_scale.v1/activity4
org.openehr::openEHR-EHR-OBSERVATION.braden_scale.v1/friction_and_shear3
org.openehr::openEHR-EHR-OBSERVATION.braden_scale.v1/mobility4
org.openehr::openEHR-EHR-OBSERVATION.braden_scale.v1/moisture4
org.openehr::openEHR-EHR-OBSERVATION.braden_scale.v1/nutrition4
org.openehr::openEHR-EHR-OBSERVATION.braden_scale.v1/sensory_perception4