Definition

Purpose

The session model provides appointment session scheduling metadata from the anonymised extract. It is organisation-level metadata and not patient-scoped, containing schedule definitions for healthcare appointments.

Information

This master table defines appointment sessions available within organisations, including their scheduling times, staffing availability, and clinical specialties. Sessions form the fundamental scheduling units for patient appointments.

• emis_session_guid (PK): The unique identifier for the session
• emis_location_guid (FK): Links to the location where the session is held
• emis_session_organisation_guid (FK): Links to the organisation providing the session

Examples

Get all sessions for an organisation

SELECT *
FROM hive.explorer_recruit_anon.appointment_session
WHERE organisation = 'CDB-0001'
LIMIT 100;

Find sessions for a specific date

SELECT
  emis_session_guid,
  session_type_description,
  session_start_date,
  session_start_time,
  session_end_date
FROM hive.explorer_recruit_anon.appointment_session
WHERE start_date = DATE '2026-04-14'
LIMIT 100;

Find non-deleted private sessions

SELECT *
FROM hive.explorer_recruit_anon.appointment_session
WHERE private = TRUE
  AND deleted = FALSE
  AND organisation = 'CDB-0001'
LIMIT 100;