Schema reference / Tables / view MDX source
advance_intervention_decisions
Anticipatory decisions about the overall intent of care and possible interventions (including treatments, activities, and diagnostic or therapeutic procedures), asserted by a clin…
Anticipatory decisions about the overall intent of care and possible interventions (including treatments, activities, and diagnostic or therapeutic procedures), asserted by a clinician.
Purpose. To record anticipatory decisions about the overall intent of care and possible interventions, usually asserted by a clinician.
Source
| Model | Leg | Role |
|---|---|---|
openEHR-EHR-EVALUATION.advance_intervention_decisions.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. | — |
intent_of_careintent_of_care_codeintent_of_care_systemintent_of_care_valueset_id | coded texttext, text, text, text | yes | Intent of care | /data[at0001]/items[at0002] |
rationale | text | yes | Rationale | /data[at0001]/items[at0056] |
decisions_description | text | yes | Decisions description | /data[at0001]/items[at0008] |
cpr_decisioncpr_decision_codecpr_decision_systemcpr_decision_valueset_id | coded texttext, text, text, text | yes | CPR decision | /data[at0001]/items[at0009] |
patient_awareness | text | yes | Patient awareness | /data[at0001]/items[at0042] |
carer_awareness | text | yes | Carer awareness | /data[at0001]/items[at0043] |
overall_comment | text | yes | Overall comment | /data[at0001]/items[at0044] |
last_updated | timestamptz | yes | Last updated | /protocol[at0045]/items[at0046] |
valid_period_start | timestamptz | yes | Valid period start | /protocol[at0045]/items[at0047] |
valid_period_end | timestamptz | yes | Valid period end | /protocol[at0045]/items[at0048] |
review_due | timestamptz | yes | Review due | /protocol[at0045]/items[at0049] |
mandate | text | yes | Mandate | /protocol[at0045]/items[at0050] |
document_location_location | text | yes | Location | /protocol[at0045]/items[at0052]/items[at0053] |
Constraints
check ((intent_of_care_code is null and intent_of_care_system is null and intent_of_care_valueset_id is null) or (intent_of_care is not null and intent_of_care_code is not null and intent_of_care_system is not null and intent_of_care_valueset_id is not null))
check ((cpr_decision_code is null and cpr_decision_system is null and cpr_decision_valueset_id is null) or (cpr_decision is not null and cpr_decision_code is not null and cpr_decision_system is not null and cpr_decision_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 |
intent_of_care_valueset_id, intent_of_care_code, intent_of_care_system, intent_of_care | valueset_code | restrict |
cpr_decision_valueset_id, cpr_decision_code, cpr_decision_system, cpr_decision | valueset_code | restrict |
Referenced by
advance_intervention_decisions_per_interventionviaadvance_intervention_decisions_id
Indexes
advance_intervention_decisions_form_id_idxonform_id
Child tables
1 table hang off advance_intervention_decisions, one row per repetition.
advance_intervention_decisions_per_intervention
Child table — one row per repetition, deleted with its parent.
| Column | Type | Null | Description | Source |
|---|---|---|---|---|
id | uuid primary key | no | Primary key. | — |
advance_intervention_decisions_id | uuid → advance_intervention_decisions | no | — | — |
position | integer | no | Order of this row within its parent, from zero. | — |
interventionintervention_codeintervention_systemintervention_valueset_id | coded texttext, text, text, text | yes | Intervention | /data[at0001]/items[at0014]/items[at0015] |
decisiondecision_codedecision_systemdecision_valueset_id | coded texttext, text, text, text | yes | Decision | /data[at0001]/items[at0014]/items[at0034] |
precondition | text | yes | Precondition | /data[at0001]/items[at0014]/items[at0039] |
comment | text | yes | Comment | /data[at0001]/items[at0014]/items[at0040] |
Constraints
check ((intervention_code is null and intervention_system is null and intervention_valueset_id is null) or (intervention is not null and intervention_code is not null and intervention_system is not null and intervention_valueset_id is not null))
check ((decision_code is null and decision_system is null and decision_valueset_id is null and decision is null) or (decision is not null and decision_code is not null and decision_system is not null and decision_valueset_id is not null))Unique
advance_intervention_decisions_id, position
References
| Columns | Target | On delete |
|---|---|---|
advance_intervention_decisions_id | advance_intervention_decisions | cascade |
intervention_valueset_id, intervention_code, intervention_system, intervention | valueset_code | restrict |
decision_valueset_id, decision_code, decision_system, decision | valueset_code | restrict |
Value sets
| Value set | Codes |
|---|---|
org.openehr::openEHR-EHR-EVALUATION.advance_intervention_decisions.v1/cpr_decision | 4 |
org.openehr::openEHR-EHR-EVALUATION.advance_intervention_decisions.v1/decision | 4 |
org.openehr::openEHR-EHR-EVALUATION.advance_intervention_decisions.v1/intent_of_care | 5 |
org.openehr::openEHR-EHR-EVALUATION.advance_intervention_decisions.v1/intervention | 18 |