Schema reference / Tables / view MDX source

malnutrition_screening_tool

An assessment tool used to identify if an individual is at risk of malnutrition.

Purpose. To record the results for each component parameter and their total sum for the MST score.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.malnutrition_screening_tool.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.	—
`have_you_lost_weight_recently_without_trying` `have_you_lost_weight_recently_without_trying_code` `have_you_lost_weight_recently_without_trying_system` `have_you_lost_weight_recently_without_trying_numeric` `have_you_lost_weight_recently_without_trying_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Have you lost weight recently without trying?	`/data[at0001]/events[at0002]/data[at0003]/items[at0005]`
`have_you_been_eating_poorly_because_of_a_dec_d306dd` `have_you_been_eating_poorly_because_of_a_dec_d306dd_code` `have_you_been_eating_poorly_because_of_a_dec_d306dd_system` `have_you_been_eating_poorly_because_of_a_dec_d306dd_numeric` `have_you_been_eating_poorly_because_of_a_dec_d306dd_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Have you been eating poorly because of a decreased appetite?	`/data[at0001]/events[at0002]/data[at0003]/items[at0016]`
`mst_score`	`integer`	yes	MST score	`/data[at0001]/events[at0002]/data[at0003]/items[at0019]`

Constraints

check ((have_you_lost_weight_recently_without_trying_code is null and have_you_lost_weight_recently_without_trying_system is null and have_you_lost_weight_recently_without_trying_numeric is null and have_you_lost_weight_recently_without_trying is null) or (have_you_lost_weight_recently_without_trying_valueset_id is not null and have_you_lost_weight_recently_without_trying_code is not null and have_you_lost_weight_recently_without_trying_system is not null and have_you_lost_weight_recently_without_trying_numeric is not null and have_you_lost_weight_recently_without_trying is not null))
check ((have_you_been_eating_poorly_because_of_a_dec_d306dd_code is null and have_you_been_eating_poorly_because_of_a_dec_d306dd_system is null and have_you_been_eating_poorly_because_of_a_dec_d306dd_numeric is null and have_you_been_eating_poorly_because_of_a_dec_d306dd is null) or (have_you_been_eating_poorly_because_of_a_dec_d306dd_valueset_id is not null and have_you_been_eating_poorly_because_of_a_dec_d306dd_code is not null and have_you_been_eating_poorly_because_of_a_dec_d306dd_system is not null and have_you_been_eating_poorly_because_of_a_dec_d306dd_numeric is not null and have_you_been_eating_poorly_because_of_a_dec_d306dd is not null))
check (mst_score is null or mst_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
`have_you_lost_weight_recently_without_trying_valueset_id, have_you_lost_weight_recently_without_trying_code, have_you_lost_weight_recently_without_trying_system, have_you_lost_weight_recently_without_trying, have_you_lost_weight_recently_without_trying_numeric`	`valueset_code`	restrict
`have_you_been_eating_poorly_because_of_a_dec_d306dd_valueset_id, have_you_been_eating_poorly_because_of_a_dec_d306dd_code, have_you_been_eating_poorly_because_of_a_dec_d306dd_system, have_you_been_eating_poorly_because_of_a_dec_d306dd, have_you_been_eating_poorly_because_of_a_dec_d306dd_numeric`	`valueset_code`	restrict

Indexes

malnutrition_screening_tool_form_id_idx on form_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.malnutrition_screening_tool.v1/have_you_been_eating_poorly_because_of_a_decreased_appetite`	2
`org.openehr::openEHR-EHR-OBSERVATION.malnutrition_screening_tool.v1/have_you_lost_weight_recently_without_trying`	7