Definition

The Prescribing_IssueRecord extract represents individual prescription issue events in EMIS Web — each row is a single dispensing instance of a medication, linked to its parent drug authorisation record. It captures the specific quantity, dosage, and pharmacy details for each issue, and links to the consultation, the issuing clinician, and the linked clinical problem.

Information

The Prescribing_IssueRecord extract contains one row per prescription issue. Multiple issues can be generated from a single Prescribing_DrugRecord (e.g., monthly issues of a repeat prescription). From schema version 8.0 onwards, this table includes extended EMIS-specific prescribing fields such as emis_code, pharmacy messaging fields, and compliance indicators. Version 8.2 adds issuemethoddescription to describe how the prescription was issued.

Note: The expirydate field was discontinued in schema version 8.1 and is now always returned as NULL. Use Prescribing_DrugRecord.expirydate instead.

Each issue record is uniquely identified by issuerecordguid within the agreement scope.

Key Identifiers

• issuerecordguid: The unique EMIS identifier for this issue event.
• drugrecordguid: References the parent medication authorisation in Prescribing_DrugRecord.
• patientguid: References the patient in Admin_Patient.
• organisationguid: References the issuing practice in Admin_Organisation.
• clinicianuserinroleguid: References the issuing clinician in Admin_UserInRole.
• enteredbyuserinroleguid: References the staff member who entered the record.
• codeid: References the drug code in Coding_ClinicalCode and Coding_DrugCode.
• problemobservationguid: References the clinical problem this issue is linked to.
• consultationguid: References the consultation in which this issue was created.

Issue Details

• dosageinstructions: The dosage instructions as printed on this issue.
• quantity, quantityunit: The quantity and unit dispensed.
• issuemethoddescription: How the prescription was issued (e.g., Electronic Prescription Service, hand-written) — schema v8.2+.
• pharmacymessage, pharmacytext: Pharmacy-specific instructions and free-text messages.

Clinical Dates

• effectivedate, effectivedateprecision: The clinical date of the issue.
• entereddate, enteredtime: When the record was entered into EMIS Web.

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Issue Date & Quantity"]
    n2["Dispensing Method"]
    n3["Consultation 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 issue records"]
  n16 --> n14["ETL"]
  n14 --> n15["Prescribing_IssueRecord Model"]

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