Definition

Purpose

The referral model extracts referral-related data for patients included in specific recruit studies. It captures patient referrals to other services with full clinical details and personally identifiable information preserved.

Information

This patient-linked model documents referrals from primary care to specialist services. Each referral record provides clinical context including the reason for referral, urgency, and target service details.

• emis_referral_guid (PK): The unique identifier for the referral
• emis_registration_guid (FK): Hashed registration identifier - links to patient registration
• patient_id (FK): Patient identifier with PII preserved
• organisation (FK): The organisation making the referral
• study_id (FK): Study cohort identifier

Examples

Get all referrals for a patient

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

Find referrals for a specific study

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

Get urgent referrals with service type

SELECT
  emis_observation_guid,
  patient_id,
  emis_urgency_description,
  service_type_requested_description,
  referral_mode_description
FROM hive.explorer_recruit.referral
WHERE emis_urgency_description = 'URGENT'
LIMIT 100;