Definition

Purpose

The issue_record model extracts medication issue records for patients included in specific recruit studies. It captures medication-related issues and disposals with administrative information and personally identifiable information preserved.

Information

This patient-linked model documents medication issues and disposal records. Each issue record represents a single medication issue entry or disposal event.

• emis_issue_guid (PK): The unique identifier for the issue record
• emis_registration_guid (FK): Hashed registration identifier - links to patient registration
• patient_id (FK): Patient identifier with PII preserved
• emis_medication_organisation_guid (FK): Organisation managing the issue
• emis_code_id (FK): The code for the issue
• study_id (FK): Study cohort identifier

Examples

Get all issue records for a patient

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

Find issue records for a specific study

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

Get issue records with dosage and cost information

SELECT
  emis_issue_guid,
  patient_id,
  emis_code_id,
  dose,
  quantity,
  uom,
  estimated_nhs_cost
FROM hive.explorer_recruit.medication_issuerecord
WHERE patient_id = 123456789
LIMIT 100;