Definition

The Appointment_Session extract represents scheduled clinic sessions defined within EMIS Web. A session is a block of time organised by a practice at a specific location, during which appointment slots are made available for patients. Sessions capture the type, category, start and end times, and the associated organisation and location.

Information

The Appointment_Session extract provides the structural backbone for appointment data. Each session groups together one or more appointment slots (Appointment_Slot) and can be staffed by one or more clinicians (Appointment_SessionUser).

Each session is uniquely identified by appointmentsessionguid within the agreement scope.

Key Identifiers

• appointmentsessionguid: The unique EMIS identifier for this session.
• organisationguid: References the practice responsible for the session.
• locationguid: References the physical site where the session takes place.

Session Details

• description: A free-text description of the session (e.g., ‘Morning GP Surgery’).
• sessiontypedescription: Classifies the session type (e.g., Surgery, Clinic, Home Visit).
• sessioncategorydisplayname: The display category of the session (e.g., GP, Nurse, Admin).

Timing

• startdate, starttime: The date and time the session begins.
• enddate, endtime: The date and time the session ends.

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Session Date & Time"]
    n2["Clinician & Location"]
    n3["Session Capacity"]
  end

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

  container --> n16["Gather session data"]
  n16 --> n14["ETL"]
  n14 --> n15["Appointment_Session Model"]