Schema reference / Tables / view MDX source

nutritional_risk_screening

Screening for malnutrition using the tool NRS 2002.

Purpose. NRS is a tool used for screening the patients nutritional status.

Source

Model	Leg	Role
`openEHR-EHR-OBSERVATION.nutritional_risk_screening.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.	—
`initial_screening_is_the_body_mass_index_lt__8fd3b9` `initial_screening_is_the_body_mass_index_lt__8fd3b9_code` `initial_screening_is_the_body_mass_index_lt__8fd3b9_system` `initial_screening_is_the_body_mass_index_lt__8fd3b9_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Is the body mass index <20.5 kg/m²?	`/data[at0001]/events[at0002]/data[at0003]/items[at0031]/items[at0004]`
`initial_screening_has_the_patient_lost_weigh_b421bd` `initial_screening_has_the_patient_lost_weigh_b421bd_code` `initial_screening_has_the_patient_lost_weigh_b421bd_system` `initial_screening_has_the_patient_lost_weigh_b421bd_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Has the patient lost weight in the previous 3 months?	`/data[at0001]/events[at0002]/data[at0003]/items[at0031]/items[at0005]`
`initial_screening_was_nutritional_intake_red_f0dc4d` `initial_screening_was_nutritional_intake_red_f0dc4d_code` `initial_screening_was_nutritional_intake_red_f0dc4d_system` `initial_screening_was_nutritional_intake_red_f0dc4d_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Was nutritional intake reduced in the previous week?	`/data[at0001]/events[at0002]/data[at0003]/items[at0031]/items[at0006]`
`initial_screening_is_the_patient_very_ill_e__d82461` `initial_screening_is_the_patient_very_ill_e__d82461_code` `initial_screening_is_the_patient_very_ill_e__d82461_system` `initial_screening_is_the_patient_very_ill_e__d82461_valueset_id`	coded text `text`, `text`, `text`, `text`	yes	Is the patient very ill? (e.g. in intensive care)?	`/data[at0001]/events[at0002]/data[at0003]/items[at0031]/items[at0007]`
`main_screening_nutritional_status` `main_screening_nutritional_status_code` `main_screening_nutritional_status_system` `main_screening_nutritional_status_numeric` `main_screening_nutritional_status_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Nutritional status	`/data[at0001]/events[at0002]/data[at0003]/items[at0032]/items[at0016]`
`main_screening_illness_severity` `main_screening_illness_severity_code` `main_screening_illness_severity_system` `main_screening_illness_severity_numeric` `main_screening_illness_severity_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Illness severity	`/data[at0001]/events[at0002]/data[at0003]/items[at0032]/items[at0017]`
`main_screening_is_the_patients_age_gte_70` `main_screening_is_the_patients_age_gte_70_code` `main_screening_is_the_patients_age_gte_70_system` `main_screening_is_the_patients_age_gte_70_numeric` `main_screening_is_the_patients_age_gte_70_valueset_id`	coded text `text`, `text`, `text`, `numeric`, `text`	yes	Is the patients age ≥ 70?	`/data[at0001]/events[at0002]/data[at0003]/items[at0032]/items[at0027]`
`main_screening_total_score_age_adjusted`	`integer`	yes	Total score (age adjusted)	`/data[at0001]/events[at0002]/data[at0003]/items[at0032]/items[at0030]`
`comment`	`text`	yes	Comment	`/data[at0001]/events[at0002]/data[at0003]/items[at0041]`

Constraints

