Gecko Bridge

The Healthcare Reference Platform

A governed reference database providing a single source of truth for Healthcare reference data across SQL Server, SSIS, Power BI and data warehouse solutions.

What it contains

  • HRGs, OPCS-4 and ICD-10, SNOMED
  • HRG Code to Group mappings and grouper reference data
  • NHS ODS Organisation Codes
  • ONS Postcodes
  • Specialties, Consultants, PODs
  • NHS Data Dictionary Elements
  • NHS Payment Scheme Tariffs
  • National reference tables and metadata
  • NHSE Statistics
  • Version control and governance support

Why it matters

Many NHS reporting solutions end up with duplicated lookup tables and inconsistent definitions. Gecko Bridge gives SQL Server, SSIS, Power BI and data warehouse solutions a consistent reference foundation.

  • Reduce duplicated reference-data development
  • Improve consistency between reports
  • Support reusable facts and dimensions
  • Strengthen data governance and version control
  • Simplify SQL Server and Power BI development
Gecko Bridge Tools

Explore published NHS reference data

Public tools powered by governed, versioned reference data held in Gecko Bridge.

HRG and Specialty Tariff

Search HRG and outpatient specialty tariffs from the NHS Payment Scheme, view Best Practice Tariffs and optionally calculate provider MFF-adjusted values.

Open HRG and Specialty Tariff

Code to HRG Explorer

Search OPCS-4 and ICD-10 codes, explore published Code to Group HRG mappings and possible Group to Split outcomes, then jump directly to associated tariff information.

Open Code to HRG Explorer

ECDS SNOMED Mapper

Search SNOMED CT codes across ECDS, identify the ECDS type, check validity dates and view CDS 10 grouping mappings where applicable.

Open ECDS SNOMED Mapper

PSS Service Code Checker

Search prescribed specialised service codes, view delegation status and PSO identification rules, check eligible providers and see specialist top-up rates where applicable.

Open PSS Service Code Checker