---
title: "news2"
description: "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

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.news2.v1` | openEHR | defines this table |

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `form_id` | `uuid` → [`form`](/docs/tables/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. | — |
| `respiration_rate`<br />`respiration_rate_code`<br />`respiration_rate_system`<br />`respiration_rate_numeric`<br />`respiration_rate_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Respiration rate | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]` |
| `sp_o2_scale_1`<br />`sp_o2_scale_1_code`<br />`sp_o2_scale_1_system`<br />`sp_o2_scale_1_numeric`<br />`sp_o2_scale_1_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | SpO₂ Scale 1 | `/data[at0001]/events[at0002]/data[at0003]/items[at0029]` |
| `sp_o2_scale_2`<br />`sp_o2_scale_2_code`<br />`sp_o2_scale_2_system`<br />`sp_o2_scale_2_numeric`<br />`sp_o2_scale_2_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | SpO₂ Scale 2 | `/data[at0001]/events[at0002]/data[at0003]/items[at0047]` |
| `air_or_oxygen`<br />`air_or_oxygen_code`<br />`air_or_oxygen_system`<br />`air_or_oxygen_numeric`<br />`air_or_oxygen_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Air or oxygen? | `/data[at0001]/events[at0002]/data[at0003]/items[at0034]` |
| `systolic_blood_pressure`<br />`systolic_blood_pressure_code`<br />`systolic_blood_pressure_system`<br />`systolic_blood_pressure_numeric`<br />`systolic_blood_pressure_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Systolic blood pressure | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]` |
| `pulse`<br />`pulse_code`<br />`pulse_system`<br />`pulse_numeric`<br />`pulse_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Pulse | `/data[at0001]/events[at0002]/data[at0003]/items[at0005]` |
| `consciousness`<br />`consciousness_code`<br />`consciousness_system`<br />`consciousness_numeric`<br />`consciousness_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Consciousness | `/data[at0001]/events[at0002]/data[at0003]/items[at0008]` |
| `temperature`<br />`temperature_code`<br />`temperature_system`<br />`temperature_numeric`<br />`temperature_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Temperature | `/data[at0001]/events[at0002]/data[at0003]/items[at0007]` |
| `total_score` | `integer` | yes | Total score | `/data[at0001]/events[at0002]/data[at0003]/items[at0028]` |
| `clinical_risk_category`<br />`clinical_risk_category_code`<br />`clinical_risk_category_system`<br />`clinical_risk_category_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Clinical risk category | `/data[at0001]/events[at0002]/data[at0003]/items[at0056]` |

## Constraints

```sql
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

| Columns | Target | On delete |
|---|---|---|
| `form_id` | [`form`](/docs/tables/form) | cascade |
| `form_id, form_block_id` | [`form_block`](/docs/tables/form_block) | cascade |
| `respiration_rate_valueset_id, respiration_rate_code, respiration_rate_system, respiration_rate, respiration_rate_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `sp_o2_scale_1_valueset_id, sp_o2_scale_1_code, sp_o2_scale_1_system, sp_o2_scale_1, sp_o2_scale_1_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `sp_o2_scale_2_valueset_id, sp_o2_scale_2_code, sp_o2_scale_2_system, sp_o2_scale_2, sp_o2_scale_2_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `air_or_oxygen_valueset_id, air_or_oxygen_code, air_or_oxygen_system, air_or_oxygen, air_or_oxygen_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `systolic_blood_pressure_valueset_id, systolic_blood_pressure_code, systolic_blood_pressure_system, systolic_blood_pressure, systolic_blood_pressure_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `pulse_valueset_id, pulse_code, pulse_system, pulse, pulse_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `consciousness_valueset_id, consciousness_code, consciousness_system, consciousness, consciousness_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `temperature_valueset_id, temperature_code, temperature_system, temperature, temperature_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `clinical_risk_category_valueset_id, clinical_risk_category_code, clinical_risk_category_system, clinical_risk_category` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Indexes

- `news2_form_id_idx` on `form_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-OBSERVATION.news2.v1/air_or_oxygen` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.news2.v1/clinical_risk_category` | 4 |
| `org.openehr::openEHR-EHR-OBSERVATION.news2.v1/consciousness` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.news2.v1/pulse` | 6 |
| `org.openehr::openEHR-EHR-OBSERVATION.news2.v1/respiration_rate` | 5 |
| `org.openehr::openEHR-EHR-OBSERVATION.news2.v1/sp_o2_scale_1` | 4 |
| `org.openehr::openEHR-EHR-OBSERVATION.news2.v1/sp_o2_scale_2` | 7 |
| `org.openehr::openEHR-EHR-OBSERVATION.news2.v1/systolic_blood_pressure` | 5 |
| `org.openehr::openEHR-EHR-OBSERVATION.news2.v1/temperature` | 5 |