Schema

Raw

Column Name	Data Type	Description	Example
is_deleted	boolean	If this record should be considered soft deleted	FALSE
code_id	bigint	PK EMIS code - internal identifier for the drug code	123456789
old_code	varchar	Original code of entity assigned within CDI authoring platform - read code, drug code etc.	‘PICC555’
term	varchar	Description of the drug or medication	’Paracetamol 500mg tablets’
dmd_product_code_id	bigint	Dictionary of Medicines and Devices (dm+d) product identifier	12354611500001104
organisation	varchar	The organisation that this data was replicated from	’EMIS’
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	Formatted transform datetime for versioning	’20230512143015’

Vanilla

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

Columns Name	Data Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
dmd_productcode_id	bigint	✓	✓
emis_old_code	varchar	✓	✓
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.

Columns Name	Data Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
dmd_productcode_id	bigint	✓	✓
emis_old_code	varchar	✓	✓
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.

Columns Name	Data Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
emis_term	varchar	✓	✓
dmd_product_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	✓	✓

Prometheus

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

Columns Name	Data Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
emis_old_code	varchar	✓	✓
emis_term	varchar	✓	✓
dmd_product_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.

Columns Name	Data Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
code_id	bigint	✓	✓
term	varchar	✓	✓
dmd_product_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	✓	✓

Themis

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

Columns Name	Data Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
dmd_productcode_id	bigint	✓	✓
emis_old_code	varchar	✓	✓
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.

Columns Name	Data Types	Data Exists in v1	Data Exists in v2	Comments
is_deleted	boolean	✗	✓
emis_code_id	bigint	✓	✓
dmd_productcode_id	bigint	✓	✓
emis_old_code	varchar	✓	✓
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