Schema

Core

The core schema represents the Drug Record model schema derived from source to present a unified view of prescription information.

Please note that how much of this model is visible varies between flavours.

Column Name	Data Type	Description	Example / Values
is_deleted	boolean	Indicates whether a drug record has been deleted at source.	FALSE
load_datetime	timestamp(6) with time zone	The datetime that the record was last upserted into the EXA data lake from EMIS source system with a relevant change from source system.	‘2023-09-01 09:00:00.000000 UTC’
_ingest_time	varchar	The load_datetime formatted as yyyyMMddHHmmss. This is a legacy column maintained for backward compatibility	‘20230512143015’
organisation	varchar	An identifier for the source of data (an organisation) relating to a given GP practice	‘CDB-1234’
drug_record_id	bigint	The unique internal identifier for the drug record within an organisation.	123456789
drug_record_guid	varchar	The GUID for the drug record within an organisation.	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
drug_record_uuid	varchar	The UUID derived from drug_record_id and organisation, providing a stable unique identifier.	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
patient_id	bigint	The unique internal identifier for the patient record within the organisation, for whom the drug record was prescribed.	123456
patient_guid	varchar	The unique GUID for the patient record within an organisation	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
patient_uuid	varchar	The UUID derived from patient_id and organisation, providing a stable unique identifier	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
patient_organisation_id	bigint	The unique internal identifier for the organisation where the patient is registered	12345
patient_organisation_guid	varchar	The GUID of the organisation where the patient is registered	‘c9d0e1f2-a3b4-2c5d-7e8f-9a0b1c2d3e4f’
patient_organisation_uuid	varchar	The UUID derived from patient_organisation_id and organisation, providing a stable unique identifier.	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
drug_record_organisation_id	bigint	The unique internal identifier of the organisation where the drug record was prescribed	12345
drug_record_organisation_guid	varchar	The GUID of the organisation where the drug record was prescribed.	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
drug_record_organisation_uuid	varchar	The UUID derived from drug_record_organisation_id and organisation, providing a stable unique identifier	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
authorising_user_in_role_id	bigint	The unique identifier of the clinician who authorised or authored the drug record	112
authorising_user_in_role_uuid	varchar	The UUID derived from authorising_user_in_role_id and organisation, providing a stable unique identifier.	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
original_authorising_user_in_role_id	bigint	The unique identifier of the original clinician who authorised or authored the drug record. This will differ from authorising_user_in_role_id in situations where changes have been authorised to the original prescription by a different clinician.	44556677
original_authorising_user_in_role_uuid	varchar	The UUID of the original authorising user derived from original_authorising_user_in_role_id and organisation, providing a stable unique identifier	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
entered_by_user_in_role_id	bigint	The unique identifier of the user who entered the drug record	334
entered_by_user_in_role_uuid	varchar	The UUID derived from entered_by_user_in_role_id and organisation, providing a stable unique identifier.	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
cancelled_by_user_in_role_id	bigint	The unique identifier of the user who cancelled the drug record. Will only be populated if a drug record has ended or is cancelled.	447
cancelled_by_user_in_role_uuid	varchar	The UUID of the user who cancelled the drug record derived from cancelled_by_user_in_role_id and organisation, providing a stable unique identifier	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
cancellation_reason	varchar	Reason for the cancellation (free text)	‘Patient request’
cancellation_datetime	timestamp(6) with time zone	Date and time the drug record was cancelled	‘2023-09-01 09:00:00.000000 UTC’
availability_datetime	timestamp(6) with time zone	The date and time the drug record was recorded in the source system	‘2023-09-01 10:30:00.000000 UTC’
effective_datetime	timestamp(6) with time zone	Clinical effective date and time of the drug record	‘2023-09-01 09:00:00.000000 UTC’
effective_datetime_precision	varchar	Precision of the effective datetime; set to ‘YMDT’.	‘YMDT’
expiry_datetime	timestamp(6) with time zone	Date and time the prescription expires	‘2023-09-01 09:00:00.000000 UTC’
first_issue_datetime	timestamp(6) with time zone	Date and time of the first issue against this drug record. This is taken from Issue Record to be the effective date of the first issue recorded, excluding cancelled issues and future dates. Will be NULL where prescription was never issued.	‘2023-09-01 09:00:00.000000 UTC’
authorised_course_datetime	timestamp(6) with time zone	Date and time the course was authorised	‘2023-09-01 09:00:00.000000 UTC’
review_date	date	Date the prescription is due for review	‘2024-07-01’
original_term	varchar	The EMIS term for the medication prescribed.	‘Amoxicillin 500mg capsules’
patient_text	varchar	Notes made for the patient while recording the prescription (free text)	‘Patient Info - Ibuprofen’
pharmacy_text	varchar	Notes made for the pharmacy related to the prescription (free text)	‘Pharmacy Info - Ibuprofen’
local_mixture_name	varchar	Name of the locally prepared mixture, if applicable. This is for locally prescribed drug records that don’t have a coded equivalent. Expect this to be very sparsely populated.	‘ADULT COUGH LINCTUS’
local_mixture_id	bigint	The unique identifier for the local mixture prescribed	8
drug_status	bigint	Indicates whether the status of the drug record is Current (1) i.e. active or Past (2) i.e Completed or Cancelled	1
prescription_type_id	bigint	The unique identifier for the type of prescription	2
prescription_type_description	varchar	The type of prescription of the drug record i.e. acute, repeat, repeat-dispensing, or automatic	‘repeat’
dosage	varchar	Dosage instructions for the drug record	‘One to be taken twice daily’
course_duration_in_days	bigint	Course length of prescription, in days	28
quantity	decimal(9,3)	Quantity prescribed	56.000
quantity_unit	varchar	Unit of the quantity	‘tablet’
quantity_representation	varchar	Complete representation of the quantity prescribed, combining quantity and unit. representation	‘56 tablet’
quantity_multiplicand	decimal(9,3)	Multiplicand component of quantity	56.000
quantity_multiplier	decimal(9,3)	Multiplier component of quantity	1.000
quantity_multiplier_uom	varchar	Unit of measure for the multiplier	‘pack’
number_of_issues	bigint	Number of times this drug record has been issued so far.	3
number_of_issues_authorised	bigint	Number of issues authorised for the prescription i.e. maximum times it can be issued.	12
most_recent_issue_record_id	bigint	The unique internal identifier of the most recent issue record for this prescription, within an organisation. This is taken from Issue Record to be the most recent not cancelled issue recorded, excluding future dates.	777888999
most_recent_issue_record_uuid	varchar	The UUID of the corresponding most recent issue record derived from most_recent_issue_record_id and organisation, providing a stable unique identifier	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
most_recent_issue_method_id	bigint	Internal identifier for the most recent issue method of this drug record. This is taken from Issue Record to be the issue method associated with the most recent issue record above.	10
most_recent_issue_method_description	varchar	Description of the equivalent most recent issue method of this drug record	‘Private’
most_recent_issue_datetime	timestamp(6) with time zone	Date and time of the most recent issue of the prescription to date. This is taken from Issue Record to be the effective date of the most recent not cancelled issue recorded, excluding future dates.	‘2023-09-01 09:00:00.000000 UTC’
code_id	bigint	The unique EMIS code identifier for the medication prescribed	578241000033111
min_next_issue_days	bigint	Minimum number of days before the next issue can be processed	14
max_next_issue_days	bigint	Maximum number of days before the next issue must be processed	28
is_prescribed_as_contraceptive	boolean	Indicates whether the drug was prescribed as a contraceptive	FALSE
is_privately_prescribed	boolean	Indicates whether the drug was privately prescribed	TRUE
quantity_unit_of_measure_id	bigint	Internal identifier for the quantity unit of measure	12345
confidentiality_policy_id	bigint	Identifier of the applied confidentiality policy	-1
is_sensitive	boolean	Indicates whether the drug record is flagged as sensitive. The sensitive reference set codes are 999004351000000109( gender related issues), 999004371000000100(assisted fertilisation), 999004361000000107(termination of pregnancy) and 999004381000000103 (sexually transmitted disease)	FALSE
is_confidential	boolean	Indicates whether the drug record is confidential. This is based on confidentiality policy set against the patient / drug record	TRUE
transform_datetime	timestamp(6) with time zone	The timestamp indicating when the record was last processed and updated in the data model. This field is crucial for understanding the current state of the data.	‘2024-01-15 03:00:05.000000 UTC’
_execution_date	varchar	The transform_datetime formatted as yyyyMMddHHmmss. This is a legacy column provided only for backward compatibility with.	‘20240115030005’

