Schema

Schema Overview

Column Name	Data Type	Description	Example
dmd_product_code_id	bigint	Dictionary of Medicines and Devices (dm+d) product identifier; also a SNOMED CT concept identifier	12354611500001104
is_breakable	boolean	If you can break a pack i.e. it comes in 12, you only need 10, can you do this?	false
is_deleted	boolean	If this record should be considered soft deleted; all columns excluding primary keys will be NULL if TRUE	false
is_divisible	boolean	If this preparation is divisible	false
is_guide_price_pack	boolean	Indicates if pack price is the amount NHS will reimburse prescriber	true
model_updated_datetime	timestamp(6) with time zone	Date and time the model last updated this record	2023-05-12 14:30:15.000000 UTC
organisation	varchar	The organisation that this data was replicated from. Will be ‘EMIS’ for all records in this table	EMIS
pack_description	varchar	A description of the pack	28 tablet
pack_price	real	How much the pack costs	1.42
preparation_code_id	bigint	EMIS code ID - internal identifier	123456
preparation_pack_id	bigint	The unique identifier for the preparation in a pack	78901
price_per_unit	real	Cost of an individual unit of measure (pack price / units per pack)	0.0507
supplier_name	varchar	The name of the supplier/manufacturer	Examplus Healthcare Ltd
term	varchar	Description of the drug or medication	Metformin 500mg tablets
transform_datetime	timestamp(6) with time zone	Date and time the data was made available in the model with a relevant change	2023-05-12 14:30:15.000000 UTC
unit_of_measure	varchar	The unit type for the medication (e.g. ‘tablet’, ‘ml’, etc.)	tablet
units_per_pack	double	How many of the unit of measure is contained in the pack	28