---
title: "advance_intervention_decisions"
description: "Anticipatory decisions about the overall intent of care and possible interventions (including treatments, activities, and diagnostic or therapeutic procedures), asserted by a clin…"
---

Anticipatory decisions about the overall intent of care and possible interventions (including treatments, activities, and diagnostic or therapeutic procedures), asserted by a clinician.

**Purpose.** To record anticipatory decisions about the overall intent of care and possible interventions, usually asserted by a clinician.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-EVALUATION.advance_intervention_decisions.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. | — |
| `intent_of_care`<br />`intent_of_care_code`<br />`intent_of_care_system`<br />`intent_of_care_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Intent of care | `/data[at0001]/items[at0002]` |
| `rationale` | `text` | yes | Rationale | `/data[at0001]/items[at0056]` |
| `decisions_description` | `text` | yes | Decisions description | `/data[at0001]/items[at0008]` |
| `cpr_decision`<br />`cpr_decision_code`<br />`cpr_decision_system`<br />`cpr_decision_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | CPR decision | `/data[at0001]/items[at0009]` |
| `patient_awareness` | `text` | yes | Patient awareness | `/data[at0001]/items[at0042]` |
| `carer_awareness` | `text` | yes | Carer awareness | `/data[at0001]/items[at0043]` |
| `overall_comment` | `text` | yes | Overall comment | `/data[at0001]/items[at0044]` |
| `last_updated` | `timestamptz` | yes | Last updated | `/protocol[at0045]/items[at0046]` |
| `valid_period_start` | `timestamptz` | yes | Valid period start | `/protocol[at0045]/items[at0047]` |
| `valid_period_end` | `timestamptz` | yes | Valid period end | `/protocol[at0045]/items[at0048]` |
| `review_due` | `timestamptz` | yes | Review due | `/protocol[at0045]/items[at0049]` |
| `mandate` | `text` | yes | Mandate | `/protocol[at0045]/items[at0050]` |
| `document_location_location` | `text` | yes | Location | `/protocol[at0045]/items[at0052]/items[at0053]` |

## Constraints

```sql
check ((intent_of_care_code is null and intent_of_care_system is null and intent_of_care_valueset_id is null) or (intent_of_care is not null and intent_of_care_code is not null and intent_of_care_system is not null and intent_of_care_valueset_id is not null))
check ((cpr_decision_code is null and cpr_decision_system is null and cpr_decision_valueset_id is null) or (cpr_decision is not null and cpr_decision_code is not null and cpr_decision_system is not null and cpr_decision_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 |
| `intent_of_care_valueset_id, intent_of_care_code, intent_of_care_system, intent_of_care` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `cpr_decision_valueset_id, cpr_decision_code, cpr_decision_system, cpr_decision` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

- [`advance_intervention_decisions_per_intervention`](/docs/tables/advance_intervention_decisions_per_intervention) via `advance_intervention_decisions_id`

## Indexes

- `advance_intervention_decisions_form_id_idx` on `form_id`

## Child tables

1 table hang off `advance_intervention_decisions`, one row per repetition.

### `advance_intervention_decisions_per_intervention`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `advance_intervention_decisions_id` | `uuid` → [`advance_intervention_decisions`](/docs/tables/advance_intervention_decisions) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `intervention`<br />`intervention_code`<br />`intervention_system`<br />`intervention_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Intervention | `/data[at0001]/items[at0014]/items[at0015]` |
| `decision`<br />`decision_code`<br />`decision_system`<br />`decision_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Decision | `/data[at0001]/items[at0014]/items[at0034]` |
| `precondition` | `text` | yes | Precondition | `/data[at0001]/items[at0014]/items[at0039]` |
| `comment` | `text` | yes | Comment | `/data[at0001]/items[at0014]/items[at0040]` |

#### Constraints

```sql
check ((intervention_code is null and intervention_system is null and intervention_valueset_id is null) or (intervention is not null and intervention_code is not null and intervention_system is not null and intervention_valueset_id is not null))
check ((decision_code is null and decision_system is null and decision_valueset_id is null and decision is null) or (decision is not null and decision_code is not null and decision_system is not null and decision_valueset_id is not null))
```

#### Unique

- `advance_intervention_decisions_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `advance_intervention_decisions_id` | [`advance_intervention_decisions`](/docs/tables/advance_intervention_decisions) | cascade |
| `intervention_valueset_id, intervention_code, intervention_system, intervention` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `decision_valueset_id, decision_code, decision_system, decision` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-EVALUATION.advance_intervention_decisions.v1/cpr_decision` | 4 |
| `org.openehr::openEHR-EHR-EVALUATION.advance_intervention_decisions.v1/decision` | 4 |
| `org.openehr::openEHR-EHR-EVALUATION.advance_intervention_decisions.v1/intent_of_care` | 5 |
| `org.openehr::openEHR-EHR-EVALUATION.advance_intervention_decisions.v1/intervention` | 18 |