Vanilla

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
nhs_prescribing_agency	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓	drug_record_guid
exa_drug_guid	varchar	✓	✓	drug_record_uuid
authorisedissues_authorised_date	timestamp(6) with time zone	✓	✓	authorised_course_datetime
authorisedissues_authorising_user_in_role	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorisedissues_enteredby_user_in_role	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
cancellation_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
original_authorising_user_in_role_id	bigint	✗	✓
original_authorising_user_in_role_uuid	varchar	✗	✓
authorisedissues_first_issue_date	timestamp(6) with time zone	✓	✓	first_issue_datetime
cancellation_reason	varchar	✓	✓
cancelled_by_user_in_role_id	bigint	✗	✓
cancelled_by_user_in_role_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓	code_id
confidential_flag	boolean	✓	✓	is_confidential
confidentiality_policy_id	bigint	✓	✓
dose	varchar	✓	✓	dosage
emis_medication_status	bigint	✓	✓	drug_status
duration_in_days	bigint	✓	✓	course_duration_in_days
duration_uom	varchar	✓	✓
fhir_medication_status	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
fhir_medication_intent	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
effective_date	timestamp(6) with time zone	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
most_recent_issue_record_id	bigint	✗	✓
most_recent_issue_record_uuid	varchar	✗	✓
emis_mostrecent_issue_date	timestamp(6) with time zone	✓	✓	most_recent_issue_datetime
most_recent_issue_method_id	bigint	✗	✓
emis_mostrecent_issue_method	varchar	✓	✓	most_recent_issue_method_description
prescription_type_id	bigint	✗	✓
exa_mostrecent_issue_date	varchar	✓	✗
emis_prescription_type	varchar	✓	✓	prescription_type_description
nhs_prescription_type	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
end_date	timestamp(6) with time zone	✓	✓	expiry_datetime
max_nextissue_days	bigint	✓	✓	max_next_issue_days
min_nextissue_days	bigint	✓	✓	min_next_issue_days
number_authorised	bigint	✓	✓	number_of_issues_authorised
number_of_issues	bigint	✓	✓
drug_record_organisation_id	bigint	✗	✓
drug_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
drug_record_organisation_uuid	varchar	✗	✓
patient_text	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_patient_id	bigint	✓	✓	patient_id
patient_uuid	varchar	✗	✓
pharmacy_text	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
prescribed_as_contraceptive_flag	boolean	✓	✓	is_prescribed_as_contraceptive
privately_prescribed_flag	boolean	✓	✓	is_privately_prescribed
quantity	decimal(9,3)	✓	✓
quantity_multiplicand	decimal(9, 3)	✓	✓
quantity_multiplier	decimal(9, 3)	✓	✓
quantity_multiplier_uom	varchar	✓	✓
quantity_representation	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓	availability_datetime
registration_guid	varchar	✓	✓	patient_guid
registration_ods_code	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
reimburse_type	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
review_date	date	✓	✓
emis_original_term	varchar	✓	✓	original_term
local_mixture_id	bigint	✗	✓
local_mixture_name	varchar	✗	✓
sensitive_flag	boolean	✓	✓	is_sensitive
cancellation_date	timestamp(6) with time zone	✓	✓	cancellation_datetime
quantity_unit_of_measure_id	bigint	✗	✓
uom	varchar	✓	✓	quantity_unit
_execution_date	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
organisation	varchar	✗	✓
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
other_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
uom_dmd	varchar	✓	✗
_record_version	varchar	✓	✗
_update_date	varchar	✓	✗
_update_hour	varchar	✓	✗

