Definition

The Prescribing_DrugRecord extract represents the medication authorisation records in EMIS Web — the master prescribing record that defines a drug authorised for a patient, from which individual issues are generated. It captures the drug, dosage instructions, the authorising clinician, the linked clinical problem, and key lifecycle dates.

Information

The Prescribing_DrugRecord extract contains one row per drug authorisation per patient. Each drug record is the parent of one or more issue records in Prescribing_IssueRecord. It records the medication as authorised — whether as a repeat, acute, or other prescription type — along with dosage, quantity, and the linked clinical code and problem.

Note: The expirydate field was added to this table in schema version 8.1 following its discontinuation in Prescribing_IssueRecord.

Each drug record is uniquely identified by drugrecordguid within the agreement scope.

Key Identifiers

• drugrecordguid: The unique EMIS identifier for this drug authorisation record.
• patientguid: References the patient in Admin_Patient.
• organisationguid: References the practice in Admin_Organisation.
• clinicianuserinroleguid: References the authorising 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 the medication is associated with.

Prescription Details

• dosageinstructions: The free-text dosage instructions for the medication.
• quantity: The quantity prescribed per issue.
• quantityunit: The unit of measure for the quantity.
• prescriptiontype: Classifies the prescription (e.g., Repeat, Acute, Repeat Dispensing).

Clinical Dates

• effectivedate, effectivedateprecision: The clinical date the medication was authorised.
• entereddate, enteredtime: When the record was entered into EMIS Web.
• expirydate: The expiry date of the drug authorisation (schema v8.1+).

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Drug Authorisation"]
    n2["Dose & Method"]
    n3["Prescribing Dates"]
  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 drug records"]
  n16 --> n14["ETL"]
  n14 --> n15["Prescribing_DrugRecord Model"]

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