Schema

Raw

Column Name	Data Type	Description	Example
is_deleted	boolean	If this record should be considered soft deleted	false
organisation	varchar	The organisation that this data was replicated from	’EMIS’
codeid	bigint	PK EMIS code - internal identifier	348898019
parent_code_id	bigint	populated if EMIS Code ID has a parent Code ID	361953013
term	varchar	Description of EMIS Code ID	’Pulmonary valvectomy’
read_term_id	varchar	Old code	791D1
readv2_code	varchar	Old readv2 code	791D100
snomed_concept_id	bigint	SNOMED CT concept identifier	218361000
snomed_description_id	bigint	ID of the preferred SNOMED description	330690010
national_code_category	varchar	National Code category name	ACTIVITY LOCATION TYPE CODE
national_code	varchar	National letter code	G02
national_description	varchar	National code description	Nursing Home
emis_code_category_description	varchar	EMIS Code ID category description	Referral
transform_datetime	timestamp(6) with time zone	datetime 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

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this model.

Column Name	Data Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
emis_codecategory_description	varchar	✓	✓
national_code	varchar	✓	✓
national_code_category	varchar	✓	✓
national_description	varchar	✓	✓
parent_emis_code_id	bigint	✓	✓
emis_old_code	varchar	✓	✓
readv2_code	varchar	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description_id	bigint	✓	✓
emis_term	varchar	✓	✓
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Apollo

Not used in this schema

Artemis

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this model.

Column Name	Data Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
emis_codecategory_description	varchar	✓	✓
national_code	varchar	✓	✓
national_code_category	varchar	✓	✓
national_description	varchar	✓	✓
parent_emis_code_id	bigint	✓	✓
emis_old_code	varchar	✓	✓
readv2_code	varchar	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description_id	bigint	✓	✓
emis_term	varchar	✓	✓
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

Hestia

Not used in this schema

Olympus

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this model.

Column Name	Data Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
emis_term	varchar	✓	✓
emis_old_code	varchar	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description_id	bigint	✓	✓
national_code	varchar	✓	✓
national_code_category	varchar	✓	✓
national_description	varchar	✓	✓
emis_code_category_description	varchar	✓	✓
parent_emis_code_id	bigint	✓	✓
processing_id	bigint	✓	✗	Removed as it is deprecated in iPCV v1
transform_datetime	timestamp(6) with time zone	✗	✓
organisation	varchar	✓	✓
_execution_date	varchar	✓	✓

Prometheus

Refer to the definition / universal-improvements page for detailed differences between v1 and v2 of this model.

Column Name	Data Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
emis_term	varchar	✓	✓
emis_old_code	varchar	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description_id	bigint	✓	✓
national_code	varchar	✓	✓
national_code_category	varchar	✓	✓
national_description	varchar	✓	✓
emis_code_category_description	varchar	✓	✓
parent_emis_code_id	bigint	✓	✓
processing_id	bigint	✓	✗	Removed as it is deprecated in iPCV v1
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 Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
code_id	bigint	✓	✓
parent_code_id	bigint	✓	✓
term	varchar	✓	✓
read_term_id	varchar	✓	✓
snomed_ct_concept_id	bigint	✓	✓
snomed_ct_description_id	bigint	✓	✓
national_code	varchar	✓	✓
national_code_category	varchar	✓	✓
national_description	varchar	✓	✓
emis_code_category_description	varchar	✓	✓
processing_id	bigint	✓	✗	Removed as it is deprecated in iPCV v1
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 Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
emis_codecategory_description	varchar	✓	✓
national_code	varchar	✓	✓
national_code_category	varchar	✓	✓
national_description	varchar	✓	✓
parent_emis_code_id	bigint	✓	✓
emis_old_code	varchar	✓	✓
readv2_code	varchar	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description_id	bigint	✓	✓
emis_term	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 Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
emis_codecategory_description	varchar	✓	✓
national_code	varchar	✓	✓
national_code_category	varchar	✓	✓
national_description	varchar	✓	✓
parent_emis_code_id	bigint	✓	✓
emis_old_code	varchar	✓	✓
readv2_code	varchar	✓	✓
snomed_concept_id	bigint	✓	✓
snomed_description_id	bigint	✓	✓
emis_term	varchar	✓	✓
organisation	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
data_filter	integer	✓	✗	Removed as it is deprecated in v2