Apollo

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓	drug_record_guid
exa_drug_guid	varchar	✓	✓	drug_record_uuid
patient_id	bigint	✗	✓
registration_guid	varchar	✓	✓	patient_guid
patient_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
patient_organisation_guid	varchar	✗	✓
patient_organisation_uuid	varchar	✗	✓
duration_in_days	bigint	✓	✓	course_duration_in_days
emis_code_id	bigint	✓	✓	code_id
effective_date	timestamp(6) with time zone	✓	✓	effective_datetime
expiry_date	timestamp(6) with time zone	✓	✓	expiry_datetime
emis_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
quantity	decimal(9, 3)	✓	✓
quantity_unit_of_measure_id	bigint	✗	✓
uom	varchar	✓	✓	quantity_unit
dose	varchar	✓	✓	dosage
quantity_representation	varchar	✓	✓
quantity_multiplicand	decimal(9, 3)	✓	✓
quantity_multiplier	decimal(9, 3)	✓	✓
quantity_multiplier_uom	varchar	✓	✓
prescription_type_id	bigint	✗	✓
emis_prescription_type	varchar	✗	✓	prescription_type_description
nhs_prescription_type	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
active	boolean	✓	✓	drug_status
number_of_issues	bigint	✓	✓
number_authorised	bigint	✓	✓	number_of_issues_authorised
registration_ods_code	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
organisation	varchar	✓	✓
snomed_concept_id	bigint	✓	✗

