---
title: "art_cycle_summary"
description: "Summary or persistent information about a single cycle of assisted reproduction treatment."
---

Summary or persistent information about a single cycle of assisted reproduction treatment.

**Purpose.** To record summary or persistent information about a single cycle of assisted reproduction treatment.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-EVALUATION.art_cycle_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. | — |
| `cycle_sequence` | `integer` | yes | Cycle sequence | `/data[at0001]/items[at0002]` |
| `cycle_identifier_value`<br />`cycle_identifier_system` | text, text<br />`text`, `text` | yes | Cycle identifier | `/data[at0001]/items[at0003]` |
| `start_date` | `timestamptz` | yes | Start date | `/data[at0001]/items[at0004]` |
| `description` | `text` | yes | Description | `/data[at0001]/items[at0005]` |
| `intent` | `text` | yes | Intent | `/data[at0001]/items[at0006]` |
| `activities`<br />`activities_code`<br />`activities_system`<br />`activities_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Activities | `/data[at0001]/items[at0012]` |
| `donation_received`<br />`donation_received_code`<br />`donation_received_system`<br />`donation_received_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Donation received | `/data[at0001]/items[at0021]` |
| `hormone_protocol`<br />`hormone_protocol_code`<br />`hormone_protocol_system`<br />`hormone_protocol_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Hormone protocol | `/data[at0001]/items[at0026]` |
| `cumulative_gonadotropin_dose_magnitude`<br />`cumulative_gonadotropin_dose_units` | quantity<br />`numeric`, `text` | yes | Cumulative gonadotropin dose | `/data[at0001]/items[at0072]` |
| `duration_of_gonadotropin_administration` | `interval` | yes | Duration of gonadotropin administration | `/data[at0001]/items[at0073]` |
| `number_of_oocytes_collected` | `integer` | yes | Number of oocytes collected | `/data[at0001]/items[at0042]` |
| `number_of_mature_m2_oocytes_collected` | `integer` | yes | Number of mature (M2) oocytes collected | `/data[at0001]/items[at0043]` |
| `number_of_oocytes_attempted_fertilized` | `integer` | yes | Number of oocytes attempted fertilized | `/data[at0001]/items[at0044]` |
| `number_of_2_pn_zygotes` | `integer` | yes | Number of 2PN zygotes | `/data[at0001]/items[at0071]` |
| `number_of_embryos_transferred` | `integer` | yes | Number of embryos transferred | `/data[at0001]/items[at0045]` |
| `transferred_embryo_quality` | `text` | yes | Transferred embryo quality | `/data[at0001]/items[at0046]` |
| `number_of_embryos_frozen` | `integer` | yes | Number of embryos frozen | `/data[at0001]/items[at0047]` |
| `number_of_oocytes_frozen` | `integer` | yes | Number of oocytes frozen | `/data[at0001]/items[at0048]` |
| `number_of_embryos_thawed` | `integer` | yes | Number of embryos thawed | `/data[at0001]/items[at0049]` |
| `number_of_embryos_surviving_thaw` | `integer` | yes | Number of embryos surviving thaw | `/data[at0001]/items[at0050]` |
| `number_of_embryos_biopsied` | `integer` | yes | Number of embryos biopsied | `/data[at0001]/items[at0051]` |
| `number_of_embryos_surviving_biopsy` | `integer` | yes | Number of embryos surviving biopsy | `/data[at0001]/items[at0052]` |
| `cycle_outcome`<br />`cycle_outcome_code`<br />`cycle_outcome_system`<br />`cycle_outcome_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Cycle outcome | `/data[at0001]/items[at0034]` |
| `pregnancy_test_outcome`<br />`pregnancy_test_outcome_code`<br />`pregnancy_test_outcome_system`<br />`pregnancy_test_outcome_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Pregnancy test outcome | `/data[at0001]/items[at0054]` |
| `number_of_viable_fetuses` | `integer` | yes | Number of viable fetuses | `/data[at0001]/items[at0053]` |
| `comment` | `text` | yes | Comment | `/data[at0001]/items[at0067]` |
| `last_updated` | `timestamptz` | yes | Last updated | `/protocol[at0068]/items[at0069]` |

## Constraints

```sql
check (cycle_identifier_system is null or cycle_identifier_value is not null)
check ((activities_code is null and activities_system is null and activities_valueset_id is null) or (activities is not null and activities_code is not null and activities_system is not null and activities_valueset_id is not null))
check ((donation_received_code is null and donation_received_system is null and donation_received_valueset_id is null and donation_received is null) or (donation_received is not null and donation_received_code is not null and donation_received_system is not null and donation_received_valueset_id is not null))
check ((hormone_protocol_code is null and hormone_protocol_system is null and hormone_protocol_valueset_id is null) or (hormone_protocol is not null and hormone_protocol_code is not null and hormone_protocol_system is not null and hormone_protocol_valueset_id is not null))
check ((cumulative_gonadotropin_dose_magnitude is null and cumulative_gonadotropin_dose_units is null) or (cumulative_gonadotropin_dose_magnitude is not null and cumulative_gonadotropin_dose_units is not null))
check (cumulative_gonadotropin_dose_magnitude is null or (cumulative_gonadotropin_dose_units = '[iU]' and cumulative_gonadotropin_dose_magnitude >= 0) or (cumulative_gonadotropin_dose_units = 'ug'))
check ((cycle_outcome_code is null and cycle_outcome_system is null and cycle_outcome_valueset_id is null) or (cycle_outcome is not null and cycle_outcome_code is not null and cycle_outcome_system is not null and cycle_outcome_valueset_id is not null))
check ((pregnancy_test_outcome_code is null and pregnancy_test_outcome_system is null and pregnancy_test_outcome_valueset_id is null and pregnancy_test_outcome is null) or (pregnancy_test_outcome is not null and pregnancy_test_outcome_code is not null and pregnancy_test_outcome_system is not null and pregnancy_test_outcome_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 |
| `activities_valueset_id, activities_code, activities_system, activities` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `donation_received_valueset_id, donation_received_code, donation_received_system, donation_received` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `hormone_protocol_valueset_id, hormone_protocol_code, hormone_protocol_system, hormone_protocol` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `cycle_outcome_valueset_id, cycle_outcome_code, cycle_outcome_system, cycle_outcome` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `pregnancy_test_outcome_valueset_id, pregnancy_test_outcome_code, pregnancy_test_outcome_system, pregnancy_test_outcome` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

- [`art_cycle_summary_complications`](/docs/tables/art_cycle_summary_complications) via `art_cycle_summary_id`

## Indexes

- `art_cycle_summary_form_id_idx` on `form_id`

## Child tables

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

### `art_cycle_summary_complications`

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

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `art_cycle_summary_id` | `uuid` → [`art_cycle_summary`](/docs/tables/art_cycle_summary) | no | — | — |
| `position` | `integer` | no | Order of this row within its parent, from zero. | — |
| `condition`<br />`condition_code`<br />`condition_system`<br />`condition_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Condition | `/data[at0001]/items[at0057]/items[at0058]` |
| `description` | `text` | yes | Description | `/data[at0001]/items[at0057]/items[at0065]` |
| `date_of_onset` | `timestamptz` | yes | Date of onset | `/data[at0001]/items[at0057]/items[at0066]` |

#### Constraints

```sql
check ((condition_code is null and condition_system is null and condition_valueset_id is null) or (condition is not null and condition_code is not null and condition_system is not null and condition_valueset_id is not null))
```

#### Unique

- `art_cycle_summary_id, position`

#### References

| Columns | Target | On delete |
|---|---|---|
| `art_cycle_summary_id` | [`art_cycle_summary`](/docs/tables/art_cycle_summary) | cascade |
| `condition_valueset_id, condition_code, condition_system, condition` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-EVALUATION.art_cycle_summary.v1/activities` | 8 |
| `org.openehr::openEHR-EHR-EVALUATION.art_cycle_summary.v1/condition` | 6 |
| `org.openehr::openEHR-EHR-EVALUATION.art_cycle_summary.v1/cycle_outcome` | 7 |
| `org.openehr::openEHR-EHR-EVALUATION.art_cycle_summary.v1/donation_received` | 4 |
| `org.openehr::openEHR-EHR-EVALUATION.art_cycle_summary.v1/hormone_protocol` | 7 |
| `org.openehr::openEHR-EHR-EVALUATION.art_cycle_summary.v1/pregnancy_test_outcome` | 2 |

