Definition

The CareRecord_Consultation extract represents the top-level clinical encounter between a patient and a healthcare provider in EMIS Web. A consultation is the organisational container for all clinical activity recorded during a single visit or interaction — including observations, diary entries, and prescriptions — and provides the temporal and contextual framework for the patient’s care record.

Information

The CareRecord_Consultation extract captures every consultation recorded against patients within the agreement scope. Consultations link to the patient, the responsible clinician, the organisation, and optionally the appointment slot that triggered the encounter. All clinical sub-records (observations, diary entries, issue records) carry a consultationguid that traces them back to this table.

Each consultation is uniquely identified by consultationguid within the agreement scope.

Key Identifiers

• consultationguid: The unique EMIS identifier for this consultation.
• patientguid: References the patient in Admin_Patient.
• organisationguid: References the practice in Admin_Organisation.
• clinicianuserinroleguid: References the clinician who led the consultation in Admin_UserInRole.
• enteredbyuserinroleguid: References the staff member who entered the record, if different from the consulting clinician.
• appointmentslotguid: References the appointment slot that this consultation is linked to in Appointment_Slot.
• consultationsourcecodeid: References the coded source of the consultation in Coding_ClinicalCode.

Clinical Dates

• effectivedate: The clinical date of the consultation (when it took place).
• effectivedateprecision: The precision of the effective date.
• entereddate, enteredtime: When the consultation record was entered into EMIS Web.

Consultation Attributes

• consultationtype: The type of consultation (e.g., Administration, Telephone, Home Visit).

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Consultation Date & Type"]
    n2["Clinician & Source"]
    n3["Session Link"]
  end

  n17["Organisation 1"] --> n7
  n17["Organisation 1"] --> n5
  n18["Organisation 2"] --> n6
  n18["Organisation 2"] --> n8

  n7["Patient 123"] --> container
  n5["Patient 98"] --> container
  n6["Patient 456"] --> container
  n8["Patient 47"] --> container

  container --> n16["Gather consultation data"]
  n16 --> n14["ETL"]
  n14 --> n15["CareRecord_Consultation Model"]

  n7:::rect
  n5:::rect
  n6:::rect
  n8:::rect