Schema reference / Tables / view MDX source
reason_for_encounter
The reason for initiation of any healthcare encounter or contact by the individual who is the subject of care.
The reason for initiation of any healthcare encounter or contact by the individual who is the subject of care.
Purpose. To record the reason, or reasons, for initiation of any type of healthcare encounter or contact by the individual who is the subject of care.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-EVALUATION.reason_for_encounter.v1 | 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. | — |
contact_typecontact_type_codecontact_type_systemcontact_type_valueset_id | coded texttext, text, text, text | yes | Contact type | /data[at0001]/items[at0002] |
presenting_problempresenting_problem_codepresenting_problem_systempresenting_problem_valueset_id | coded texttext, text, text, text | yes | Presenting problem | /data[at0001]/items[at0004] |
Constraints
check ((contact_type_code is null and contact_type_system is null and contact_type_valueset_id is null) or (contact_type is not null and contact_type_code is not null and contact_type_system is not null and contact_type_valueset_id is not null))
check ((presenting_problem_code is null and presenting_problem_system is null and presenting_problem_valueset_id is null) or (presenting_problem is not null and presenting_problem_code is not null and presenting_problem_system is not null and presenting_problem_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 |
contact_type_valueset_id, contact_type_code, contact_type_system, contact_type | valueset_code | restrict |
presenting_problem_valueset_id, presenting_problem_code, presenting_problem_system, presenting_problem | valueset_code | restrict |
Indexes
reason_for_encounter_form_id_idxonform_id