---
title: "apgar"
description: "A tool to assess the clinical status of the newborn infant immediately after birth and their response to resuscitation."
---

A tool to assess the clinical status of the newborn infant immediately after birth and their response to resuscitation.

**Purpose.** To record the results for each component parameter and their total sum for the Apgar score.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.apgar.v2` | 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. | — |
| `event_type` | `text` | yes | null represents any_event | — |
| `respiratory_effort`<br />`respiratory_effort_code`<br />`respiratory_effort_system`<br />`respiratory_effort_numeric`<br />`respiratory_effort_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Respiratory effort | `/data[at0002]/events[at0003]/data[at0001]/items[at0009]` |
| `heart_rate`<br />`heart_rate_code`<br />`heart_rate_system`<br />`heart_rate_numeric`<br />`heart_rate_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Heart rate | `/data[at0002]/events[at0003]/data[at0001]/items[at0005]` |
| `muscle_tone`<br />`muscle_tone_code`<br />`muscle_tone_system`<br />`muscle_tone_numeric`<br />`muscle_tone_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Muscle tone | `/data[at0002]/events[at0003]/data[at0001]/items[at0013]` |
| `reflex_irritability`<br />`reflex_irritability_code`<br />`reflex_irritability_system`<br />`reflex_irritability_numeric`<br />`reflex_irritability_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Reflex irritability | `/data[at0002]/events[at0003]/data[at0001]/items[at0017]` |
| `skin_colour`<br />`skin_colour_code`<br />`skin_colour_system`<br />`skin_colour_numeric`<br />`skin_colour_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Skin colour | `/data[at0002]/events[at0003]/data[at0001]/items[at0021]` |
| `total` | `integer` | yes | Total | `/data[at0002]/events[at0003]/data[at0001]/items[at0025]` |

## Constraints

```sql
check ((respiratory_effort_code is null and respiratory_effort_system is null and respiratory_effort_numeric is null and respiratory_effort is null) or (respiratory_effort_valueset_id is not null and respiratory_effort_code is not null and respiratory_effort_system is not null and respiratory_effort_numeric is not null and respiratory_effort is not null))
check ((heart_rate_code is null and heart_rate_system is null and heart_rate_numeric is null and heart_rate is null) or (heart_rate_valueset_id is not null and heart_rate_code is not null and heart_rate_system is not null and heart_rate_numeric is not null and heart_rate is not null))
check ((muscle_tone_code is null and muscle_tone_system is null and muscle_tone_numeric is null and muscle_tone is null) or (muscle_tone_valueset_id is not null and muscle_tone_code is not null and muscle_tone_system is not null and muscle_tone_numeric is not null and muscle_tone is not null))
check ((reflex_irritability_code is null and reflex_irritability_system is null and reflex_irritability_numeric is null and reflex_irritability is null) or (reflex_irritability_valueset_id is not null and reflex_irritability_code is not null and reflex_irritability_system is not null and reflex_irritability_numeric is not null and reflex_irritability is not null))
check ((skin_colour_code is null and skin_colour_system is null and skin_colour_numeric is null and skin_colour is null) or (skin_colour_valueset_id is not null and skin_colour_code is not null and skin_colour_system is not null and skin_colour_numeric is not null and skin_colour is not null))
check (total is null or total between 0 and 10)
```

## 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 |
| `respiratory_effort_valueset_id, respiratory_effort_code, respiratory_effort_system, respiratory_effort, respiratory_effort_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `heart_rate_valueset_id, heart_rate_code, heart_rate_system, heart_rate, heart_rate_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `muscle_tone_valueset_id, muscle_tone_code, muscle_tone_system, muscle_tone, muscle_tone_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `reflex_irritability_valueset_id, reflex_irritability_code, reflex_irritability_system, reflex_irritability, reflex_irritability_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `skin_colour_valueset_id, skin_colour_code, skin_colour_system, skin_colour, skin_colour_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Indexes

- `apgar_form_id_idx` on `form_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-OBSERVATION.apgar.v2/heart_rate` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.apgar.v2/muscle_tone` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.apgar.v2/reflex_irritability` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.apgar.v2/respiratory_effort` | 3 |
| `org.openehr::openEHR-EHR-OBSERVATION.apgar.v2/skin_colour` | 3 |

