---
title: "imaging_exam_result"
description: "The result of an imaging examination performed on an individual, using radiological techniques."
---

The result of an imaging examination performed on an individual, using radiological techniques.

**Purpose.** To record the findings on imaging examination of a specified body structure or region and their interpretation, using radiological techniques.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.imaging_exam_result.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. | — |
| `study_name`<br />`study_name_code`<br />`study_name_system`<br />`study_name_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Study name | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]` |
| `modality`<br />`modality_code`<br />`modality_system`<br />`modality_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Modality | `/data[at0001]/events[at0002]/data[at0003]/items[at0091]` |
| `target_body_site`<br />`target_body_site_code`<br />`target_body_site_system`<br />`target_body_site_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Target body site | `/data[at0001]/events[at0002]/data[at0003]/items[at0055]` |
| `study_date` | `timestamptz` | yes | Study date | `/data[at0001]/events[at0002]/data[at0003]/items[at0070]` |
| `overall_result_status`<br />`overall_result_status_code`<br />`overall_result_status_system`<br />`overall_result_status_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Overall result status | `/data[at0001]/events[at0002]/data[at0003]/items[at0072]` |
| `status_timestamp` | `timestamptz` | yes | Status timestamp | `/data[at0001]/events[at0002]/data[at0003]/items[at0071]` |
| `clinical_indication` | `text` | yes | Clinical indication | `/data[at0001]/events[at0002]/data[at0003]/items[at0061]` |
| `clinical_summary` | `text` | yes | Clinical summary | `/data[at0001]/events[at0002]/data[at0003]/items[at0014]` |
| `imaging_findings` | `text` | yes | Imaging findings | `/data[at0001]/events[at0002]/data[at0003]/items[at0008]` |
| `comparison_findings` | `text` | yes | Comparison findings | `/data[at0001]/events[at0002]/data[at0003]/items[at0056]` |
| `imaging_quality`<br />`imaging_quality_code`<br />`imaging_quality_system`<br />`imaging_quality_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Imaging quality | `/data[at0001]/events[at0002]/data[at0003]/items[at0063]` |
| `imaging_quality_description` | `text` | yes | Imaging quality description | `/data[at0001]/events[at0002]/data[at0003]/items[at0057]` |
| `overall_impression` | `text` | yes | Overall impression | `/data[at0001]/events[at0002]/data[at0003]/items[at0021]` |
| `imaging_differential_diagnosis`<br />`imaging_differential_diagnosis_code`<br />`imaging_differential_diagnosis_system`<br />`imaging_differential_diagnosis_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Imaging differential diagnosis | `/data[at0001]/events[at0002]/data[at0003]/items[at0058]` |
| `imaging_diagnosis`<br />`imaging_diagnosis_code`<br />`imaging_diagnosis_system`<br />`imaging_diagnosis_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Imaging diagnosis | `/data[at0001]/events[at0002]/data[at0003]/items[at0020]` |
| `recommendation` | `text` | yes | Recommendation | `/data[at0001]/events[at0002]/data[at0003]/items[at0059]` |
| `comment` | `text` | yes | Comment | `/data[at0001]/events[at0002]/data[at0003]/items[at0023]` |
| `confounding_factors` | `text` | yes | Confounding factors | `/data[at0001]/events[at0002]/state[at0047]/items[at0048]` |
| `position`<br />`position_code`<br />`position_system`<br />`position_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Position | `/data[at0001]/events[at0002]/state[at0047]/items[at0108]` |
| `study_instance_identifier_value`<br />`study_instance_identifier_system` | text, text<br />`text`, `text` | yes | Study instance identifier | `/protocol[at0025]/items[at0092]` |
| `study_description` | `text` | yes | Study description | `/protocol[at0025]/items[at0105]` |
| `report_identifier_value`<br />`report_identifier_system` | text, text<br />`text`, `text` | yes | Report identifier | `/protocol[at0025]/items[at0104]` |
| `study_status`<br />`study_status_code`<br />`study_status_system`<br />`study_status_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Study status | `/protocol[at0025]/items[at0099]` |
| `study_end_point` | `text` | yes | Study end point | `/protocol[at0025]/items[at0098]` |
| `image_details` | `text` | yes | Image details | `/protocol[at0025]/items[at0106]` |
| `technique`<br />`technique_code`<br />`technique_system`<br />`technique_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Technique | `/protocol[at0025]/items[at0087]` |
| `technique_summary` | `text` | yes | Technique summary | `/protocol[at0025]/items[at0049]` |
| `procedure` | `text` | yes | Procedure | `/protocol[at0025]/items[at0088]` |
| `procedure_summary` | `text` | yes | Procedure summary | `/protocol[at0025]/items[at0062]` |
| `distribution_list_organization` | `uuid` | yes | — | — |
| `distribution_list_person` | `uuid` | yes | — | — |

## Constraints

```sql
check ((study_name_code is null and study_name_system is null and study_name_valueset_id is null) or (study_name is not null and study_name_code is not null and study_name_system is not null and study_name_valueset_id is not null))
check ((modality_code is null and modality_system is null and modality_valueset_id is null) or (modality is not null and modality_code is not null and modality_system is not null and modality_valueset_id is not null))
check ((target_body_site_code is null and target_body_site_system is null and target_body_site_valueset_id is null) or (target_body_site is not null and target_body_site_code is not null and target_body_site_system is not null and target_body_site_valueset_id is not null))
check ((overall_result_status_code is null and overall_result_status_system is null and overall_result_status_valueset_id is null) or (overall_result_status is not null and overall_result_status_code is not null and overall_result_status_system is not null and overall_result_status_valueset_id is not null))
check ((imaging_quality_code is null and imaging_quality_system is null and imaging_quality_valueset_id is null) or (imaging_quality is not null and imaging_quality_code is not null and imaging_quality_system is not null and imaging_quality_valueset_id is not null))
check ((imaging_differential_diagnosis_code is null and imaging_differential_diagnosis_system is null and imaging_differential_diagnosis_valueset_id is null) or (imaging_differential_diagnosis is not null and imaging_differential_diagnosis_code is not null and imaging_differential_diagnosis_system is not null and imaging_differential_diagnosis_valueset_id is not null))
check ((imaging_diagnosis_code is null and imaging_diagnosis_system is null and imaging_diagnosis_valueset_id is null) or (imaging_diagnosis is not null and imaging_diagnosis_code is not null and imaging_diagnosis_system is not null and imaging_diagnosis_valueset_id is not null))
check ((position_code is null and position_system is null and position_valueset_id is null) or (position is not null and position_code is not null and position_system is not null and position_valueset_id is not null))
check (study_instance_identifier_system is null or study_instance_identifier_value is not null)
check (report_identifier_system is null or report_identifier_value is not null)
check ((study_status_code is null and study_status_system is null and study_status_valueset_id is null) or (study_status is not null and study_status_code is not null and study_status_system is not null and study_status_valueset_id is not null))
check ((technique_code is null and technique_system is null and technique_valueset_id is null) or (technique is not null and technique_code is not null and technique_system is not null and technique_valueset_id is not null))
check (num_nonnulls(distribution_list_organization, distribution_list_person) <= 1)
```

## 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 |
| `study_name_valueset_id, study_name_code, study_name_system, study_name` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `modality_valueset_id, modality_code, modality_system, modality` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `target_body_site_valueset_id, target_body_site_code, target_body_site_system, target_body_site` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `overall_result_status_valueset_id, overall_result_status_code, overall_result_status_system, overall_result_status` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `imaging_quality_valueset_id, imaging_quality_code, imaging_quality_system, imaging_quality` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `imaging_differential_diagnosis_valueset_id, imaging_differential_diagnosis_code, imaging_differential_diagnosis_system, imaging_differential_diagnosis` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `imaging_diagnosis_valueset_id, imaging_diagnosis_code, imaging_diagnosis_system, imaging_diagnosis` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `position_valueset_id, position_code, position_system, position` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `study_status_valueset_id, study_status_code, study_status_system, study_status` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `technique_valueset_id, technique_code, technique_system, technique` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `distribution_list_organization` | [`organization`](/docs/tables/organization) | no action |
| `distribution_list_person` | [`person`](/docs/tables/person) | no action |

## Referenced by

- [`imaging_exam_result_structured_target_body_site`](/docs/tables/imaging_exam_result_structured_target_body_site) via `imaging_exam_result_id`
- [`imaging_exam_result_structured_imaging_findings`](/docs/tables/imaging_exam_result_structured_imaging_findings) via `imaging_exam_result_id`
- [`imaging_exam_result_report_representation`](/docs/tables/imaging_exam_result_report_representation) via `imaging_exam_result_id`
- [`imaging_exam_result_stabilising_appliance`](/docs/tables/imaging_exam_result_stabilising_appliance) via `imaging_exam_result_id`
- [`imaging_exam_result_imaging_service`](/docs/tables/imaging_exam_result_imaging_service) via `imaging_exam_result_id`
- [`imaging_exam_result_device`](/docs/tables/imaging_exam_result_device) via `imaging_exam_result_id`
- [`imaging_exam_result_comparison_study_details`](/docs/tables/imaging_exam_result_comparison_study_details) via `imaging_exam_result_id`
- [`imaging_exam_result_examination_request_details`](/docs/tables/imaging_exam_result_examination_request_details) via `imaging_exam_result_id`

## Indexes

- `imaging_exam_result_form_id_idx` on `form_id`
- `imaging_exam_result_distribution_list_organization_idx` on `distribution_list_organization`
- `imaging_exam_result_distribution_list_person_idx` on `distribution_list_person`

## Child tables

9 tables hang off `imaging_exam_result`, one row per repetition.

### `imaging_exam_result_structured_target_body_site`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_result_id` | `uuid` → [`imaging_exam_result`](/docs/tables/imaging_exam_result) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `anatomical_location_id` | `uuid` | no | Structured target body site | `/data[at0001]/events[at0002]/data[at0003]/items[at0006]` |

