Definition

The Admin_Patient extract provides a comprehensive, longitudinal record of individuals registered with GP practices in EMIS Web. It serves as the foundational dataset for patient-centric analysis, containing demographic details, registration status, NHS identifiers, address information, and links to the patient’s usual GP and registered organisation.

Information

The Admin_Patient extract captures all essential administrative information about a patient at their registered practice. It covers personal demographics, contact details, registration dates, and key relationships to the organisation and clinician responsible for their care.

Each patient record is uniquely identified by patientguid within the agreement scope.

Key Identifiers

• patientguid: The unique EMIS identifier for the patient.
• nhsnumber: The NHS number — the national patient identifier used for cross-system matching.
• organisationguid: References the registered practice in Admin_Organisation.
• usualgpuserinroleguid: References the patient’s usual GP in Admin_UserInRole.
• personguid: The EMIS person-level GUID, which may link across multiple registrations.

Demographics

• title, givenname, surname: Patient name components.
• middlenames: Additional given names.
• sex: Biological sex as recorded in EMIS Web.
• dateofbirth: The patient’s date of birth.
• dateofdeath: Date of death, if recorded.

Address and Contact

• housenameflat number, street, village, town: Address components.
• postcode: Used for geographical analysis and deprivation scoring.
• contactdetails: Phone and contact information for the patient.

Registration

• dateofregistration: Date the patient registered with the practice.
• dateofdeactivation: Date the patient’s registration was deactivated, if applicable.
• patienttypedescription: Classifies the registration type (e.g., Regular, Temporary, Dummy).

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Demographics"]
    n2["NHS Number & Identifiers"]
    n3["Registration & Address"]
  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 patient data"]
  n16 --> n14["ETL"]
  n14 --> n15["Admin_Patient Model"]

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