Definition

Purpose

The organisation model extracts organisation metadata. It is not patient-scoped and provides identifiers, codes, and hierarchy information for healthcare organisations and their relationships.

Information

This master table contains top-level organisation definitions including their classification, hierarchy relationships, and primary operational site. Organisations form the fundamental grouping for users, sessions, and locations, establishing the primary scope for data access and service delivery.

• emis_organisation_guid (PK): The unique identifier for the organisation
• emis_parent_organisation_guid (FK): Links to the parent organisation if hierarchically related
• emis_ccg_organisation_guid (FK): Links to the Clinical Commissioning Group
• emis_main_location_guid (FK): Links to the primary location for the organisation

Examples

Get all organisations

SELECT *
FROM hive.explorer_recruit.organisation
LIMIT 100;

Find an organisation by ODS code

SELECT
  emis_organisation_guid,
  ods_code,
  organisation_type_description,
  open_date
FROM hive.explorer_recruit.organisation
WHERE ods_code = 'ABC01'
LIMIT 100;

Find active organisations (no close date)

SELECT
  emis_organisation_guid,
  ods_code,
  organisation_type_description,
  open_date
FROM hive.explorer_recruit.organisation
WHERE close_date IS NULL
LIMIT 100;