#### Unique

- `imaging_exam_result_id, position`
- `imaging_exam_result_id, anatomical_location_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_result_id` | [`imaging_exam_result`](/docs/tables/imaging_exam_result) | cascade |
| `anatomical_location_id` | [`anatomical_location`](/docs/tables/anatomical_location) | no action |

#### Indexes

- `imaging_exam_result_structured_target_body_site_anatomic_8f6f59` on `anatomical_location_id`

### `imaging_exam_result_structured_imaging_findings`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_result_id` | `uuid` → [`imaging_exam_result`](/docs/tables/imaging_exam_result) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `imaging_exam_id` | `uuid` | yes | — | — |
| `imaging_exam_cervix_id` | `uuid` | yes | — | — |
| `imaging_exam_fallopian_tube_id` | `uuid` | yes | — | — |
| `imaging_exam_foetus_id` | `uuid` | yes | — | — |
| `imaging_exam_gestational_sac_id` | `uuid` | yes | — | — |
| `imaging_exam_hip_joint_id` | `uuid` | yes | — | — |
| `imaging_exam_ovary_id` | `uuid` | yes | — | — |
| `imaging_exam_rectouterine_pouch_id` | `uuid` | yes | — | — |

#### Constraints

```sql
check (num_nonnulls(imaging_exam_id, imaging_exam_cervix_id, imaging_exam_fallopian_tube_id, imaging_exam_foetus_id, imaging_exam_gestational_sac_id, imaging_exam_hip_joint_id, imaging_exam_ovary_id, imaging_exam_rectouterine_pouch_id) = 1)
```

