Schema

Raw

Column Name	Data Type	Description	Example
is_deleted	BOOLEAN	Flag indicating if the code is deleted (or deprecated)	false
code_id	BIGINT	Unique identifier for the ethnicity code (Primary Key)	12345
snomed_concept_id	BIGINT	SNOMED CT concept identifier (nullable)	186034007
snomed_description	VARCHAR	Human-readable description of the SNOMED concept	’White British’
snomed_description_id	BIGINT	ID of the preferred SNOMED description	234567
organisation	VARCHAR	Identifier for the data source, always ‘EMIS'	'EMIS’
transform_datetime	TIMESTAMP(6) WITH TIME ZONE	Timestamp when the record was last transformed	’2023-05-12 14:30:15+00’
_execution_date	VARCHAR	Formatted transform datetime for versioning	’20230512143015’

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
_mkb_version	varchar	✓	✗
_record_version	varchar	✓	✗
_ingest_time	varchar	✓	✗
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description_id	bigint	✓	✓
snomed_description	varchar	✓	✓
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Apollo

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
_mkb_version	varchar	✓	✗
_record_version	varchar	✓	✗
_ingest_time	varchar	✓	✗
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description	varchar	✓	✓
snomed_description_id	bigint	✓	✓
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Artemis

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
_mkb_version	varchar	✓	✗
_record_version	varchar	✓	✗
_ingest_time	varchar	✓	✗
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description	varchar	✓	✓
snomed_description_id	bigint	✓	✓
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Hestia

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
_mkb_version	varchar	✓	✗
_record_version	varchar	✓	✗
_ingest_time	varchar	✓	✗
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description	varchar	✓	✓
snomed_description_id	bigint	✓	✓
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Olympus

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
_mkb_version	varchar	✓	✗
_record_version	varchar	✓	✗
_ingest_time	varchar	✓	✗
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description	varchar	✓	✓
snomed_description_id	bigint	✓	✓
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Prometheus

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
_mkb_version	varchar	✓	✗
_record_version	varchar	✓	✗
_ingest_time	varchar	✓	✗
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
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

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
_mkb_version	varchar	✓	✗
_record_version	varchar	✓	✗
_ingest_time	varchar	✓	✗
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description_id	bigint	✓	✓
snomed_description	varchar	✓	✓
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

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
_mkb_version	varchar	✓	✗
_record_version	varchar	✓	✗
_ingest_time	varchar	✓	✗
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description_id	bigint	✓	✓
snomed_description	varchar	✓	✓
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Zeus

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
_mkb_version	varchar	✓	✗
_record_version	varchar	✓	✗
_ingest_time	varchar	✓	✗
data_filter	integer	✓	✗
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description	varchar	✓	✓
snomed_description_id	bigint	✓	✓
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