Definition

The Admin_Organisation extract provides a comprehensive record of healthcare organisations registered within EMIS Web. Each record represents a GP practice or other healthcare body participating in a data-sharing agreement, including its identifiers, type, hierarchy, and operational dates.

Information

The Admin_Organisation extract is the central reference for all organisation-level data across the IM1 feed. It supports hierarchical organisation structures through parentorganisationguid and links to the commissioning body via ccgorganisationguid. The main physical location of the organisation is captured via mainlocationguid.

Each organisation record is uniquely identified by organisationguid within an agreement scope.

Key Identifiers

• organisationguid: The unique EMIS identifier for this organisation.
• cdb: The EMIS Configuration Database identifier, used as the primary join key in many downstream processes.
• odscode: The ODS (Organisation Data Service) code — the NHS standard identifier for GP practices and other health bodies.
• parentorganisationguid: References the parent organisation in a hierarchy (e.g., a federation or group practice).
• ccgorganisationguid: References the commissioning body responsible for this organisation. CCGs (Clinical Commissioning Groups) were abolished in July 2022 and replaced by Integrated Care Boards (ICBs). This field therefore represents the grandparent organisation (ICB or equivalent) in the organisational hierarchy.
• mainlocationguid: References the primary physical location of the organisation in Admin_Location.

Descriptive Fields

• organisationname: The registered name of the organisation.
• organisationtype: Classifies the organisation (e.g., GP Practice, Out of Hours, Community).

Lifecycle Dates

• opendate: The date the organisation was registered as active.
• closedate: The date the organisation closed, if applicable. Null indicates an active organisation.

Practical Use

flowchart TB
  subgraph container["Data Collection"]
    n1["Organisation Name"]
    n2["ODS Code & Type"]
    n3["ICB / Commissioning Body"]
  end

  n17["GP Practice A"] --> container
  n18["GP Practice B"] --> container
  n19["PCN / ICB"] --> container

  container --> n16["Gather organisation data"]
  n16 --> n14["ETL"]
  n14 --> n15["Admin_Organisation Model"]