Definition

Purpose

The drug_record model extracts medication records for patients included in specific recruit studies. It captures prescribed and over-the-counter medications with dosage and administrative information and personally identifiable information preserved.

Information

This patient-linked model provides comprehensive medication records including dosage, strength, and route information. Each medication record can be linked to associated clinical problems and represents a single medication entry or refill.

• emis_drug_guid (PK): The unique identifier for the drug 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 medication
• emis_code_id (FK): The drug code for identification
• study_id (FK): Study cohort identifier

Examples

Get all drug records for a patient

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

Find active drug records for a study

SELECT *
FROM hive.explorer_recruit.medication_drugrecord
WHERE study_id = 'STUDY001'
  AND drug_active_flag = TRUE
LIMIT 100;

Get drug records with dosage information

SELECT
  emis_drug_guid,
  patient_id,
  emis_code_id,
  dose,
  quantity,
  uom,
  emis_prescription_type
FROM hive.explorer_recruit.medication_drugrecord
WHERE patient_id = 123456789
LIMIT 100;