Definition

The Appointment_SessionUser extract is a linking table that associates clinicians (users in roles) with appointment sessions. It records which healthcare staff members are assigned to deliver a given session, supporting workload attribution and session staffing analysis.

Information

The Appointment_SessionUser extract resolves the many-to-many relationship between Appointment_Session and Admin_UserInRole. A session may be staffed by multiple clinicians, and a clinician may be assigned to multiple sessions.

Each record is uniquely identified by the combination of sessionguid and userinroleguid.

Key Identifiers

• sessionguid: References the appointment session in Appointment_Session.
• userinroleguid: References the assigned clinician in Admin_UserInRole.

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Session Reference"]
    n2["Clinician Reference"]
    n3["Session Slots"]
  end

  n17["GP Practice 1"] --> container
  n18["GP Practice 2"] --> container

  container --> n16["Gather session-user links"]
  n16 --> n14["ETL"]
  n14 --> n15["Appointment_SessionUser Model"]