Definition

Purpose

The observation model extracts observation-related data for patients included in specific recruit studies. It captures clinical measurements and findings recorded in EMIS Web with personally identifiable information preserved.

Information

This patient-linked model provides clinical observations including measurements, test results, and clinical findings. Each observation is uniquely identified by emis_observation_guid and can include numeric values with units of measurement.

• emis_observation_guid (PK): The unique identifier for the observation
• 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 observation was recorded
• emis_authorising_userinrole_guid (FK): Clinician who recorded the observation
• emis_code_id (FK): The clinical code for the observation
• study_id (FK): Study cohort identifier

Examples

Get all observations for a patient

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

Find observations for a specific study

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

Get numeric observations with units

SELECT
  emis_observation_guid,
  patient_id,
  emis_code_id,
  numericvalue,
  uom,
  observation_type,
  effective_date
FROM hive.explorer_recruit.observation
WHERE numericvalue IS NOT NULL
  AND patient_id = 123456789
LIMIT 100;