Artemis

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓	drug_record_guid
exa_drug_guid	varchar	✓	✓	drug_record_uuid
nhs_prescribing_agency	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorisedissues_authorised_date	timestamp(6) with time zone	✓	✓	authorised_course_datetime
authorisedissues_authorising_user_in_role	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorisedissues_enteredby_user_in_role	varchar	✓	✓		Renamed from authorisedissues_enteredby_userinole in V1. Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
cancellation_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
original_authorising_user_in_role_id	bigint	✗	✓
original_authorising_user_in_role_uuid	varchar	✗	✓
authorisedissues_first_issue_date	timestamp(6) with time zone	✓	✓	first_issue_datetime
cancellation_reason	varchar	✓	✓
cancelled_by_user_in_role_id	bigint	✗	✓
cancelled_by_user_in_role_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓	code_id
confidential_flag	boolean	✓	✓	is_confidential
confidentiality_policy_id	bigint	✓	✓
dose	varchar	✓	✓	dosage
emis_medication_status	bigint	✓	✓	drug_status
duration_in_days	bigint	✓	✓	course_duration_in_days
duration_uom	varchar	✓	✓
fhir_medication_status	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
fhir_medication_intent	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
effective_date	timestamp(6) with time zone	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
most_recent_issue_record_id	bigint	✗	✓
most_recent_issue_record_uuid	varchar	✗	✓
emis_mostrecent_issue_date	timestamp(6) with time zone	✓	✓	most_recent_issue_datetime
most_recent_issue_method_id	bigint	✗	✓
emis_mostrecent_issue_method	varchar	✓	✓	most_recent_issue_method_description
prescription_type_id	bigint	✗	✓
emis_prescription_type	varchar	✓	✓	prescription_type_description
nhs_prescription_type	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
end_date	timestamp(6) with time zone	✓	✓	expiry_datetime
max_nextissue_days	bigint	✓	✓	max_next_issue_days
min_nextissue_days	bigint	✓	✓	min_next_issue_days
number_authorised	bigint	✓	✓	number_of_issues_authorised
number_of_issues	bigint	✓	✓
drug_record_organisation_id	bigint	✗	✓
drug_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
drug_record_organisation_uuid	varchar	✗	✓
emis_patient_id	bigint	✓	✓	patient_id
patient_uuid	varchar	✗	✓
prescribed_as_contraceptive_flag	boolean	✓	✓	is_prescribed_as_contraceptive
privately_prescribed_flag	boolean	✓	✓	is_privately_prescribed
quantity	decimal(9, 3)	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓	availability_datetime
registration_guid	varchar	✓	✓	patient_guid
registration_ods_code	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
reimburse_type	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
review_date	date	✓	✓
emis_original_term	varchar	✓	✓	original_term
local_mixture_id	bigint	✗	✓
local_mixture_name	varchar	✗	✓
sensitive_flag	boolean	✓	✓	is_sensitive
cancellation_date	timestamp(6) with time zone	✓	✓	cancellation_datetime
quantity_unit_of_measure_id	bigint	✗	✓
uom	varchar	✓	✓	quantity_unit
_execution_date	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
organisation	varchar	✓	✓
_record_version	varchar	✓	✗
_update_date	varchar	✓	✗
_update_hour	varchar	✓	✗
confidential_patient_flag	boolean	✓	✗
consultation_source_emis_code_id	varchar	✓	✗
consultation_source_emis_original_term	varchar	✓	✗
dummy_patient_flag	boolean	✓	✗
emis_issue_method	varchar	✓	✗
emis_encounter_guid	varchar	✓	✗
exa_encounter_guid	varchar	✓	✗
exa_prescription_guid	varchar	✓	✗
estimated_nhs_cost	varchar	✓	✗
exa_mostrecent_issue_date	varchar	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
other_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
snomed_concept_id	varchar	✓	✗
snomed_description_id	varchar	✓	✗
uom_dmd	varchar	✓	✗

Hermes

The table below presents the flavour specific schema.

