| _execution_date | date | View execution timestamp | ’2026-04-10’ |
| _ingest_time | timestamp | Timestamp of data ingestion | ’2026-04-10T09:00:00Z’ |
| _record_version | integer | Internal record version identifier | 1 |
| snomed_concept_id | string | SNOMED concept identifier | ’123456’ |
| snomed_description | string | SNOMED description text | ’Example description’ |
| emis_code_id | string | EMIS code identifier (aliased from code_id) | ‘A123’ |
| snomed_description_id | string | SNOMED description identifier | ’654321’ |
| _mkb_version | string | MKB coding system version | ’MKB-229’ |
| organisation | string | Organisation identifier (source organisation) | ‘EMIS’ |