Definition

The Audit_RegistrationAudit extract records the history of patient registration events at GP practices. Each row captures a registration lifecycle event — such as a new registration, a transfer, or a deduction — including the user who processed the change and when it occurred.

Information

The Audit_RegistrationAudit extract provides a chronological log of registration-related changes for each patient at each organisation. Unlike Admin_PatientHistory, which tracks status descriptions, this table focuses on the audit context — recording the user responsible and the mode of the change for governance and traceability purposes.

Each record is uniquely identified by the combination of patientguid, organisationguid, and auditid.

Key Identifiers

• patientguid: References the patient whose registration was modified.
• organisationguid: References the practice where the event occurred.
• userinroleguid: References the staff member who processed the registration change.
• auditid: A sequential identifier for the audit event.

Event Details

• modetype: The type of registration action (e.g., New Registration, Deduction, Transfer In).

Timestamps

• modifieddate: The date the registration change was processed.
• modifiedtime: The time the registration change was processed.

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Registration Changes"]
    n2["Previous Values"]
    n3["Audit Timestamp"]
  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 registration audit"]
  n16 --> n14["ETL"]
  n14 --> n15["Audit_RegistrationAudit Model"]

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