Definition

The Admin_PatientHistory extract provides a temporal record of changes to a patient’s registration status over time. Each row captures a point-in-time snapshot of the patient’s status and type at a given organisation, enabling longitudinal tracking of registration lifecycle events such as registrations, deregistrations, and status transitions.

Information

The Admin_PatientHistory extract records every status change event for a patient at a practice. Where Admin_Patient reflects the current state, Admin_PatientHistory provides the full history, making it essential for analysing patient journeys and registration trends over time.

Each record is uniquely identified by the combination of patientguid, organisationguid, and the event timestamp (historydate, historytime).

Key Identifiers

• patientguid: References the patient in Admin_Patient.
• organisationguid: References the practice where the status change occurred.

Status Fields

• statusdescription: The patient’s registration status at the point in time (e.g., Registered, Deducted, Deceased).
• patienttypedescription: The patient type recorded at the time of the event (e.g., Regular, Temporary).

Event Timing

• historydate: The date of the registration status change event.
• historytime: The time of the status change event.

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Historical Demographics"]
    n2["Previous Registrations"]
    n3["Transfer Records"]
  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 patient history"]
  n16 --> n14["ETL"]
  n14 --> n15["Admin_PatientHistory Model"]

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