Definition

Purpose

The slot model extracts appointment slot data for appointments included in specific recruit studies. It captures individual appointment slots with scheduling and status information.

Information

This model provides appointment slot scheduling details for patients within the study cohort. Each slot represents an available or booked appointment time with duration and attendance status tracking.

• emis_appointment_slot_guid (PK): The unique identifier for the appointment slot
• patient_id (FK): Patient identifier with PII preserved
• organisation (FK): The organisation providing the appointment
• study_id (FK): Study cohort identifier

Examples

Get all appointment slots for a patient

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

Find appointment slots for a study

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

Find did-not-attend appointments with duration

SELECT
  emis_appointment_slot_guid,
  patient_id,
  slot_start_date,
  planned_duration_in_minutes,
  did_not_attend_flag
FROM hive.explorer_recruit.current_appointment
WHERE did_not_attend_flag = TRUE
LIMIT 100;