Definition

Purpose

The patient model extracts patient demographic and identity data for individuals included in specific recruit studies. It provides registration and personal information with personally identifiable data preserved.

Information

This core patient-scoped model contains patient demographic information including identity, registration, and vital personal details. Each patient has a unique emis_patient_guid and can have multiple registrations across different healthcare organisations.

• emis_patient_guid (PK): The unique identifier for the patient
• emis_registration_guid (FK): The patient’s registration identifier
• emis_organisation_guid (FK): Organisation where the patient is registered
• study_id (FK): Study cohort identifier

Examples

Get a patient record by patient ID

SELECT *
FROM hive.explorer_recruit.patient
WHERE patientid = 123456789
LIMIT 100;

Find patients registered at a specific organisation

SELECT
  patientid,
  emis_registration_id,
  nhs_no,
  date_of_birth,
  gender,
  registered_date
FROM hive.explorer_recruit.patient
WHERE organisation = 'CDB-0001'
LIMIT 100;

Find patients with sensitive or confidential flags

SELECT
  patientid,
  emis_registration_id,
  sensitive_patient_flag,
  confidential_patient_flag
FROM hive.explorer_recruit.patient
WHERE sensitive_patient_flag = TRUE
   OR confidential_patient_flag = TRUE
LIMIT 100;