---
title: "crb_65"
description: "An assessment score used within a community or primary care setting to estimate the severity of community-acquired pneumonia."
---

An assessment score used within a community or primary care setting to estimate the severity of community-acquired pneumonia.

**Purpose.** To record the results for each component parameter and their total sum for the CRB-65 score.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.crb_65.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. | — |
| `confusion`<br />`confusion_code`<br />`confusion_system`<br />`confusion_numeric`<br />`confusion_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Confusion | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]` |
| `respiratory_rate`<br />`respiratory_rate_code`<br />`respiratory_rate_system`<br />`respiratory_rate_numeric`<br />`respiratory_rate_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Respiratory rate | `/data[at0001]/events[at0002]/data[at0003]/items[at0007]` |
| `blood_pressure`<br />`blood_pressure_code`<br />`blood_pressure_system`<br />`blood_pressure_numeric`<br />`blood_pressure_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Blood pressure | `/data[at0001]/events[at0002]/data[at0003]/items[at0010]` |
| `age`<br />`age_code`<br />`age_system`<br />`age_numeric`<br />`age_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Age | `/data[at0001]/events[at0002]/data[at0003]/items[at0014]` |
| `total_score` | `integer` | yes | Total score | `/data[at0001]/events[at0002]/data[at0003]/items[at0017]` |
| `grade`<br />`grade_code`<br />`grade_system`<br />`grade_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Grade | `/data[at0001]/events[at0002]/data[at0003]/items[at0018]` |

## Constraints

```sql
check ((confusion_code is null and confusion_system is null and confusion_numeric is null and confusion is null) or (confusion_valueset_id is not null and confusion_code is not null and confusion_system is not null and confusion_numeric is not null and confusion is not null))
check ((respiratory_rate_code is null and respiratory_rate_system is null and respiratory_rate_numeric is null and respiratory_rate is null) or (respiratory_rate_valueset_id is not null and respiratory_rate_code is not null and respiratory_rate_system is not null and respiratory_rate_numeric is not null and respiratory_rate is not null))
check ((blood_pressure_code is null and blood_pressure_system is null and blood_pressure_numeric is null and blood_pressure is null) or (blood_pressure_valueset_id is not null and blood_pressure_code is not null and blood_pressure_system is not null and blood_pressure_numeric is not null and blood_pressure is not null))
check ((age_code is null and age_system is null and age_numeric is null and age is null) or (age_valueset_id is not null and age_code is not null and age_system is not null and age_numeric is not null and age is not null))
check (total_score is null or total_score between 0 and 4)
check ((grade_code is null and grade_system is null and grade_valueset_id is null and grade is null) or (grade is not null and grade_code is not null and grade_system is not null and grade_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 |
| `confusion_valueset_id, confusion_code, confusion_system, confusion, confusion_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `respiratory_rate_valueset_id, respiratory_rate_code, respiratory_rate_system, respiratory_rate, respiratory_rate_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `blood_pressure_valueset_id, blood_pressure_code, blood_pressure_system, blood_pressure, blood_pressure_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `age_valueset_id, age_code, age_system, age, age_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `grade_valueset_id, grade_code, grade_system, grade` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Indexes

- `crb_65_form_id_idx` on `form_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-OBSERVATION.crb_65.v1/age` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.crb_65.v1/blood_pressure` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.crb_65.v1/confusion` | 2 |
| `org.openehr::openEHR-EHR-OBSERVATION.crb_65.v1/grade` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.crb_65.v1/respiratory_rate` | 2 |

