Definition

Purpose

The session_user model maps users (user-in-role) to appointment sessions. It is organisation-level metadata and not patient-scoped, enabling tracking of clinician availability in scheduled sessions.

Information

This intersection table tracks which users are assigned to which appointment sessions, establishing the clinician availability schedule. This supports appointment slot creation and availability checking.

• emis_session_guid (PK): The unique identifier for the session
• emis_session_userinrole_guid (FK): Links to the user role assigned to this session

Examples

Get all session-user memberships for an organisation

SELECT *
FROM hive.explorer_recruit.appointment_session_user
WHERE organisation = 'CDB-0001'
LIMIT 100;

Find all users in a specific session

SELECT
  emis_session_guid,
  emis_session_userinrole_guid,
  user_in_role_id
FROM hive.explorer_recruit.appointment_session_user
WHERE session_id = 'SESSION-123'
LIMIT 100;

Find all sessions a user is assigned to

SELECT
  emis_session_guid,
  session_id,
  emis_session_userinrole_guid
FROM hive.explorer_recruit.appointment_session_user
WHERE user_in_role_id = 'ROLE-456'
LIMIT 100;