Column Name	Data Type	Core Mapping
is_deleted	boolean
pseudo_drug_record_uuid	varchar	drug_record_uuid
pseudo_patient_uuid	varchar	patient_uuid
pseudo_patient_organisation_uuid	varchar	patient_organisation_uuid
pseudo_drug_record_organisation_uuid	varchar	drug_record_organisation_uuid
cancellation_datetime	timestamp(6) with time zone
availability_datetime	timestamp(6) with time zone
effective_datetime	timestamp(6) with time zone
effective_datetime_precision	varchar
expiry_datetime	timestamp(6) with time zone
first_issue_datetime	timestamp(6) with time zone
authorised_course_datetime	timestamp(6) with time zone
review_date	date
original_term	varchar
local_mixture_name	varchar
local_mixture_id	bigint
drug_status	bigint
prescription_type_id	bigint
prescription_type_description	varchar
dosage	varchar
course_duration_in_days	bigint
quantity	decimal(9,3)
quantity_unit	varchar
quantity_representation	varchar
quantity_multiplicand	decimal(9,3)
quantity_multiplier	decimal(9,3)
quantity_multiplier_uom	varchar
number_of_issues	bigint
number_of_issues_authorised	bigint
most_recent_issue_method_id	bigint
most_recent_issue_method_description	varchar
most_recent_issue_datetime	timestamp(6) with time zone
code_id	bigint
min_next_issue_days	bigint
max_next_issue_days	bigint
is_prescribed_as_contraceptive	boolean
is_privately_prescribed	boolean
quantity_unit_of_measure_id	bigint
confidentiality_policy_id	bigint
is_sensitive	boolean
is_confidential	boolean
organisation	varchar
transform_datetime	timestamp(6) with time zone

Hestia

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓	drug_record_guid
exa_drug_guid	varchar	✓	✓	drug_record_uuid
nhs_prescribing_agency	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorisedissues_authorised_date	timestamp(6) with time zone	✓	✓	authorised_course_datetime
authorisedissues_authorising_user_in_role	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorisedissues_enteredby_user_in_role	varchar	✓	✓		Renamed from authorisedissues_enteredby_userinole in V1. Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
cancellation_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
original_authorising_user_in_role_id	bigint	✗	✓
original_authorising_user_in_role_uuid	varchar	✗	✓
authorisedissues_first_issue_date	timestamp(6) with time zone	✓	✓	first_issue_datetime
cancellation_reason	varchar	✓	✓
cancelled_by_user_in_role_id	bigint	✗	✓
cancelled_by_user_in_role_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓	code_id
confidential_flag	boolean	✓	✓	is_confidential
confidentiality_policy_id	bigint	✓	✓
dose	varchar	✓	✓	dosage
emis_medication_status	bigint	✓	✓	drug_status
duration_in_days	bigint	✓	✓	course_duration_in_days
fhir_medication_status	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
fhir_medication_intent	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
effective_date	timestamp(6) with time zone	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
most_recent_issue_record_id	bigint	✗	✓
most_recent_issue_record_uuid	varchar	✗	✓
emis_mostrecent_issue_date	timestamp(6) with time zone	✓	✓	most_recent_issue_datetime
most_recent_issue_method_id	bigint	✗	✓
emis_mostrecent_issue_method	varchar	✓	✓	most_recent_issue_method_description
prescription_type_id	bigint	✗	✓
emis_prescription_type	varchar	✓	✓	prescription_type_description
nhs_prescription_type	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
expiry_date	timestamp(6) with time zone	✓	✓	expiry_datetime
max_nextissue_days	bigint	✓	✓	max_next_issue_days
min_nextissue_days	bigint	✓	✓	min_next_issue_days
number_authorised	bigint	✓	✓	number_of_issues_authorised
number_of_issues	bigint	✓	✓
drug_record_organisation_id	bigint	✗	✓
drug_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
drug_record_organisation_uuid	varchar	✗	✓
patient_text	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_patient_id	bigint	✓	✓	patient_id
patient_uuid	varchar	✗	✓
pharmacy_text	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
prescribed_as_contraceptive_flag	boolean	✓	✓	is_prescribed_as_contraceptive
privately_prescribed_flag	boolean	✓	✓	is_privately_prescribed
quantity	decimal(9, 3)	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓	availability_datetime
registration_guid	varchar	✓	✓	patient_guid
registration_ods_code	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
review_date	date	✓	✓
emis_original_term	varchar	✓	✓	original_term
local_mixture_id	bigint	✗	✓
local_mixture_name	varchar	✗	✓
sensitive_flag	boolean	✓	✓	is_sensitive
cancellation_date	timestamp(6) with time zone	✓	✓	cancellation_datetime
quantity_unit_of_measure_id	bigint	✗	✓
uom	varchar	✓	✓	quantity_unit
_execution_date	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
organisation	varchar	✓	✓
exa_prescription_guid	varchar	✓	✗
exa_mostrecent_issue_date	varchar	✓	✗
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
other_code_system	varchar	✓	✗
other_code	varchar	✓	✗
other_display	varchar	✓	✗
regular_patient_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
confidential_patient_flag	boolean	✓	✗

