---
title: "pasi_score"
description: "A quantitative rating scale for measuring the severity of psoriatic lesions based on area coverage and plaque appearance."
---

A quantitative rating scale for measuring the severity of psoriatic lesions based on area coverage and plaque appearance.

**Purpose.** To record the result for each component parameter and the total score for the Psoriasis Area Severity Index (PASI).

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-OBSERVATION.pasi_score.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. | — |
| `head_region_h_erythema_e`<br />`head_region_h_erythema_e_code`<br />`head_region_h_erythema_e_system`<br />`head_region_h_erythema_e_numeric`<br />`head_region_h_erythema_e_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Erythema (E) | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]/items[at0005]` |
| `head_region_h_infiltration_i`<br />`head_region_h_infiltration_i_code`<br />`head_region_h_infiltration_i_system`<br />`head_region_h_infiltration_i_numeric`<br />`head_region_h_infiltration_i_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Infiltration (I) | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]/items[at0011]` |
| `head_region_h_desquamation_d`<br />`head_region_h_desquamation_d_code`<br />`head_region_h_desquamation_d_system`<br />`head_region_h_desquamation_d_numeric`<br />`head_region_h_desquamation_d_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Desquamation (D) | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]/items[at0017]` |
| `head_region_h_body_surface_area_involvement_a`<br />`head_region_h_body_surface_area_involvement_a_code`<br />`head_region_h_body_surface_area_involvement_a_system`<br />`head_region_h_body_surface_area_involvement_a_numeric`<br />`head_region_h_body_surface_area_involvement_a_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Body surface area involvement (A) | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]/items[at0023]` |
| `head_region_h_score_head_region_magnitude`<br />`head_region_h_score_head_region_units` | quantity<br />`numeric`, `text` | yes | Score head region | `/data[at0001]/events[at0002]/data[at0003]/items[at0004]/items[at0038]` |
| `trunk_region_t_score_trunk_region_magnitude`<br />`trunk_region_t_score_trunk_region_units` | quantity<br />`numeric`, `text` | yes | Score trunk region | `/data[at0001]/events[at0002]/data[at0003]/items[at0032]/items[at0039]` |
| `upper_extremities_region_u_score_upper_extremi_5e18bc_magnitude`<br />`upper_extremities_region_u_score_upper_extremi_5e18bc_units` | quantity<br />`numeric`, `text` | yes | Score upper extremities region | `/data[at0001]/events[at0002]/data[at0003]/items[at0033]/items[at0040]` |
| `lower_extremities_region_l_score_lower_extremi_9eefd4_magnitude`<br />`lower_extremities_region_l_score_lower_extremi_9eefd4_units` | quantity<br />`numeric`, `text` | yes | Score lower extremities region | `/data[at0001]/events[at0002]/data[at0003]/items[at0034]/items[at0041]` |
| `total_pasi_score_magnitude`<br />`total_pasi_score_units` | quantity<br />`numeric`, `text` | yes | Total PASI-score | `/data[at0001]/events[at0002]/data[at0003]/items[at0035]` |

## Constraints

