Definition

The Audit_PatientAudit extract captures a detailed audit trail of access and modification events against patient records in EMIS Web. Each row records who accessed or changed a patient record, when it happened, and what type of action was performed — supporting clinical governance, information governance, and regulatory compliance.

Information

The Audit_PatientAudit extract provides a per-event log of interactions with patient records in EMIS Web. It records the item (record) affected, the patient involved, the organisation, the user responsible, and the mode and type of the interaction.

Each audit event is uniquely identified by a combination of itemguid, patientguid, organisationguid, and auditid.

Key Identifiers

• itemguid: The unique identifier for the audited item (the specific record that was accessed or modified).
• patientguid: References the patient whose record was involved.
• organisationguid: References the practice where the event occurred.
• userinroleguid: References the staff member who performed the action.
• auditid: A sequential identifier for the audit event.

Event Details

• itemtype: The type of clinical item that was accessed or modified (e.g., Consultation, Observation, Prescription).
• modetype: The type of action performed (e.g., Read, Write, Delete).

Timestamps

• modifieddate: The date the audit event was recorded.
• modifiedtime: The time the audit event was recorded.

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Access Event Type"]
    n2["User & Timestamp"]
    n3["Accessed Record"]
  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 audit events"]
  n16 --> n14["ETL"]
  n14 --> n15["Audit_PatientAudit Model"]

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