---
title: "ctcae"
description: "A framework for recording the CTCAE classification for an unfavourable and unintended sign, symptom or disease."
---

A framework for recording the CTCAE classification for an unfavourable and unintended sign, symptom or disease.

**Purpose.** To provide a framework for recording a CTCAE classification.

## Source

| Model | Leg | Role |
|---|---|---|
| `openEHR-EHR-CLUSTER.ctcae.v1` | openEHR | defines this table |

## Columns

| Column | Type | Null | Description | Source |
|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — |
| `category`<br />`category_code`<br />`category_system`<br />`category_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Category | `/items[at0001]` |
| `term`<br />`term_code`<br />`term_system`<br />`term_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Term | `/items[at0002]` |
| `grade_category`<br />`grade_category_code`<br />`grade_category_system`<br />`grade_category_numeric`<br />`grade_category_valueset_id` | coded text<br />`text`, `text`, `text`, `numeric`, `text` | yes | Grade category | `/items[at0003]` |
| `grade_description`<br />`grade_description_code`<br />`grade_description_system`<br />`grade_description_valueset_id` | coded text<br />`text`, `text`, `text`, `text` | yes | Grade description | `/items[at0020]` |
| `ctcae_version` | `text` | yes | CTCAE version | `/items[at0009]` |

## Constraints

```sql
check ((category_code is null and category_system is null and category_valueset_id is null) or (category is not null and category_code is not null and category_system is not null and category_valueset_id is not null))
check ((term_code is null and term_system is null and term_valueset_id is null) or (term is not null and term_code is not null and term_system is not null and term_valueset_id is not null))
check ((grade_category_code is null and grade_category_system is null and grade_category_numeric is null and grade_category is null) or (grade_category_valueset_id is not null and grade_category_code is not null and grade_category_system is not null and grade_category_numeric is not null and grade_category is not null))
check ((grade_description_code is null and grade_description_system is null and grade_description_valueset_id is null) or (grade_description is not null and grade_description_code is not null and grade_description_system is not null and grade_description_valueset_id is not null))
```

## References

| Columns | Target | On delete |
|---|---|---|
| `category_valueset_id, category_code, category_system, category` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `term_valueset_id, term_code, term_system, term` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `grade_category_valueset_id, grade_category_code, grade_category_system, grade_category, grade_category_numeric` | [`valueset_code`](/docs/tables/valueset_code) | restrict |
| `grade_description_valueset_id, grade_description_code, grade_description_system, grade_description` | [`valueset_code`](/docs/tables/valueset_code) | restrict |

## Referenced by

- [`adverse_reaction_event_reaction_details`](/docs/tables/adverse_reaction_event_reaction_details) via `ctcae_id`

## Value sets

| Value set | Codes |
|---|---|
| `org.openehr::openEHR-EHR-CLUSTER.ctcae.v1/grade_category` | 6 |