Olympus

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✓	✓		Renamed from deleted in V1
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓	drug_record_guid
exa_drug_guid	varchar	✓	✓	drug_record_uuid
pseudo_registration_guid	varchar	✓	✓	patient_guid	hashed
pseudo_patient_uuid	varchar	✗	✓	patient_uuid	hashed
drug_record_organisation_id	bigint	✗	✓
drug_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
drug_record_organisation_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
effective_date	date	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
entered_date	date	✓	✓	availability_datetime
entered_time	varchar	✓	✓	availability_datetime
emis_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓	code_id
emis_original_term	varchar	✓	✓	original_term
local_mixture_id	bigint	✗	✓
local_mixture_name	varchar	✗	✓
dose	varchar	✓	✓	dosage
quantity	decimal(9, 3)	✓	✓
quantity_unit_of_measure_id	bigint	✗	✓
uom	varchar	✓	✓	quantity_unit
prescription_type_id	bigint	✗	✓
emis_prescription_type	varchar	✓	✓	prescription_type_description
drug_active_flag	boolean	✓	✓	drug_status
cancellation_date	date	✓	✓	cancellation_datetime
number_of_issues	bigint	✓	✓
number_authorised	bigint	✓	✓	number_of_issues_authorised
confidential_flag	boolean	✓	✓	is_confidential
processing_id	bigint	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
_execution_date	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
organisation	varchar	✓	✓

Prometheus

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✓	✓		Renamed from deleted in V1
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓	drug_record_guid
exa_drug_guid	varchar	✓	✓	drug_record_uuid
pseudo_registration_guid	varchar	✓	✓	patient_guid	hashed
pseudo_patient_uuid	varchar	✗	✓	patient_uuid	hashed
drug_record_organisation_id	bigint	✗	✓
drug_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
drug_record_organisation_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
effective_date	date	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
entered_date	date	✓	✓	availability_datetime
entered_time	varchar	✓	✓	availability_datetime
emis_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓	code_id
emis_original_term	varchar	✓	✓	original_term
local_mixture_id	bigint	✗	✓
local_mixture_name	varchar	✗	✓
dose	varchar	✓	✓	dosage
quantity	decimal(9, 3)	✓	✓
quantity_unit_of_measure_id	bigint	✗	✓
uom	varchar	✓	✓	quantity_unit
prescription_type_id	bigint	✗	✓
emis_prescription_type	varchar	✓	✓	prescription_type_description
drug_active_flag	boolean	✓	✓	drug_status
cancellation_date	date	✓	✓	cancellation_datetime
number_of_issues	bigint	✓	✓
number_authorised	bigint	✓	✓	number_of_issues_authorised
confidential_flag	boolean	✓	✓	is_confidential
processing_id	bigint	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
_execution_date	varchar	✓	✓		Renamed from execution_date in V1
transform_datetime	timestamp(6) with time zone	✗	✓
organisation	varchar	✓	✓

Pseudo_Anon

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✓	✓		Renamed from deleted in V1
drug_record_id	bigint	✗	✓
drug_record_guid	varchar	✓	✓
id_type5	varchar	✓	✓	drug_record_uuid
patient_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
drug_record_organisation_id	bigint	✗	✓
drug_record_organisation_guid	varchar	✓	✓		Renamed from organisation_guid in V1
drug_record_organisation_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
effective_date	date	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
entered_date	date	✓	✓	availability_datetime
entered_time	varchar	✓	✓	availability_datetime
clinician_user_in_role_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
code_id	bigint	✓	✓
dosage	varchar	✓	✓
quantity	decimal(9, 3)	✓	✓
quantity_unit_of_measure_id	bigint	✗	✓
quantity_unit	varchar	✓	✓
problem_observation_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
prescription_type_id	bigint	✗	✓
prescription_type	varchar	✓	✓	prescription_type_description
is_active	boolean	✓	✓	drug_status
cancellation_date	date	✓	✓	cancellation_datetime
number_of_issues	bigint	✓	✓
number_of_issues_authorised	bigint	✓	✓
is_confidential	boolean	✓	✓
processing_id	bigint	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
_execution_date	varchar	✓	✓		Renamed from execution_date in V1
transform_datetime	timestamp(6) with time zone	✗	✓
organisation	varchar	✓	✓