#### Unique

- `imaging_exam_result_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_result_id` | [`imaging_exam_result`](/docs/tables/imaging_exam_result) | cascade |
| `imaging_exam_id` | [`imaging_exam`](/docs/tables/imaging_exam) | no action |
| `imaging_exam_cervix_id` | [`imaging_exam_cervix`](/docs/tables/imaging_exam_cervix) | no action |
| `imaging_exam_fallopian_tube_id` | [`imaging_exam_fallopian_tube`](/docs/tables/imaging_exam_fallopian_tube) | no action |
| `imaging_exam_foetus_id` | [`imaging_exam_foetus`](/docs/tables/imaging_exam_foetus) | no action |
| `imaging_exam_gestational_sac_id` | [`imaging_exam_gestational_sac`](/docs/tables/imaging_exam_gestational_sac) | no action |
| `imaging_exam_hip_joint_id` | [`imaging_exam_hip_joint`](/docs/tables/imaging_exam_hip_joint) | no action |
| `imaging_exam_ovary_id` | [`imaging_exam_ovary`](/docs/tables/imaging_exam_ovary) | no action |
| `imaging_exam_rectouterine_pouch_id` | [`imaging_exam_rectouterine_pouch`](/docs/tables/imaging_exam_rectouterine_pouch) | no action |

