Definition

The CareRecord_ObservationReferral extract captures the referral-specific details associated with clinical observations of referral type in EMIS Web. It extends the base observation record with referral attributes — such as urgency, service type, mode, target organisation, and episode closure information — providing a complete picture of each referral event initiated by a clinician.

Information

The CareRecord_ObservationReferral extract contains one row per referral observation, linked to the parent observation in CareRecord_Observation via observationguid. A referral is both an observation (with a clinical code, effective date, and consultation context) and a referral event (with urgency, direction, target organisation, and outcome dates).

Each record is uniquely identified by observationguid within the agreement scope.

Key Identifiers

• observationguid: The unique EMIS identifier for the referral, shared with the parent observation in CareRecord_Observation.
• patientguid: References the referred patient in Admin_Patient.
• organisationguid: References the referring practice in Admin_Organisation.
• referraltargetorganisationguid: References the organisation to which the patient is referred.
• referralsourceorganisationguid: References the organisation from which the referral originated, if different.
• referralreasoncodeid: References the clinical code describing the reason for the referral in Coding_ClinicalCode.

Referral Classification

• referralurgency: Numeric urgency level (e.g., Routine, Soon, Urgent, 2 Week Wait).
• referralservicetype: The type of service the patient is being referred to.
• referralmode: The mode of referral (e.g., written, electronic, telephone).
• transportrequired: Indicates whether transport is required for the patient (stored as varchar from schema v8.0).
• referraltargetclinician: The specific clinician targeted by the referral.
• referraltargetdepartment: The department within the target organisation.

Dates and Episode

• referralreceiveddate, referralreceivedtime: When the referral was received by the target organisation.
• referralenddate: The date the referral episode closed.
• referralepisoderttmeasurementtypeid: The RTT (Referral to Treatment) measurement type.
• referralepisodeclosuredate: Date the RTT episode was closed.
• referralepisodedischargeletterissueddate: Date the discharge letter was issued.
• referralclosurereasoncodeid: References the clinical code for the reason the referral was closed.

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Referral Target & Specialty"]
    n2["Urgency & Direction"]
    n3["Referral Reason Code"]
  end

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

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

  container --> n16["Gather referral data"]
  n16 --> n14["ETL"]
  n14 --> n15["CareRecord_ObservationReferral Model"]

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