---
title: "intervention_summary"
description: "A summary about a therapeutic activity intended to prevent, diagnose, treat, or manage health conditions, support mental or physical well-being, or address social and environmenta…"
---

A summary about a therapeutic activity intended to prevent, diagnose, treat, or manage health conditions, support mental or physical well-being, or address social and environmental factors that influence health outcomes.

**Purpose.** To record a summary of a commenced or completed therapeutic intervention.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-EVALUATION.intervention_summary.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. | — |
| `intervention_name`<br />`intervention_name_code`<br />`intervention_name_system`<br />`intervention_name_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Intervention name | `/data[at0001]/items[at0003]` |
| `intervention_category` | `text` | yes | Intervention category | `/data[at0001]/items[at0059]` |
| `intervention_type`<br />`intervention_type_code`<br />`intervention_type_system`<br />`intervention_type_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Intervention type | `/data[at0001]/items[at0058]` |
| `description` | `text` | yes | Description | `/data[at0001]/items[at0028]` |
| `clinical_protocol` | `text` | yes | Clinical protocol | `/data[at0001]/items[at0054]` |
| `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 | `/data[at0001]/items[at0033]` |
| `intent`<br />`intent_code`<br />`intent_system`<br />`intent_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Intent | `/data[at0001]/items[at0034]` |
| `impact`<br />`impact_code`<br />`impact_system`<br />`impact_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Impact | `/data[at0001]/items[at0062]` |
| `therapeutic_role` | `text` | yes | Therapeutic role | `/data[at0001]/items[at0055]` |
| `therapeutic_sequence` | `text` | yes | Therapeutic sequence | `/data[at0001]/items[at0051]` |
| `start_date` | `timestamptz` | yes | Start date | `/data[at0001]/items[at0032]` |
| `stop_date` | `timestamptz` | yes | Stop date | `/data[at0001]/items[at0004]` |
| `delivery_outcome`<br />`delivery_outcome_code`<br />`delivery_outcome_system`<br />`delivery_outcome_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Delivery outcome | `/data[at0001]/items[at0005]` |
| `reason_for_delivery_outcome`<br />`reason_for_delivery_outcome_code`<br />`reason_for_delivery_outcome_system`<br />`reason_for_delivery_outcome_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Reason for delivery outcome | `/data[at0001]/items[at0007]` |
| `therapeutic_outcome`<br />`therapeutic_outcome_code`<br />`therapeutic_outcome_system`<br />`therapeutic_outcome_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Therapeutic outcome | `/data[at0001]/items[at0008]` |
| `reason_for_therapeutic_outcome` | `text` | yes | Reason for therapeutic outcome | `/data[at0001]/items[at0027]` |
| `date_of_last_interaction` | `timestamptz` | yes | Date of last interaction | `/data[at0001]/items[at0010]` |
| `comment` | `text` | yes | Comment | `/data[at0001]/items[at0016]` |
| `last_updated` | `timestamptz` | yes | Last updated | `/protocol[at0002]/items[at0018]` |
| `intervention_id_value`<br />`intervention_id_system` | text, text<br />`text`, `text` | yes | Intervention ID | `/protocol[at0002]/items[at0057]` |

## Constraints

```sql
check ((intervention_name_code is null and intervention_name_system is null and intervention_name_valueset_id is null) or (intervention_name is not null and intervention_name_code is not null and intervention_name_system is not null and intervention_name_valueset_id is not null))
check ((intervention_type_code is null and intervention_type_system is null and intervention_type_valueset_id is null) or (intervention_type is not null and intervention_type_code is not null and intervention_type_system is not null and intervention_type_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 ((intent_code is null and intent_system is null and intent_valueset_id is null) or (intent is not null and intent_code is not null and intent_system is not null and intent_valueset_id is not null))
check ((impact_code is null and impact_system is null and impact_valueset_id is null) or (impact is not null and impact_code is not null and impact_system is not null and impact_valueset_id is not null))
check ((delivery_outcome_code is null and delivery_outcome_system is null and delivery_outcome_valueset_id is null) or (delivery_outcome is not null and delivery_outcome_code is not null and delivery_outcome_system is not null and delivery_outcome_valueset_id is not null))
check ((reason_for_delivery_outcome_code is null and reason_for_delivery_outcome_system is null and reason_for_delivery_outcome_valueset_id is null) or (reason_for_delivery_outcome is not null and reason_for_delivery_outcome_code is not null and reason_for_delivery_outcome_system is not null and reason_for_delivery_outcome_valueset_id is not null))
check ((therapeutic_outcome_code is null and therapeutic_outcome_system is null and therapeutic_outcome_valueset_id is null) or (therapeutic_outcome is not null and therapeutic_outcome_code is not null and therapeutic_outcome_system is not null and therapeutic_outcome_valueset_id is not null))
check (intervention_id_system is null or intervention_id_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 |
| `intervention_name_valueset_id, intervention_name_code, intervention_name_system, intervention_name` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `intervention_type_valueset_id, intervention_type_code, intervention_type_system, intervention_type` | [`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 |
| `intent_valueset_id, intent_code, intent_system, intent` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `impact_valueset_id, impact_code, impact_system, impact` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `delivery_outcome_valueset_id, delivery_outcome_code, delivery_outcome_system, delivery_outcome` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `reason_for_delivery_outcome_valueset_id, reason_for_delivery_outcome_code, reason_for_delivery_outcome_system, reason_for_delivery_outcome` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `therapeutic_outcome_valueset_id, therapeutic_outcome_code, therapeutic_outcome_system, therapeutic_outcome` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Indexes

- `intervention_summary_form_id_idx` on `form_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-EVALUATION.intervention_summary.v1/delivery_outcome` | 4 |

