| _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 |
| emis_code_id | string | EMIS code identifier (aliased from code_id) | ‘A123’ |
| snomed_concept_id | string | SNOMED concept identifier | ’123456’ |
| data_dictionary_national_code | string | National data dictionary code | ’DDC123’ |
| attribute_type | string | Attribute type for the mapping | ’Severity’ |
| _mkb_version | string | MKB coding system version | ’MKB-229’ |
| organisation | string | Organisation identifier for the source record | ’EMIS’ |