Definition

The CareRecord_Diary extract captures diary and recall entries recorded in EMIS Web as part of a patient’s care record. Diary entries represent planned future actions, reminders, or follow-up tasks associated with a patient — such as recall for a chronic disease review, immunisation, or cervical smear — and are linked to the consultation in which they were created.

Information

The CareRecord_Diary extract provides access to all diary and recall entries recorded across patients within the agreement scope. Each entry is associated with a clinical code, a responsible clinician, and the consultation context. Diary entries carry an effective date indicating when the action is due, as well as entry metadata tracking when and by whom the record was created.

Each diary entry is uniquely identified by diaryguid within the agreement scope.

Key Identifiers

• diaryguid: The unique EMIS identifier for this diary entry.
• patientguid: References the patient in Admin_Patient.
• organisationguid: References the practice in Admin_Organisation.
• consultationguid: References the parent consultation in CareRecord_Consultation.
• clinicianuserinroleguid: References the clinician responsible for the diary action.
• enteredbyuserinroleguid: References the staff member who entered the record.
• codeid: References the clinical code for this diary entry in Coding_ClinicalCode.

Clinical Dates

• effectivedate: The date the diary action is due or was recorded.
• effectivedateprecision: The precision of the effective date.
• entereddate, enteredtime: When the diary record was created in EMIS Web.

Clinical Content

• associatedtext: Free-text notes associated with the diary entry.

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Diary Entry & Code"]
    n2["Recall Date"]
    n3["Clinician & Consultation"]
  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 diary entries"]
  n16 --> n14["ETL"]
  n14 --> n15["CareRecord_Diary Model"]

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