Definition

The Consultation Section data model represents the structured sections within a consultation (for example, History, Examination, Plan, Medication Review). Each section is linked back to its parent consultation and, where applicable, to the underlying clinical event data.

Constraints and Notes

• Soft deletion : When is_deleted is true, data fields will be nullified in upstream transformations and should be excluded from most analytical queries. Primary keys and foreign keys to patient data are preserved so deleted records and their relationships can still be identified. Foreign keys to coding tables and SNOMED CT identifiers are nullified as the coded information is no longer valid.

Examples

List completed consultation sections

Simple query to return completed consultation sections with their headings and parent consultation identifiers:

SELECT
  consultation_section_id,
  consultation_id,
  patient_id,
  consultation_section_original_heading,
  effective_date,
  is_complete
FROM explorer_open_safely.consultation_section
WHERE is_complete;