Schema
The core schema represents the Sensitive SNOMED Code 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 clinical code | 484341000006114 |
| concept_id | bigint | SNOMED Concept ID | 484341000006105 |
| 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-05-12 14:30:15.000000 UTC’ |
| _execution_date | varchar | The transform_datetime formatted as yyyyMMddHHmmss. This column is provided only for backward compatibility. | 20241015070047 |
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 | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | concept_id | |
| organisation | varchar | ✓ | ✓ | ||
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | ||
| _execution_date | varchar | ✓ | ✓ |
Apollo
Section titled “Apollo”Not used in this schema
Artemis
Section titled “Artemis”Not used in this schema
Hermes
Section titled “Hermes”The table below presents the flavour specific schema.
| Column Name | Data Type |
|---|---|
| is_deleted | boolean |
| code_id | bigint |
| concept_id | bigint |
| organisation | varchar |
| transform_datetime | timestamp(6) with time zone |
Hestia
Section titled “Hestia”Not used in this schema
Olympus
Section titled “Olympus”Not used in this schema
Prometheus
Section titled “Prometheus”Not used in this schema
Pseudo_Anon
Section titled “Pseudo_Anon”Not used in this schema
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 | ✓ | ✗ | ||
| _ingest_time | varchar | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | concept_id | |
| 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 | ✓ | ✗ | ||
| is_deleted | boolean | ✗ | ✓ | ||
| emis_code_id | bigint | ✓ | ✓ | code_id | |
| snomed_concept_id | bigint | ✓ | ✓ | concept_id | |
| organisation | varchar | ✓ | ✓ | ||
| transform_datetime | timestamp(6) with time zone | ✓ | ✓ | ||
| _execution_date | varchar | ✓ | ✓ | ||
| data_filter | integer | ✓ | ✗ |