Definition

Purpose

The consultation model extracts consultation-related data for patients included in specific recruit studies. It captures clinical encounter records with all encounter details and personally identifiable information preserved.

Information

This patient-linked model provides encounter-level consultations where clinical notes and observations are recorded. Each consultation is uniquely identified by emis_consultation_guid and represents a single clinical interaction between patient and clinician.

• emis_consultation_guid (PK): The unique identifier for the consultation
• emis_registration_guid (FK): Hashed registration identifier - links to patient registration
• patient_id (FK): Patient identifier with PII preserved
• emis_registration_organisation_guid (FK): Organisation where the consultation occurred
• emis_authorising_userinrole_guid (FK): Clinician who authored the consultation
• study_id (FK): Study cohort identifier

Examples

Get all consultations for a patient

SELECT *
FROM hive.explorer_recruit.encounter
WHERE patient_id = 123456789
LIMIT 100;

Find consultations for a specific study

SELECT *
FROM hive.explorer_recruit.encounter
WHERE study_id = 'STUDY001'
LIMIT 100;

Find confidential consultations

SELECT *
FROM hive.explorer_recruit.encounter
WHERE confidential_flag = TRUE
LIMIT 100;