check ((initial_screening_is_the_body_mass_index_lt__8fd3b9_code is null and initial_screening_is_the_body_mass_index_lt__8fd3b9_system is null and initial_screening_is_the_body_mass_index_lt__8fd3b9_valueset_id is null and initial_screening_is_the_body_mass_index_lt__8fd3b9 is null) or (initial_screening_is_the_body_mass_index_lt__8fd3b9 is not null and initial_screening_is_the_body_mass_index_lt__8fd3b9_code is not null and initial_screening_is_the_body_mass_index_lt__8fd3b9_system is not null and initial_screening_is_the_body_mass_index_lt__8fd3b9_valueset_id is not null))
check ((initial_screening_has_the_patient_lost_weigh_b421bd_code is null and initial_screening_has_the_patient_lost_weigh_b421bd_system is null and initial_screening_has_the_patient_lost_weigh_b421bd_valueset_id is null and initial_screening_has_the_patient_lost_weigh_b421bd is null) or (initial_screening_has_the_patient_lost_weigh_b421bd is not null and initial_screening_has_the_patient_lost_weigh_b421bd_code is not null and initial_screening_has_the_patient_lost_weigh_b421bd_system is not null and initial_screening_has_the_patient_lost_weigh_b421bd_valueset_id is not null))
check ((initial_screening_was_nutritional_intake_red_f0dc4d_code is null and initial_screening_was_nutritional_intake_red_f0dc4d_system is null and initial_screening_was_nutritional_intake_red_f0dc4d_valueset_id is null and initial_screening_was_nutritional_intake_red_f0dc4d is null) or (initial_screening_was_nutritional_intake_red_f0dc4d is not null and initial_screening_was_nutritional_intake_red_f0dc4d_code is not null and initial_screening_was_nutritional_intake_red_f0dc4d_system is not null and initial_screening_was_nutritional_intake_red_f0dc4d_valueset_id is not null))
check ((initial_screening_is_the_patient_very_ill_e__d82461_code is null and initial_screening_is_the_patient_very_ill_e__d82461_system is null and initial_screening_is_the_patient_very_ill_e__d82461_valueset_id is null and initial_screening_is_the_patient_very_ill_e__d82461 is null) or (initial_screening_is_the_patient_very_ill_e__d82461 is not null and initial_screening_is_the_patient_very_ill_e__d82461_code is not null and initial_screening_is_the_patient_very_ill_e__d82461_system is not null and initial_screening_is_the_patient_very_ill_e__d82461_valueset_id is not null))
check ((main_screening_nutritional_status_code is null and main_screening_nutritional_status_system is null and main_screening_nutritional_status_numeric is null and main_screening_nutritional_status is null) or (main_screening_nutritional_status_valueset_id is not null and main_screening_nutritional_status_code is not null and main_screening_nutritional_status_system is not null and main_screening_nutritional_status_numeric is not null and main_screening_nutritional_status is not null))
check ((main_screening_illness_severity_code is null and main_screening_illness_severity_system is null and main_screening_illness_severity_numeric is null and main_screening_illness_severity is null) or (main_screening_illness_severity_valueset_id is not null and main_screening_illness_severity_code is not null and main_screening_illness_severity_system is not null and main_screening_illness_severity_numeric is not null and main_screening_illness_severity is not null))
check ((main_screening_is_the_patients_age_gte_70_code is null and main_screening_is_the_patients_age_gte_70_system is null and main_screening_is_the_patients_age_gte_70_numeric is null and main_screening_is_the_patients_age_gte_70 is null) or (main_screening_is_the_patients_age_gte_70_valueset_id is not null and main_screening_is_the_patients_age_gte_70_code is not null and main_screening_is_the_patients_age_gte_70_system is not null and main_screening_is_the_patients_age_gte_70_numeric is not null and main_screening_is_the_patients_age_gte_70 is not null))

Unique

form_block_id

References

Columns	Target	On delete
`form_id`	`form`	cascade
`form_id, form_block_id`	`form_block`	cascade
`initial_screening_is_the_body_mass_index_lt__8fd3b9_valueset_id, initial_screening_is_the_body_mass_index_lt__8fd3b9_code, initial_screening_is_the_body_mass_index_lt__8fd3b9_system, initial_screening_is_the_body_mass_index_lt__8fd3b9`	`valueset_code`	restrict
`initial_screening_has_the_patient_lost_weigh_b421bd_valueset_id, initial_screening_has_the_patient_lost_weigh_b421bd_code, initial_screening_has_the_patient_lost_weigh_b421bd_system, initial_screening_has_the_patient_lost_weigh_b421bd`	`valueset_code`	restrict
`initial_screening_was_nutritional_intake_red_f0dc4d_valueset_id, initial_screening_was_nutritional_intake_red_f0dc4d_code, initial_screening_was_nutritional_intake_red_f0dc4d_system, initial_screening_was_nutritional_intake_red_f0dc4d`	`valueset_code`	restrict
`initial_screening_is_the_patient_very_ill_e__d82461_valueset_id, initial_screening_is_the_patient_very_ill_e__d82461_code, initial_screening_is_the_patient_very_ill_e__d82461_system, initial_screening_is_the_patient_very_ill_e__d82461`	`valueset_code`	restrict
`main_screening_nutritional_status_valueset_id, main_screening_nutritional_status_code, main_screening_nutritional_status_system, main_screening_nutritional_status, main_screening_nutritional_status_numeric`	`valueset_code`	restrict
`main_screening_illness_severity_valueset_id, main_screening_illness_severity_code, main_screening_illness_severity_system, main_screening_illness_severity, main_screening_illness_severity_numeric`	`valueset_code`	restrict
`main_screening_is_the_patients_age_gte_70_valueset_id, main_screening_is_the_patients_age_gte_70_code, main_screening_is_the_patients_age_gte_70_system, main_screening_is_the_patients_age_gte_70, main_screening_is_the_patients_age_gte_70_numeric`	`valueset_code`	restrict

Indexes

nutritional_risk_screening_form_id_idx on form_id

Value sets

Value set	Codes
`org.openehr::openEHR-EHR-OBSERVATION.nutritional_risk_screening.v1/has_the_patient_lost_weight_in_the_previous_3_months`	2
`org.openehr::openEHR-EHR-OBSERVATION.nutritional_risk_screening.v1/illness_severity`	4
`org.openehr::openEHR-EHR-OBSERVATION.nutritional_risk_screening.v1/is_the_body_mass_index_lt_20_5_kg_m2`	2
`org.openehr::openEHR-EHR-OBSERVATION.nutritional_risk_screening.v1/is_the_patient_very_ill_e_g_in_intensive_care`	2
`org.openehr::openEHR-EHR-OBSERVATION.nutritional_risk_screening.v1/is_the_patients_age_gte_70`	2
`org.openehr::openEHR-EHR-OBSERVATION.nutritional_risk_screening.v1/nutritional_status`	4
`org.openehr::openEHR-EHR-OBSERVATION.nutritional_risk_screening.v1/was_nutritional_intake_reduced_in_the_previous_week`	2