Definition

Purpose

The mkb_version model records the active MKB (Medical Knowledge Base) version per organisation and the last execution timestamp for the mapping data.

Information

This lookup table maintains the version information for the medical knowledge base used within each organisation. It enables tracking of which MKB version was active during data processing and supports version-aware querying of mapped codes and terminology.

• mkb_version (PK): The unique MKB version identifier

Examples

Get all MKB versions for an organisation

SELECT *
FROM hive.explorer_recruit_anon.mkb_version
LIMIT 100;

Find the latest MKB version

SELECT
  mkb_version,
  organisation,
  _execution_date
FROM hive.explorer_recruit_anon.mkb_version
ORDER BY _execution_date DESC
LIMIT 10;

Check which organisations have a specific MKB version

SELECT
  organisation,
  mkb_version
FROM hive.explorer_recruit_anon.mkb_version
WHERE mkb_version = '10.1'
LIMIT 100;