Themis

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar	✓	✓
is_deleted	boolean	✗	✓
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓	drug_record_guid
exa_drug_guid	varchar	✓	✓	drug_record_uuid
nhs_prescribing_agency	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorisedissues_authorised_date	timestamp(6) with time zone	✓	✓	authorised_course_datetime
authorisedissues_authorising_user_in_role	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorisedissues_enteredby_user_in_role	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_authorising_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
cancellation_userinrole_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_uuid	varchar	✗	✓
authorising_user_in_role_id	bigint	✗	✓
authorising_user_in_role_uuid	varchar	✗	✓
original_authorising_user_in_role_id	bigint	✗	✓
original_authorising_user_in_role_uuid	varchar	✗	✓
authorisedissues_first_issue_date	timestamp(6) with time zone	✓	✓	first_issue_datetime
cancellation_reason	varchar	✓	✓
cancelled_by_user_in_role_id	bigint	✗	✓
cancelled_by_user_in_role_uuid	varchar	✗	✓
emis_code_id	bigint	✓	✓	code_id
confidential_flag	boolean	✓	✓	is_confidential
confidentiality_policy_id	bigint	✓	✓
dose	varchar	✓	✓	dosage
emis_medication_status	bigint	✓	✓	drug_status
duration_in_days	bigint	✓	✓	course_duration_in_days
duration_uom	varchar	✓	✓
fhir_medication_status	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
fhir_medication_intent	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
effective_date	timestamp(6) with time zone	✓	✓	effective_datetime
effective_date_precision	varchar	✓	✓	effective_datetime_precision
most_recent_issue_record_id	bigint	✗	✓
most_recent_issue_record_uuid	varchar	✗	✓
emis_mostrecent_issue_date	timestamp(6) with time zone	✓	✓	most_recent_issue_datetime
most_recent_issue_method_id	bigint	✗	✓
emis_mostrecent_issue_method	varchar	✓	✓	most_recent_issue_method_description
prescription_type_id	bigint	✗	✓
exa_mostrecent_issue_date	varchar	✓	✗
emis_prescription_type	varchar	✓	✓	prescription_type_description
nhs_prescription_type	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_uuid	varchar	✗	✓
end_date	timestamp(6) with time zone	✓	✓	expiry_datetime
max_nextissue_days	bigint	✓	✓	max_next_issue_days
min_nextissue_days	bigint	✓	✓	min_next_issue_days
number_authorised	bigint	✓	✓	number_of_issues_authorised
number_of_issues	bigint	✓	✓
drug_record_organisation_id	bigint	✗	✓
drug_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
drug_record_organisation_uuid	varchar	✗	✓
patient_text	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_patient_id	bigint	✓	✓	patient_id
patient_uuid	varchar	✗	✓
pharmacy_text	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
prescribed_as_contraceptive_flag	boolean	✓	✓	is_prescribed_as_contraceptive
privately_prescribed_flag	boolean	✓	✓	is_privately_prescribed
quantity	decimal(9, 3)	✓	✓
quantity_multiplicand	decimal(9, 3)	✓	✓
quantity_multiplier	decimal(9, 3)	✓	✓
quantity_multiplier_uom	varchar	✓	✓
quantity_representation	varchar	✓	✓
recorded_date	timestamp(6) with time zone	✓	✓	availability_datetime
registration_guid	varchar	✓	✓	patient_guid
registration_ods_code	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
reimburse_type	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
review_date	date	✓	✓
emis_original_term	varchar	✓	✓	original_term
local_mixture_id	bigint	✗	✓
local_mixture_name	varchar	✗	✓
sensitive_flag	boolean	✓	✓	is_sensitive
cancellation_date	timestamp(6) with time zone	✓	✓	cancellation_datetime
quantity_unit_of_measure_id	bigint	✗	✓
uom	varchar	✓	✓	quantity_unit
_execution_date	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
organisation	varchar	✓	✓
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
dummy_patient_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
opt_out_93c1_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
other_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
uom_dmd	varchar	✓	✗
exa_prescription_guid	varchar	✓	✗
_record_version	varchar	✓	✗
_update_date	varchar	✓	✗
_update_hour	varchar	✓	✗

