Schema reference / Tables / view MDX source
ecog
A scale used by clinicians to assess the functional performance status of a patient with a diagnosis of cancer.
A scale used by clinicians to assess the functional performance status of a patient with a diagnosis of cancer.
Purpose. To record the measurement of the functional performance status of a patient with a diagnosis of cancer.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-OBSERVATION.ecog.v2 | openEHR | defines this table |
Columns
| Column | Type | Null | Description | Source |
|---|---|---|---|---|
id | uuid primary key | no | Primary key. | — |
form_id | uuid → 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. | — |
ecog_performance_statusecog_performance_status_codeecog_performance_status_systemecog_performance_status_numericecog_performance_status_valueset_id | coded texttext, text, text, numeric, text | yes | ECOG performance status | /data[at0001]/events[at0002]/data[at0003]/items[at0004] |
Constraints
check ((ecog_performance_status_code is null and ecog_performance_status_system is null and ecog_performance_status_numeric is null and ecog_performance_status is null) or (ecog_performance_status_valueset_id is not null and ecog_performance_status_code is not null and ecog_performance_status_system is not null and ecog_performance_status_numeric is not null and ecog_performance_status is not null))Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
ecog_performance_status_valueset_id, ecog_performance_status_code, ecog_performance_status_system, ecog_performance_status, ecog_performance_status_numeric | valueset_code | restrict |
Indexes
ecog_form_id_idxonform_id
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-OBSERVATION.ecog.v2/ecog_performance_status | 6 |