Schema
The core schema represents the MKB Mapping Ethnicity schema derived from EMIS source systems.
| Column Name | Data Type | 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 ethnicity code | 285954016 |
| snomed_concept_id | bigint | The unique identifier for concepts within the SNOMED CT clinical terminology. | 414481008 |
| snomed_description | varchar | The preferred term that describes the concept within the SNOMED CT clinical terminology. | ‘White British’ |
| snomed_description_id | bigint | The unique identifier for the preferred term that describes the concept within the SNOMED CT clinical terminology. | 2533844017 |
| 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. | ‘2023-09-01 09:00:00.000000 UTC’ |
| _execution_date | varchar | The transform_datetime formatted as yyyyMMddHHmmss. This column is provided only for backward compatibility. | ‘20230512143015’ |
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 Type | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _mkb_version | varchar | ✓ | ✗ | ||
| _record_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| snomed_description_id | bigint | ✓ | ✓ | ||
| snomed_description | 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 Type | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _mkb_version | varchar | ✓ | ✗ | ||
| _record_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| snomed_description | varchar | ✓ | ✓ | ||
| snomed_description_id | bigint | ✓ | ✓ | ||
| 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 Type | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _mkb_version | varchar | ✓ | ✗ | ||
| _record_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| snomed_description | varchar | ✓ | ✓ | ||
| snomed_description_id | bigint | ✓ | ✓ | ||
| 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 |
| snomed_description | varchar |
| snomed_description_id | bigint |
| 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 Type | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _mkb_version | varchar | ✓ | ✗ | ||
| _record_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| snomed_description | varchar | ✓ | ✓ | ||
| snomed_description_id | bigint | ✓ | ✓ | ||
| 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 Type | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _mkb_version | varchar | ✓ | ✗ | ||
| _record_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| snomed_description | varchar | ✓ | ✓ | ||
| snomed_description_id | bigint | ✓ | ✓ | ||
| 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 Type | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _mkb_version | varchar | ✓ | ✗ | ||
| _record_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| snomed_description | varchar | ✓ | ✓ | ||
| snomed_description_id | bigint | ✓ | ✓ | ||
| 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 Type | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _mkb_version | varchar | ✓ | ✗ | ||
| _record_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| snomed_description_id | bigint | ✓ | ✓ | ||
| snomed_description | 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 Type | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _mkb_version | varchar | ✓ | ✗ | ||
| _record_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| snomed_description_id | bigint | ✓ | ✓ | ||
| snomed_description | 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 Type | Data in V1 | Data in V2 | Core Mapping | Comments |
|---|---|---|---|---|---|
| _mkb_version | varchar | ✓ | ✗ | ||
| _record_version | varchar | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| data_filter | integer | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | ||
| snomed_description | varchar | ✓ | ✓ | ||
| snomed_description_id | bigint | ✓ | ✓ | ||
| organisation | varchar | ✓ | ✓ | ||
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | ||
| _execution_date | varchar | ✓ | ✓ |