```sql
check ((head_region_h_erythema_e_code is null and head_region_h_erythema_e_system is null and head_region_h_erythema_e_numeric is null and head_region_h_erythema_e is null) or (head_region_h_erythema_e_valueset_id is not null and head_region_h_erythema_e_code is not null and head_region_h_erythema_e_system is not null and head_region_h_erythema_e_numeric is not null and head_region_h_erythema_e is not null))
check ((head_region_h_infiltration_i_code is null and head_region_h_infiltration_i_system is null and head_region_h_infiltration_i_numeric is null and head_region_h_infiltration_i is null) or (head_region_h_infiltration_i_valueset_id is not null and head_region_h_infiltration_i_code is not null and head_region_h_infiltration_i_system is not null and head_region_h_infiltration_i_numeric is not null and head_region_h_infiltration_i is not null))
check ((head_region_h_desquamation_d_code is null and head_region_h_desquamation_d_system is null and head_region_h_desquamation_d_numeric is null and head_region_h_desquamation_d is null) or (head_region_h_desquamation_d_valueset_id is not null and head_region_h_desquamation_d_code is not null and head_region_h_desquamation_d_system is not null and head_region_h_desquamation_d_numeric is not null and head_region_h_desquamation_d is not null))
check ((head_region_h_body_surface_area_involvement_a_code is null and head_region_h_body_surface_area_involvement_a_system is null and head_region_h_body_surface_area_involvement_a_numeric is null and head_region_h_body_surface_area_involvement_a is null) or (head_region_h_body_surface_area_involvement_a_valueset_id is not null and head_region_h_body_surface_area_involvement_a_code is not null and head_region_h_body_surface_area_involvement_a_system is not null and head_region_h_body_surface_area_involvement_a_numeric is not null and head_region_h_body_surface_area_involvement_a is not null))
check ((head_region_h_score_head_region_magnitude is null and head_region_h_score_head_region_units is null) or (head_region_h_score_head_region_magnitude is not null and head_region_h_score_head_region_units is not null))
check (head_region_h_score_head_region_magnitude is null or (head_region_h_score_head_region_units = '1' and head_region_h_score_head_region_magnitude >= 0))
check ((trunk_region_t_score_trunk_region_magnitude is null and trunk_region_t_score_trunk_region_units is null) or (trunk_region_t_score_trunk_region_magnitude is not null and trunk_region_t_score_trunk_region_units is not null))
check (trunk_region_t_score_trunk_region_magnitude is null or (trunk_region_t_score_trunk_region_units = '1' and trunk_region_t_score_trunk_region_magnitude >= 0))
check ((upper_extremities_region_u_score_upper_extremi_5e18bc_magnitude is null and upper_extremities_region_u_score_upper_extremi_5e18bc_units is null) or (upper_extremities_region_u_score_upper_extremi_5e18bc_magnitude is not null and upper_extremities_region_u_score_upper_extremi_5e18bc_units is not null))
check (upper_extremities_region_u_score_upper_extremi_5e18bc_magnitude is null or (upper_extremities_region_u_score_upper_extremi_5e18bc_units = '1' and upper_extremities_region_u_score_upper_extremi_5e18bc_magnitude >= 0))
check ((lower_extremities_region_l_score_lower_extremi_9eefd4_magnitude is null and lower_extremities_region_l_score_lower_extremi_9eefd4_units is null) or (lower_extremities_region_l_score_lower_extremi_9eefd4_magnitude is not null and lower_extremities_region_l_score_lower_extremi_9eefd4_units is not null))
check (lower_extremities_region_l_score_lower_extremi_9eefd4_magnitude is null or (lower_extremities_region_l_score_lower_extremi_9eefd4_units = '1' and lower_extremities_region_l_score_lower_extremi_9eefd4_magnitude >= 0))
check ((total_pasi_score_magnitude is null and total_pasi_score_units is null) or (total_pasi_score_magnitude is not null and total_pasi_score_units is not null))
check (total_pasi_score_magnitude is null or (total_pasi_score_units = '1' and total_pasi_score_magnitude >= 0))
```

## 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 |
| `head_region_h_erythema_e_valueset_id, head_region_h_erythema_e_code, head_region_h_erythema_e_system, head_region_h_erythema_e, head_region_h_erythema_e_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `head_region_h_infiltration_i_valueset_id, head_region_h_infiltration_i_code, head_region_h_infiltration_i_system, head_region_h_infiltration_i, head_region_h_infiltration_i_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `head_region_h_desquamation_d_valueset_id, head_region_h_desquamation_d_code, head_region_h_desquamation_d_system, head_region_h_desquamation_d, head_region_h_desquamation_d_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `head_region_h_body_surface_area_involvement_a_valueset_id, head_region_h_body_surface_area_involvement_a_code, head_region_h_body_surface_area_involvement_a_system, head_region_h_body_surface_area_involvement_a, head_region_h_body_surface_area_involvement_a_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Indexes

- `pasi_score_form_id_idx` on `form_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-OBSERVATION.pasi_score.v1/body_surface_area_involvement_a` | 7 |
| `org.openehr::openEHR-EHR-OBSERVATION.pasi_score.v1/desquamation_d` | 5 |
| `org.openehr::openEHR-EHR-OBSERVATION.pasi_score.v1/erythema_e` | 5 |
| `org.openehr::openEHR-EHR-OBSERVATION.pasi_score.v1/infiltration_i` | 5 |