Definition

Purpose

The diary_entry model extracts diary entry data for patients included in specific recruit studies. It captures recall and follow-up items recorded in EMIS Web with personally identifiable information preserved.

Information

This patient-linked model provides diary entries for patient recalls and follow-up actions. Each diary entry is uniquely identified by emis_diary_guid and records actions or recalls to be completed.

• emis_diary_guid (PK): The unique identifier for the diary entry
• 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 creating the diary entry
• emis_authorising_userinrole_guid (FK): User who created the diary entry
• emis_code_id (FK): The diary entry code
• study_id (FK): Study cohort identifier

Examples

Get all diary entries for a patient

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

Find diary entries for a specific study

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

Find active diary entries

SELECT *
FROM hive.explorer_recruit.recall
WHERE is_active_flag = TRUE
LIMIT 100;