Definition

Purpose

The immunisation model extracts immunisation data for patients included in specific recruit studies. It captures vaccination records including vaccine details, batch numbers, and administration information with personally identifiable information preserved.

Information

This patient-linked model provides immunisation records with manufacturer and batch details. Each immunisation record represents a single vaccination event recorded in EMIS Web.

• emis_observation_guid (PK): The unique identifier for the immunisation record
• 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 immunisation was given
• emis_authorising_userinrole_guid (FK): Clinician who administered the immunisation
• emis_consultation_guid (FK): The consultation during which the immunisation was administered
• emis_code_id (FK): The vaccine code
• study_id (FK): Study cohort identifier

Examples

Get all immunisations for a patient

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

Find immunisations for a specific study

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

Get immunisations with SNOMED mapping and batch details

SELECT
  emis_observation_guid,
  patient_id,
  emis_code_id,
  snomed_concept_id,
  batch_number,
  expiry_date
FROM hive.explorer_recruit.immunisation
WHERE snomed_concept_id IS NOT NULL
  AND patient_id = 123456789
LIMIT 100;