intervention_summary

A summary about a therapeutic activity intended to prevent, diagnose, treat, or manage health conditions, support mental or physical well-being, or address social and environmenta…

A summary about a therapeutic activity intended to prevent, diagnose, treat, or manage health conditions, support mental or physical well-being, or address social and environmental factors that influence health outcomes.

Purpose. To record a summary of a commenced or completed therapeutic intervention.

Source

Columns

Constraints

check ((intervention_name_code is null and intervention_name_system is null and intervention_name_valueset_id is null) or (intervention_name is not null and intervention_name_code is not null and intervention_name_system is not null and intervention_name_valueset_id is not null))
check ((intervention_type_code is null and intervention_type_system is null and intervention_type_valueset_id is null) or (intervention_type is not null and intervention_type_code is not null and intervention_type_system is not null and intervention_type_valueset_id is not null))
check ((clinical_indication_code is null and clinical_indication_system is null and clinical_indication_valueset_id is null) or (clinical_indication is not null and clinical_indication_code is not null and clinical_indication_system is not null and clinical_indication_valueset_id is not null))
check ((intent_code is null and intent_system is null and intent_valueset_id is null) or (intent is not null and intent_code is not null and intent_system is not null and intent_valueset_id is not null))
check ((impact_code is null and impact_system is null and impact_valueset_id is null) or (impact is not null and impact_code is not null and impact_system is not null and impact_valueset_id is not null))
check ((delivery_outcome_code is null and delivery_outcome_system is null and delivery_outcome_valueset_id is null) or (delivery_outcome is not null and delivery_outcome_code is not null and delivery_outcome_system is not null and delivery_outcome_valueset_id is not null))
check ((reason_for_delivery_outcome_code is null and reason_for_delivery_outcome_system is null and reason_for_delivery_outcome_valueset_id is null) or (reason_for_delivery_outcome is not null and reason_for_delivery_outcome_code is not null and reason_for_delivery_outcome_system is not null and reason_for_delivery_outcome_valueset_id is not null))
check ((therapeutic_outcome_code is null and therapeutic_outcome_system is null and therapeutic_outcome_valueset_id is null) or (therapeutic_outcome is not null and therapeutic_outcome_code is not null and therapeutic_outcome_system is not null and therapeutic_outcome_valueset_id is not null))
check (intervention_id_system is null or intervention_id_value is not null)

Unique

• form_block_id

References

Indexes

• intervention_summary_form_id_idx on form_id

Value sets