Schema
| Column Name | Data Type | Description | Example |
|---|---|---|---|
| is_deleted | boolean | If this record should be considered soft deleted | FALSE |
| codeid | bigint | EMIS Web Code ID | 12345 |
| conceptid | bigint | SNOMED Concept ID | 10022455 |
| organisation | varchar | Organisation identifier | CDB-50002 |
| transform_datetime | timestamp(6) with time zone | The datetime that the data was made available in the model with a relevant change | ’2023-05-12 14:30:15.000000 UTC’ |
| _execution_date | varchar | Timestamp of an Explorer Platform execution | 20241015070047 |
Vanilla
Section titled “Vanilla”Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|---|---|---|---|
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| 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
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”Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|---|---|---|---|
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ |
Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this model.
| Column Name | Data Type | Data Exists in v1 | Data Exists in v2 | Comments |
|---|---|---|---|---|
| is_deleted | boolean | ✗ | ✓ | |
| emis_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✓ | ✓ | |
| _execution_date | varchar | ✗ | ✓ | |
| data_filter | integer | ✓ | ✗ | Removed as it is deprecated in v2 |