#### Indexes

- `imaging_exam_result_structured_imaging_findings_imaging__13aaab` on `imaging_exam_id`
- `imaging_exam_result_structured_imaging_findings_imaging__d4c509` on `imaging_exam_cervix_id`
- `imaging_exam_result_structured_imaging_findings_imaging__19f0ab` on `imaging_exam_fallopian_tube_id`
- `imaging_exam_result_structured_imaging_findings_imaging__82f9b5` on `imaging_exam_foetus_id`
- `imaging_exam_result_structured_imaging_findings_imaging__8e77c2` on `imaging_exam_gestational_sac_id`
- `imaging_exam_result_structured_imaging_findings_imaging__362201` on `imaging_exam_hip_joint_id`
- `imaging_exam_result_structured_imaging_findings_imaging__250b35` on `imaging_exam_ovary_id`
- `imaging_exam_result_structured_imaging_findings_imaging__d3c126` on `imaging_exam_rectouterine_pouch_id`

### `imaging_exam_result_report_representation`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_result_id` | `uuid` → [`imaging_exam_result`](/docs/tables/imaging_exam_result) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `attachment_id` | `uuid` | no | Report representation | `/data[at0001]/events[at0002]/data[at0003]/items[at0045]` |

#### Unique

- `imaging_exam_result_id, position`
- `imaging_exam_result_id, attachment_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_result_id` | [`imaging_exam_result`](/docs/tables/imaging_exam_result) | cascade |
| `attachment_id` | [`attachment`](/docs/tables/attachment) | restrict |

#### Indexes

- `imaging_exam_result_report_representation_attachment_id_idx` on `attachment_id`

### `imaging_exam_result_stabilising_appliance`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_result_id` | `uuid` → [`imaging_exam_result`](/docs/tables/imaging_exam_result) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `device_id` | `uuid` | no | Stabilising appliance | `/data[at0001]/events[at0002]/state[at0047]/items[at0107]` |

#### Unique

- `imaging_exam_result_id, position`
- `imaging_exam_result_id, device_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_result_id` | [`imaging_exam_result`](/docs/tables/imaging_exam_result) | cascade |
| `device_id` | [`device`](/docs/tables/device) | no action |

#### Indexes

- `imaging_exam_result_stabilising_appliance_device_id_idx` on `device_id`

### `imaging_exam_result_imaging_service`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_result_id` | `uuid` → [`imaging_exam_result`](/docs/tables/imaging_exam_result) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `organization_id` | `uuid` | no | Imaging service | `/protocol[at0025]/items[at0026]` |

#### Unique

- `imaging_exam_result_id, position`
- `imaging_exam_result_id, organization_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_result_id` | [`imaging_exam_result`](/docs/tables/imaging_exam_result) | cascade |
| `organization_id` | [`organization`](/docs/tables/organization) | no action |

#### Indexes

- `imaging_exam_result_imaging_service_organization_id_idx` on `organization_id`

