Definition

The Consultation data model describes clinical encounters recorded in EMIS Web and made available for OpenSafely analysis. It captures the consultation’s identifiers, timing, provenance, completion status, and linkage to sections and appointment slots.

Constraints and Notes

• Primary key usage: emis_consultation_id is part of a composite key with organisation in iPCV models and is not globally unique.
• Patient identifier hashing: emis_patient_id is a hashed identifier derived from patient ID + organisation.

Examples

Filter incomplete consultations

Simple query to return consultations that are not complete:

SELECT
  emis_consultation_id,
  emis_patient_id,
  recorded_date,
  effective_date,
  complete
FROM explorer_open_safely.consultation
WHERE NOT complete;