---
title: "health_education"
description: "Communication to improve health literacy and life skills."
---

Communication to improve health literacy and life skills.

**Purpose.** To record details about communication to improve health literacy and life skills.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-ACTION.health_education.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. | — |
| `topic_name`<br />`topic_name_code`<br />`topic_name_system`<br />`topic_name_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Topic name | `/description[at0001]/items[at0002]` |
| `description` | `text` | yes | Description | `/description[at0001]/items[at0003]` |
| `clinical_indication`<br />`clinical_indication_code`<br />`clinical_indication_system`<br />`clinical_indication_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Clinical indication | `/description[at0001]/items[at0035]` |
| `method` | `text` | yes | Method | `/description[at0001]/items[at0004]` |
| `session_number` | `integer` | yes | Session Number | `/description[at0001]/items[at0020]` |
| `reason` | `text` | yes | Reason | `/description[at0001]/items[at0010]` |
| `outcome`<br />`outcome_code`<br />`outcome_system`<br />`outcome_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Outcome | `/description[at0001]/items[at0019]` |
| `scheduled_date_time` | `timestamptz` | yes | Scheduled date/ time | `/description[at0001]/items[at0026]` |
| `comment` | `text` | yes | Comment | `/description[at0001]/items[at0027]` |
| `requestor_order_identifier_value`<br />`requestor_order_identifier_system` | text, text<br />`text`, `text` | yes | Requestor order identifier | `/protocol[at0021]/items[at0030]` |
| `receiver_order_identifier_value`<br />`receiver_order_identifier_system` | text, text<br />`text`, `text` | yes | Receiver order identifier | `/protocol[at0021]/items[at0031]` |

## Constraints

```sql
check ((topic_name_code is null and topic_name_system is null and topic_name_valueset_id is null) or (topic_name is not null and topic_name_code is not null and topic_name_system is not null and topic_name_valueset_id is not null))
check ((clinical_indication_code is null and clinical_indication_system is null and clinical_indication_valueset_id is null) or (clinical_indication is not null and clinical_indication_code is not null and clinical_indication_system is not null and clinical_indication_valueset_id is not null))
check ((outcome_code is null and outcome_system is null and outcome_valueset_id is null) or (outcome is not null and outcome_code is not null and outcome_system is not null and outcome_valueset_id is not null))
check (requestor_order_identifier_system is null or requestor_order_identifier_value is not null)
check (receiver_order_identifier_system is null or receiver_order_identifier_value 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 |
| `topic_name_valueset_id, topic_name_code, topic_name_system, topic_name` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `clinical_indication_valueset_id, clinical_indication_code, clinical_indication_system, clinical_indication` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `outcome_valueset_id, outcome_code, outcome_system, outcome` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Indexes

- `health_education_form_id_idx` on `form_id`

