Schema
| Column Name | Data Type | Description | Example |
|---|---|---|---|
| is_deleted | boolean | If this record should be considered soft deleted | FALSE |
| preparation_code_id | bigint | EMIS code_id - internal identifier for the drug preparation | 123456 |
| preparation_pack_id | bigint | PK The identifier for the preparation in a given pack | 78901 |
| supplier_name | varchar | The name of the supplier/manufacturer | ’Examplus Healthcare Ltd’ |
| term | varchar | Description of the drug or medication | ’Metformin 500mg tablets’ |
| dmd_product_code_id | bigint | Dictionary of Medicines and Devices (dm+d) product identifier | 123456789 |
| pack_description | varchar | A description of the pack | ’28 tablet’ |
| units_per_pack | double | How many of the unit of measure is contained in the pack | 28.0 |
| unit_of_measure | varchar | The unit type for the medication (e.g., tablets, ml) | ‘tablet’ |
| pack_price | real | How much the pack costs | 1.42 |
| price_per_unit | real | Cost of an individual unit of measure (pack price / units per pack) | 0.0507 |
| is_guide_price_pack | boolean | Indicates if pack price is the amount NHS will reimburse prescriber | TRUE |
| 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_divisible | boolean | If this preparation is divisible | FALSE |
| 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.000 UTC’ |
| _execution_date | varchar | Formatted transform datetime for versioning | ’20230512143015’ |
Vanilla
Section titled “Vanilla”Not used in this schema
Apollo
Section titled “Apollo”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 | ✓ | ✓ | |
| prep_pack_id | bigint | ✓ | ✓ | |
| supplier_name | varchar | ✓ | ✓ | |
| emis_term | varchar | ✓ | ✓ | |
| dmd_productcode_id | bigint | ✓ | ✓ | |
| pack_description | varchar | ✓ | ✓ | |
| units_per_pack | double | ✓ | ✓ | |
| uom | varchar | ✓ | ✓ | |
| pack_price | real | ✓ | ✓ | |
| price_per_unit | real | ✓ | ✓ | |
| is_guide_price_pack_flag | boolean | ✓ | ✓ | |
| is_breakable_flag | boolean | ✓ | ✓ | |
| non_divisible_flag | boolean | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✗ | ✓ |
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”Not used in this schema
Not used in this schema