---
title: "health_risk"
description: "Assessment of the potential and likelihood of future adverse health effects as determined by identified risk factors."
---

Assessment of the potential and likelihood of future adverse health effects as determined by identified risk factors.

**Purpose.** To record known risk factors for an identified disease, condition, or other potentially adverse health issue, and/or an evaluation of the likelihood of the individual experiencing it in the future.&#xD; &#xD; This archetype has been deliberately left open and broad in scope.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-EVALUATION.health_risk.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. | — |
| `health_risk`<br />`health_risk_code`<br />`health_risk_system`<br />`health_risk_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Health risk | `/data[at0001]/items[at0002]` |
| `risk_assessment`<br />`risk_assessment_code`<br />`risk_assessment_system`<br />`risk_assessment_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Risk assessment | `/data[at0001]/items[at0003]` |
| `assessment_type`<br />`assessment_type_code`<br />`assessment_type_system`<br />`assessment_type_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Assessment type | `/data[at0001]/items[at0020]` |
| `time_period` | `interval` | yes | Time period | `/data[at0001]/items[at0023]` |
| `rationale` | `text` | yes | Rationale | `/data[at0001]/items[at0004]` |
| `comment` | `text` | yes | Comment | `/data[at0001]/items[at0015]` |
| `last_updated` | `timestamptz` | yes | Last updated | `/protocol[at0010]/items[at0024]` |
| `assessment_method` | `text` | yes | Assessment method | `/protocol[at0010]/items[at0025]` |

## Constraints

```sql
check ((health_risk_code is null and health_risk_system is null and health_risk_valueset_id is null) or (health_risk is not null and health_risk_code is not null and health_risk_system is not null and health_risk_valueset_id is not null))
check ((risk_assessment_code is null and risk_assessment_system is null and risk_assessment_valueset_id is null) or (risk_assessment is not null and risk_assessment_code is not null and risk_assessment_system is not null and risk_assessment_valueset_id is not null))
check ((assessment_type_code is null and assessment_type_system is null and assessment_type_valueset_id is null and assessment_type is null) or (assessment_type is not null and assessment_type_code is not null and assessment_type_system is not null and assessment_type_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 |
| `health_risk_valueset_id, health_risk_code, health_risk_system, health_risk` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `risk_assessment_valueset_id, risk_assessment_code, risk_assessment_system, risk_assessment` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `assessment_type_valueset_id, assessment_type_code, assessment_type_system, assessment_type` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

- [`health_risk_risk_factors`](/docs/tables/health_risk_risk_factors) via `health_risk_id`

## Indexes

- `health_risk_form_id_idx` on `form_id`

## Child tables

2 tables hang off `health_risk`, one row per repetition.

### `health_risk_risk_factors`

Child table — one row per repetition, deleted with its parent.

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `health_risk_id` | `uuid` → [`health_risk`](/docs/tables/health_risk) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `risk_factor`<br />`risk_factor_code`<br />`risk_factor_system`<br />`risk_factor_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Risk factor | `/data[at0001]/items[at0016]/items[at0013]` |
| `presence`<br />`presence_code`<br />`presence_system`<br />`presence_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Presence | `/data[at0001]/items[at0016]/items[at0017]` |
| `description` | `text` | yes | Description | `/data[at0001]/items[at0016]/items[at0014]` |
| `date_identified` | `timestamptz` | yes | Date identified | `/data[at0001]/items[at0016]/items[at0029]` |
| `mitigated` | `boolean` | yes | Mitigated | `/data[at0001]/items[at0016]/items[at0028]` |
| `link_to_evidence` | `text` | yes | Link to evidence | `/data[at0001]/items[at0016]/items[at0012]` |
| `comment` | `text` | yes | Comment | `/data[at0001]/items[at0016]/items[at0030]` |

#### Constraints

```sql
check ((risk_factor_code is null and risk_factor_system is null and risk_factor_valueset_id is null) or (risk_factor is not null and risk_factor_code is not null and risk_factor_system is not null and risk_factor_valueset_id is not null))
check ((presence_code is null and presence_system is null and presence_valueset_id is null and presence is null) or (presence is not null and presence_code is not null and presence_system is not null and presence_valueset_id is not null))
```

#### Unique

- `health_risk_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `health_risk_id` | [`health_risk`](/docs/tables/health_risk) | cascade |
| `risk_factor_valueset_id, risk_factor_code, risk_factor_system, risk_factor` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `presence_valueset_id, presence_code, presence_system, presence` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

### Referenced by

- [`health_risk_risk_factors_detail`](/docs/tables/health_risk_risk_factors_detail) via `health_risk_risk_factors_id`

### `health_risk_risk_factors_detail`

Child table — one row per repetition, deleted with its parent.

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `health_risk_risk_factors_id` | `uuid` → [`health_risk_risk_factors`](/docs/tables/health_risk_risk_factors) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `family_prevalence_id` | `uuid` | no | Detail | `/data[at0001]/items[at0016]/items[at0027]` |

#### Unique

- `health_risk_risk_factors_id, position`
- `health_risk_risk_factors_id, family_prevalence_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `health_risk_risk_factors_id` | [`health_risk_risk_factors`](/docs/tables/health_risk_risk_factors) | cascade |
| `family_prevalence_id` | [`family_prevalence`](/docs/tables/family_prevalence) | no action |

#### Indexes

- `health_risk_risk_factors_detail_family_prevalence_id_idx` on `family_prevalence_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-EVALUATION.health_risk.v1/assessment_type` | 2 |
| `org.openehr::openEHR-EHR-EVALUATION.health_risk.v1/presence` | 3 |

