Definition

The overall encounter between a patient and a healthcare provider or organisation It captures the high‑level context such as consultation type, dates and location.

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

Filter incomplete consultations

Simple query to return consultations that are not complete:

SELECT
  consultation_id,
  patient_id,
  effective_date,
  is_complete
FROM explorer_open_safely.consultation
WHERE NOT is_complete;