Definition

Purpose

The issue_record_problem_link model documents links between medication issue records and problem observations for patients included in recruit studies. It captures relationships between issue records and clinical problems with personally identifiable information preserved.

Information

This link table enables tracking of associations between medication issue observations and associated problem records. Each link record represents a single relationship between an issue record and a problem observation within a study cohort.

• emis_observation_guid (PK): The unique identifier for the link record
• emis_issue_guid (FK): Links to the associated medication issue
• emis_registration_guid (FK): Hashed registration identifier
• patient_id (FK): Patient identifier with PII preserved
• organisation (FK): The organisation managing the link
• study_id (FK): Study cohort identifier

Examples

Get all issue-problem links for a patient

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

Find issue-problem links for a study

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

Find all issue records linked to a specific problem observation

SELECT
  emis_observation_guid,
  emis_issue_guid,
  intent,
  patient_id
FROM hive.explorer_recruit.medication_issuerecord_problem_link
WHERE emis_observation_guid = 'OBS-GUID-123'
LIMIT 100;