| Column Name | Data Type | Description | Example |
|---|
| is_deleted | boolean | If this record should be considered soft deleted | FALSE |
| dmd_product_code_id | bigint | Dictionary of Medicines and Devices (dm+d) product identifier | 12354611500001104 |
| snomed_description_id | bigint | ID of the preferred SNOMED description | 330690010 |
| preparation_code_id | bigint | EMIS code_id - internal identifier for the drug preparation | 123546 |
| other_code | varchar | NULL | NULL |
| other_code_system | varchar | Other system http address | website link |
| other_display | varchar | NULL | NULL |
| organisation | varchar | The organisation that this data was replicated from | ’EMIS’ |
| transform_datetime | timestamp | 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’ |
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 |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| drug_preparation_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| other_code_system | varchar | ✓ | ✓ | |
| other_code | varchar | ✓ | ✓ | |
| other_display | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
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 |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| drug_preparation_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| other_code_system | varchar | ✓ | ✓ | |
| other_code | varchar | ✓ | ✓ | |
| other_display | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
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 |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| drug_preparation_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| other_code_system | varchar | ✓ | ✓ | |
| other_code | varchar | ✓ | ✓ | |
| other_display | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
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 |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| drug_preparation_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| other_code_system | varchar | ✓ | ✓ | |
| other_code | varchar | ✓ | ✓ | |
| other_display | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
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 |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| drug_preparation_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| other_code | varchar | ✓ | ✓ | |
| other_code_system | varchar | ✓ | ✓ | |
| other_display | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
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 |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| drug_preparation_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| other_code_system | varchar | ✓ | ✓ | |
| other_code | varchar | ✓ | ✓ | |
| other_display | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
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 |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| drug_preparation_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| other_code_system | varchar | ✓ | ✓ | |
| other_code | varchar | ✓ | ✓ | |
| other_display | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
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 |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| is_deleted | boolean | ✗ | ✓ | |
| drug_preparation_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| other_code_system | varchar | ✓ | ✓ | |
| other_code | varchar | ✓ | ✓ | |
| other_display | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
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 |
|---|
| _record_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _mkb_version | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| _ingest_time | varchar | ✓ | ✗ | Removed as it is deprecated in iPCV v2 |
| data_filter | integer | ✓ | ✗ | Removed as it is deprecated in v2 |
| is_deleted | boolean | ✗ | ✓ | |
| drug_preparation_code_id | bigint | ✓ | ✓ | |
| snomed_concept_id | bigint | ✓ | ✓ | |
| snomed_description_id | bigint | ✓ | ✓ | |
| other_code_system | varchar | ✓ | ✓ | |
| other_code | varchar | ✓ | ✓ | |
| other_display | varchar | ✓ | ✓ | |
| organisation | varchar | ✓ | ✓ | |
| transform_datetime | timestamp(6) with time zone | ✗ | ✓ | |
| _execution_date | varchar | ✓ | ✓ | |