Zeus

The table below presents the flavour specific schema and maps columns between core, V1, and V2. Refer to Changes in iPCV V2 for more information.

Column Name	Data Type	Data in V1	Data in V2	Core Mapping	Comments
_ingest_time	varchar		✓
is_deleted	boolean		✓
nhs_prescribing_agency	varchar		✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
drug_record_id	bigint		✓
emis_drug_guid	varchar		✓	drug_record_guid
exa_drug_guid	varchar		✓	drug_record_uuid
pseudo_registration_guid_ourea	varchar		✓	patient_guid	hashed
pseudo_patient_uuid	varchar		✓	patient_uuid	hashed
patient_organisation_id	bigint		✓
emis_registration_organisation_guid	varchar		✓	patient_organisation_guid
patient_organisation_uuid	varchar		✓
drug_record_organisation_id	bigint		✓
drug_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
drug_record_organisation_uuid	varchar		✓
authorisedissues_authorised_date	timestamp(6) with time zone		✓	authorised_course_datetime
authorisedissues_authorising_user_in_role	varchar		✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
authorisedissues_enteredby_userinole	varchar		✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_enteredby_userinrole_guid	varchar		✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
emis_authorising_userinrole_guid	varchar		✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
cancellation_userinrole_guid	varchar		✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
entered_by_user_in_role_uuid	varchar		✓
authorising_user_in_role_uuid	varchar		✓
original_authorising_user_in_role_uuid	varchar		✓
authorisedissues_first_issue_date	timestamp(6) with time zone		✓	first_issue_datetime
cancellation_reason	varchar		✓
cancelled_by_user_in_role_uuid	varchar		✓
emis_code_id	bigint		✓	code_id
confidential_flag	boolean		✓	is_confidential
confidentiality_policy_id	bigint		✓
dose	varchar		✓	dosage
emis_medication_status	bigint		✓	drug_status
duration_in_days	bigint		✓	course_duration_in_days
duration_uom	varchar		✓
fhir_medication_status	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
fhir_medication_intent	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
effective_date	timestamp(6) with time zone		✓	effective_datetime
effective_date_precision	varchar		✓	effective_datetime_precision
emis_mostrecent_issue_date	timestamp(6) with time zone		✓	most_recent_issue_datetime
most_recent_issue_method_id	bigint		✓
emis_mostrecent_issue_method	varchar		✓	most_recent_issue_method_description
exa_mostrecent_issue_date	varchar	✓	✗
prescription_type_id	bigint		✓
emis_prescription_type	varchar		✓	prescription_type_description
nhs_prescription_type	varchar		✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
end_date	timestamp(6) with time zone		✓	expiry_datetime
max_nextissue_days	bigint		✓	max_next_issue_days
min_nextissue_days	bigint		✓	min_next_issue_days
number_authorised	bigint		✓	number_of_issues_authorised
number_of_issues	bigint		✓
prescribed_as_contraceptive_flag	boolean		✓	is_prescribed_as_contraceptive
privately_prescribed_flag	boolean		✓	is_privately_prescribed
quantity	decimal(9, 3)		✓
quantity_multiplicand	decimal(9, 3)		✓
quantity_multiplier	decimal(9, 3)		✓
quantity_multiplier_uom	varchar		✓
quantity_representation	varchar		✓
recorded_date	timestamp(6) with time zone		✓	availability_datetime
registration_ods_code	varchar		✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
reimburse_type	varchar		✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
review_date	date		✓
emis_original_term	varchar		✓	original_term
local_mixture_id	bigint		✓
local_mixture_name	varchar		✓
sensitive_flag	boolean		✓	is_sensitive
cancellation_date	timestamp(6) with time zone		✓	cancellation_datetime
quantity_unit_of_measure_id	bigint		✓
uom	varchar		✓	quantity_unit
uom_dmd	varchar	✓	✗
_execution_date	varchar		✓
transform_datetime	timestamp(6) with time zone		✓
organisation	varchar		✓
_record_version	varchar	✓	✗
_update_date	varchar	✓	✗
_update_hour	varchar	✓	✗