Schema
The core schema represents the MKB Mapping Attributes schema derived from EMIS source systems.
| Column Name | Data Types | Description | Example |
|---|---|---|---|
| is_deleted | boolean | Indicates if this record should be considered soft deleted | FALSE |
| code_id | bigint | The unique EMIS code identifier for the attribute code | 460101014 |
| data_dictionary_national_code | varchar | The NHS data dictionary code used to identify the national data element associated with the mapping. | so |
| snomed_concept_id | bigint | The unique identifier for concepts within the SNOMED CT clinical terminology. | 315583002 |
| attribute_type | varchar | The description of the attribute type | language |
| organisation | varchar | Set to ‘EMIS’ | EMIS |
| transform_datetime | timestamp(6) with time zone | The timestamp indicating when the record was last processed and updated in the data model. | 2024-01-15 10:30:45 |
| _execution_date | varchar | The transform_datetime formatted as yyyyMMddHHmmss. This column is provided only for backward compatibility. | 20240115103045 |
Vanilla
Section titled “Vanilla”The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.
| Column Name | Data Types | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _record_version | varchar | ✓ | ✗ | ||
| _mkb_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| data_dictionary_national_code | varchar | ✓ | ✓ | ||
| attribute_type | varchar | ✓ | ✓ | ||
| organisation | varchar | ✓ | ✓ | ||
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | ||
| _execution_date | varchar | ✓ | ✓ |
Apollo
Section titled “Apollo”The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.
| Column Name | Data Types | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _record_version | varchar | ✓ | ✗ | ||
| _mkb_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| data_dictionary_national_code | varchar | ✓ | ✓ | ||
| attribute_type | varchar | ✓ | ✓ | ||
| organisation | varchar | ✓ | ✓ | ||
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | ||
| _execution_date | varchar | ✓ | ✓ |
Artemis
Section titled “Artemis”The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.
| Column Name | Data Types | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _record_version | varchar | ✓ | ✗ | ||
| _mkb_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| data_dictionary_national_code | varchar | ✓ | ✓ | ||
| attribute_type | varchar | ✓ | ✓ | ||
| organisation | varchar | ✓ | ✓ | ||
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | ||
| _execution_date | varchar | ✓ | ✓ |
Hermes
Section titled “Hermes”The table below presents the flavour specific schema.
| Column Name | Data Type |
|---|---|
| is_deleted | boolean |
| code_id | bigint |
| snomed_concept_id | bigint |
| data_dictionary_national_code | varchar |
| attribute_type | varchar |
| organisation | varchar |
| transform_datetime | timestamp(6) with time zone |
Hestia
Section titled “Hestia”The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.
| Column Name | Data Types | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _record_version | varchar | ✓ | ✗ | ||
| _mkb_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| data_dictionary_national_code | varchar | ✓ | ✓ | ||
| attribute_type | varchar | ✓ | ✓ | ||
| organisation | varchar | ✓ | ✓ | ||
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | ||
| _execution_date | varchar | ✓ | ✓ |
Olympus
Section titled “Olympus”The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.
| Column Name | Data Types | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _record_version | varchar | ✓ | ✗ | ||
| _mkb_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| data_dictionary_national_code | varchar | ✓ | ✓ | ||
| attribute_type | varchar | ✓ | ✓ | ||
| organisation | varchar | ✓ | ✓ | ||
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | ||
| _execution_date | varchar | ✓ | ✓ |
Prometheus
Section titled “Prometheus”The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.
| Column Name | Data Types | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _record_version | varchar | ✓ | ✗ | ||
| _mkb_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| data_dictionary_national_code | varchar | ✓ | ✓ | ||
| attribute_type | varchar | ✓ | ✓ | ||
| organisation | varchar | ✓ | ✓ | ||
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | ||
| _execution_date | varchar | ✓ | ✓ |
Pseudo_Anon
Section titled “Pseudo_Anon”The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.
| Column Name | Data Types | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _record_version | varchar | ✓ | ✗ | ||
| _mkb_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| data_dictionary_national_code | varchar | ✓ | ✓ | ||
| attribute_type | varchar | ✓ | ✓ | ||
| organisation | varchar | ✓ | ✓ | ||
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | ||
| _execution_date | varchar | ✓ | ✓ |
Themis
Section titled “Themis”The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.
| Column Name | Data Types | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _record_version | varchar | ✓ | ✗ | ||
| _mkb_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| data_dictionary_national_code | varchar | ✓ | ✓ | ||
| attribute_type | varchar | ✓ | ✓ | ||
| organisation | varchar | ✓ | ✓ | ||
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | ||
| _execution_date | varchar | ✓ | ✓ |
The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.
| Column Name | Data Types | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _record_version | varchar | ✓ | ✗ | ||
| _mkb_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| data_filter | integer | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| data_dictionary_national_code | varchar | ✓ | ✓ | ||
| attribute_type | varchar | ✓ | ✓ | ||
| organisation | varchar | ✓ | ✓ | ||
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | ||
| _execution_date | varchar | ✓ | ✓ |