Schema reference / Tables / view MDX source
absence
Statement that specified health information is not available for inclusion in the health record or extract at the time of recording.
Statement that specified health information is not available for inclusion in the health record or extract at the time of recording.
Purpose. To enable recording or exchange of an explicit statement by a clinician that specified health information is not available for inclusion in the health record or record extract at the time of recording.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-EVALUATION.absence.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. | — |
absence_statement | text | yes | Absence statement | /data[at0001]/items[at0002] |
reason_for_absencereason_for_absence_codereason_for_absence_systemreason_for_absence_valueset_id | coded texttext, text, text, text | yes | Reason for absence | /data[at0001]/items[at0005] |
last_updated | timestamptz | yes | Last updated | /protocol[at0003]/items[at0004] |
Constraints
check ((reason_for_absence_code is null and reason_for_absence_system is null and reason_for_absence_valueset_id is null) or (reason_for_absence is not null and reason_for_absence_code is not null and reason_for_absence_system is not null and reason_for_absence_valueset_id is not null))Unique
form_block_id
References
| Columns | Target | On delete |
|---|---|---|
form_id | form | cascade |
form_id, form_block_id | form_block | cascade |
reason_for_absence_valueset_id, reason_for_absence_code, reason_for_absence_system, reason_for_absence | valueset_code | restrict |
Indexes
absence_form_id_idxonform_id