news2

A simple assessment score used to identify clinical deterioration in a patient.

A simple assessment score used to identify clinical deterioration in a patient.

Purpose. To record the value for each component variable for the NEWS2 score, and their total sum.

Source

Columns

Constraints

check ((respiration_rate_code is null and respiration_rate_system is null and respiration_rate_numeric is null and respiration_rate is null) or (respiration_rate_valueset_id is not null and respiration_rate_code is not null and respiration_rate_system is not null and respiration_rate_numeric is not null and respiration_rate is not null))
check ((sp_o2_scale_1_code is null and sp_o2_scale_1_system is null and sp_o2_scale_1_numeric is null and sp_o2_scale_1 is null) or (sp_o2_scale_1_valueset_id is not null and sp_o2_scale_1_code is not null and sp_o2_scale_1_system is not null and sp_o2_scale_1_numeric is not null and sp_o2_scale_1 is not null))
check ((sp_o2_scale_2_code is null and sp_o2_scale_2_system is null and sp_o2_scale_2_numeric is null and sp_o2_scale_2 is null) or (sp_o2_scale_2_valueset_id is not null and sp_o2_scale_2_code is not null and sp_o2_scale_2_system is not null and sp_o2_scale_2_numeric is not null and sp_o2_scale_2 is not null))
check ((air_or_oxygen_code is null and air_or_oxygen_system is null and air_or_oxygen_numeric is null and air_or_oxygen is null) or (air_or_oxygen_valueset_id is not null and air_or_oxygen_code is not null and air_or_oxygen_system is not null and air_or_oxygen_numeric is not null and air_or_oxygen is not null))
check ((systolic_blood_pressure_code is null and systolic_blood_pressure_system is null and systolic_blood_pressure_numeric is null and systolic_blood_pressure is null) or (systolic_blood_pressure_valueset_id is not null and systolic_blood_pressure_code is not null and systolic_blood_pressure_system is not null and systolic_blood_pressure_numeric is not null and systolic_blood_pressure is not null))
check ((pulse_code is null and pulse_system is null and pulse_numeric is null and pulse is null) or (pulse_valueset_id is not null and pulse_code is not null and pulse_system is not null and pulse_numeric is not null and pulse is not null))
check ((consciousness_code is null and consciousness_system is null and consciousness_numeric is null and consciousness is null) or (consciousness_valueset_id is not null and consciousness_code is not null and consciousness_system is not null and consciousness_numeric is not null and consciousness is not null))
check ((temperature_code is null and temperature_system is null and temperature_numeric is null and temperature is null) or (temperature_valueset_id is not null and temperature_code is not null and temperature_system is not null and temperature_numeric is not null and temperature is not null))
check (total_score is null or total_score between 0 and 20)
check ((clinical_risk_category_code is null and clinical_risk_category_system is null and clinical_risk_category_valueset_id is null and clinical_risk_category is null) or (clinical_risk_category is not null and clinical_risk_category_code is not null and clinical_risk_category_system is not null and clinical_risk_category_valueset_id is not null))

Unique

• form_block_id

References

Indexes

• news2_form_id_idx on form_id

Value sets