Schema reference / Tables / view MDX source
ctcae
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. | — |
categorycategory_codecategory_systemcategory_valueset_id | coded texttext, text, text, text | yes | Category | /items[at0001] |
termterm_codeterm_systemterm_valueset_id | coded texttext, text, text, text | yes | Term | /items[at0002] |
grade_categorygrade_category_codegrade_category_systemgrade_category_numericgrade_category_valueset_id | coded texttext, text, text, numeric, text | yes | Grade category | /items[at0003] |
grade_descriptiongrade_description_codegrade_description_systemgrade_description_valueset_id | coded texttext, text, text, text | yes | Grade description | /items[at0020] |
ctcae_version | text | yes | CTCAE version | /items[at0009] |
Constraints
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 | restrict |
term_valueset_id, term_code, term_system, term | valueset_code | restrict |
grade_category_valueset_id, grade_category_code, grade_category_system, grade_category, grade_category_numeric | valueset_code | restrict |
grade_description_valueset_id, grade_description_code, grade_description_system, grade_description | valueset_code | restrict |
Referenced by
adverse_reaction_event_reaction_detailsviactcae_id
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-CLUSTER.ctcae.v1/grade_category | 6 |