### `imaging_exam_result_device`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_result_id` | `uuid` → [`imaging_exam_result`](/docs/tables/imaging_exam_result) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `device_id` | `uuid` | no | Device | `/protocol[at0025]/items[at0069]` |

#### Unique

- `imaging_exam_result_id, position`
- `imaging_exam_result_id, device_id`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_result_id` | [`imaging_exam_result`](/docs/tables/imaging_exam_result) | cascade |
| `device_id` | [`device`](/docs/tables/device) | no action |

#### Indexes

- `imaging_exam_result_device_device_id_idx` on `device_id`

### `imaging_exam_result_comparison_study_details`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_result_id` | `uuid` → [`imaging_exam_result`](/docs/tables/imaging_exam_result) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `study_name` | `text` | yes | Study name | `/protocol[at0025]/items[at0093]/items[at0094]` |
| `study_identifier_value`<br />`study_identifier_system` | text, text<br />`text`, `text` | yes | Study identifier | `/protocol[at0025]/items[at0093]/items[at0095]` |
| `study_date` | `timestamptz` | yes | Study date | `/protocol[at0025]/items[at0093]/items[at0096]` |
| `study_end_point` | `text` | yes | Study end point | `/protocol[at0025]/items[at0093]/items[at0097]` |

#### Constraints

```sql
check (study_identifier_system is null or study_identifier_value is not null)
```

#### Unique

- `imaging_exam_result_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_result_id` | [`imaging_exam_result`](/docs/tables/imaging_exam_result) | cascade |

### `imaging_exam_result_examination_request_details`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_result_id` | `uuid` → [`imaging_exam_result`](/docs/tables/imaging_exam_result) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `receiver_order_identifier_value`<br />`receiver_order_identifier_system` | text, text<br />`text`, `text` | yes | Receiver order identifier | `/protocol[at0025]/items[at0027]/items[at0031]` |
| `requester_order_identifier_value`<br />`requester_order_identifier_system` | text, text<br />`text`, `text` | yes | Requester order identifier | `/protocol[at0025]/items[at0027]/items[at0028]` |
| `examination_requested_name` | `text` | yes | Examination requested name | `/protocol[at0025]/items[at0027]/items[at0029]` |

#### Constraints

```sql
check (receiver_order_identifier_system is null or receiver_order_identifier_value is not null)
check (requester_order_identifier_system is null or requester_order_identifier_value is not null)
```

#### Unique

- `imaging_exam_result_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_result_id` | [`imaging_exam_result`](/docs/tables/imaging_exam_result) | cascade |

### Referenced by

- [`imaging_exam_result_examination_request_details_requester`](/docs/tables/imaging_exam_result_examination_request_details_requester) via `imaging_exam_result_examination_request_details_id`

### `imaging_exam_result_examination_request_details_requester`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `imaging_exam_result_examination_request_details_id` | `uuid` → [`imaging_exam_result_examination_request_details`](/docs/tables/imaging_exam_result_examination_request_details) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `organization_id` | `uuid` | yes | — | — |
| `person_id` | `uuid` | yes | — | — |

#### Constraints

```sql
check (num_nonnulls(organization_id, person_id) = 1)
```

#### Unique

- `imaging_exam_result_examination_request_details_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `imaging_exam_result_examination_request_details_id` | [`imaging_exam_result_examination_request_details`](/docs/tables/imaging_exam_result_examination_request_details) | cascade |
| `organization_id` | [`organization`](/docs/tables/organization) | no action |
| `person_id` | [`person`](/docs/tables/person) | no action |

#### Indexes

- `imaging_exam_result_examination_request_details_requeste_bee8fb` on `organization_id`
- `imaging_exam_result_examination_request_details_requeste_5a8303` on `person_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-OBSERVATION.imaging_exam_result.v1/overall_result_status` | 9 |
| `org.openehr::openEHR-EHR-OBSERVATION.imaging_exam_result.v1/study_status` | 4 |