Schema

Core

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

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

Column Name	Data Type	Description	Example / Values
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.	‘2026-08-13 05:43:50.000000 UTC’
_ingest_time	varchar	The load_datetime formatted as yyyyMMddHHmmss. This is a legacy column maintained for backward compatibility	‘20230512143015’
issue_record_id	bigint	The unique internal identifier for the issue record within an organisation.	111222333
organisation	varchar	An identifier for the source of data (an organisation) relating to a given GP practice	‘CDB-1234’
is_deleted	boolean	Indicates whether the issue record has been deleted at source.	FALSE
issue_record_guid	varchar	The GUID for the issue record within an organisation.	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
issue_record_uuid	varchar	The UUID derived from issue_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 and issued.	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’
issue_record_organisation_id	bigint	The unique internal identifier of the organisation where the drug record was prescribed and issued.	1123
issue_record_organisation_guid	varchar	The GUID of the organisation where the drug record was prescribed and issued.	‘550e8400-e29b-41d4-a716-446655440000’
issue_record_organisation_uuid	varchar	The UUID derived from issue_record_organisation_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_id	bigint	The unique internal identifier for the drug record this issue was processed for (within an organisation).	123456789
drug_record_guid	varchar	The GUID for the drug record this issue was processed for (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’
consultation_id	bigint	The unique internal identifier for the consultation record within an organisation in which the issue record was recorded.	12345
consultation_guid	varchar	The GUID for the consultation record within an organisation	‘d4e5f6a7-b8c9-7d0e-2f3a-4b5c6d7e8f9a’
consultation_uuid	varchar	The UUID derived from consultation_id and organisation, providing a stable unique identifier.	‘e5f6a7b8-c9d0-8e1f-3a4b-5c6d7e8f9a0b’
consultation_section_id	bigint	The unique internal identifier for the consultation section this record was issued from, within an organisation.	12345
consultation_section_uuid	varchar	The UUID derived from consultation_section_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	113
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’
entered_by_user_in_role_id	bigint	The unique identifier of the user who entered the issue record	645
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 issue record. Will only be populated if an issue has been cancelled.	4455
cancelled_by_user_in_role_uuid	varchar	The UUID of the user who cancelled the issue record derived from cancelled_by_user_in_role_id and organisation, providing a stable unique identifier	‘a1b2c3d4-e5f6-4a5b-9c8d-0e1f2a3b4c5d’
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’
availability_datetime	timestamp(6) with time zone	The date and time the issue 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 issue record	‘2023-09-01 09:00:00.000000 UTC’
effective_datetime_precision	varchar	Precision of the effective datetime; set to ‘YMDT’.	‘YMDT’
cancellation_datetime	timestamp(6) with time zone	Date and time the issue record was cancelled	‘2023-09-01 09:00:00.000000 UTC’
cancellation_reason	varchar	Reason for the cancellation (free text)	‘Patient request’
quantity	decimal(9, 3)	Quantity prescribed	56.000
quantity_unit	varchar	Unit of the quantity	‘tablet’
dosage	varchar	Dosage instructions for the drug record	‘One to be taken twice daily’
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’
patient_message	varchar	A message for the patient, typically used to remind them of a medication review (free text)	‘Patient Message - Ibuprofen’
pharmacy_message	varchar	A message that needs to be passed to the pharmacy (free text)	‘Pharmacy Message - Ibuprofen’
local_mixture_id	bigint	The unique identifier identifier for the local mixture prescribed	8
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 sparseley populated.	‘ADULT COUGH LINCTUS’
review_date	date	Date the prescription is due for review	‘2024-07-01’
course_duration_in_days	bigint	Course length of prescription, in days	28
consultation_source_code_id	bigint	The unique EMIS code identifier of the code describing the consultation source (e.g. GP Surgery, Telephone)	1672851000006116
consultation_source_original_term	varchar	The EMIS term for the consultation source code	‘GP Surgery’
code_id	bigint	The unique EMIS code identifier for the medication prescribed	1278741000033112
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
estimated_nhs_cost	real	Estimated NHS cost of this issue	4.5
issue_method_id	bigint	Internal identifier for the issue method	12
issue_method_description	varchar	Method by which the issue was dispensed	‘Electronic Repeat Dispensing’
quantity_unit_of_measure_id	bigint	Internal identifier for the quantity unit of measure	120
quantity_representation	varchar	Complete representation of the quantity prescribed, combining quantity and unit. representation	‘21 tablet’
quantity_multiplicand	decimal(9, 3)	Multiplicand component of quantity	21.000
quantity_multiplier	decimal(9, 3)	Multiplier component of quantity	1.000
quantity_multiplier_uom	varchar	Unit of measure for the multiplier	‘pack’
is_cancelled	boolean	Indicates whether the issue has been cancelled	FALSE
is_privately_prescribed	boolean	Indicates whether the drug was privately prescribed	TRUE
is_prescribed_as_contraceptive	boolean	Indicates whether the drug was prescribed as a contraceptive	FALSE
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
confidentiality_policy_id	bigint	Identifier of the applied confidentiality policy	-1
is_confidential	boolean	Indicates whether the issue record is confidential. This is based on confidentiality policy set against the patient / drug record /issue 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	✗	✓
issue_record_id	bigint	✗	✓
emis_issue_guid	varchar	✓	✓	issue_record_guid
exa_issue_guid	varchar	✓	✓	issue_record_uuid
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.
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	✗	✓
cancelled_by_user_in_role_id	bigint	✗	✓
cancelled_by_user_in_role_uuid	varchar	✗	✓
cancellation_reason	varchar	✓	✓
is_cancelled	boolean	✗	✓
emis_code_id	bigint	✓	✓	code_id
confidential_flag	boolean	✓	✓	is_confidential
confidentiality_policy_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓	consultation_source_code_id
consultation_source_emis_original_term	varchar	✓	✓	consultation_source_original_term
dose	varchar	✓	✓	dosage
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
issue_method_id	bigint	✗	✓
emis_issue_method	varchar	✓	✓	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	✗	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓	consultation_guid
exa_encounter_guid	varchar	✓	✓	consultation_uuid
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
estimated_nhs_cost	real	✓	✓
max_nextissue_days	bigint	✓	✓	max_next_issue_days
min_nextissue_days	bigint	✓	✓	min_next_issue_days
issue_record_organisation_id	bigint	✗	✓
issue_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
issue_record_organisation_uuid	varchar	✗	✓
patient_message	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
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_message	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
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	✓	✗

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	✗	✓
issue_record_id	bigint	✗	✓
emis_issue_guid	varchar	✓	✓	issue_record_guid
exa_issue_guid	varchar	✓	✓	issue_record_uuid
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	✗	✓
effective_date	timestamp(6) with time zone	✓	✓	effective_datetime
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.
cancellation_date	timestamp(6) with time zone	✓	✓	cancellation_datetime
emis_code_id	bigint	✓	✓	code_id
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	✗	✓
issue_record_id	bigint	✗	✓
emis_issue_guid	varchar	✓	✓	issue_record_guid
exa_issue_guid	varchar	✓	✓	issue_record_uuid
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.
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	✗	✓
cancelled_by_user_in_role_id	bigint	✗	✓
cancelled_by_user_in_role_uuid	varchar	✗	✓
cancellation_reason	varchar	✓	✓
is_cancelled	boolean	✗	✓
emis_code_id	bigint	✓	✓	code_id
confidential_flag	boolean	✓	✓	is_confidential
confidentiality_policy_id	bigint	✓	✓
consultation_source_emis_code_id	bigint	✓	✓	consultation_source_code_id
consultation_source_emis_original_term	varchar	✓	✓	consultation_source_original_term
dose	varchar	✓	✓	dosage
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
issue_method_id	bigint	✗	✓
emis_issue_method	varchar	✓	✓	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	✗	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓	consultation_guid
exa_encounter_guid	varchar	✓	✓	consultation_uuid
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
estimated_nhs_cost	real	✓	✓
max_nextissue_days	bigint	✓	✓	max_next_issue_days
min_nextissue_days	bigint	✓	✓	min_next_issue_days
issue_record_organisation_id	bigint	✗	✓
issue_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
issue_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	✓	✗
authorisedissues_authorised_date	timestamp(6) with time zone	✓	✗
authorisedissues_authorising_user_in_role	varchar	✓	✗
authorisedissues_enteredby_userinole	varchar	✓	✗
authorisedissues_first_issue_date	timestamp(6) with time zone	✓	✗
confidential_patient_flag	boolean	✓	✗
emis_medication_status	varchar	✓	✗
dummy_patient_flag	boolean	✓	✗
emis_mostrecent_issue_date	timestamp(6) with time zone	✓	✗
emis_mostrecent_issue_method	varchar	✓	✗
end_date	timestamp(6) with time zone	✓	✗
exa_prescription_guid	varchar	✓	✗
exa_mostrecent_issue_date	timestamp(6) with time zone	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
number_authorised	bigint	✓	✗
number_of_issues	bigint	✓	✗
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	bigint	✓	✗
snomed_description_id	bigint	✓	✗
uom_dmd	varchar	✓	✗

Hermes

The table below presents the flavour specific schema.

Column Name	Data Type	Core Mapping
is_deleted	boolean
pseudo_issue_record_uuid	varchar	issue_record_uuid
pseudo_patient_uuid	varchar	patient_uuid
pseudo_issue_record_organisation_uuid	varchar	issue_record_organisation_uuid
pseudo_patient_organisation_uuid	varchar	patient_organisation_uuid
pseudo_drug_record_uuid	varchar	drug_record_uuid
pseudo_consultation_uuid	varchar	consultation_uuid
pseudo_consultation_section_uuid	varchar	consultation_section_uuid
prescription_type_id	bigint
prescription_type_description	varchar
availability_datetime	timestamp(6) with time zone
effective_datetime	timestamp(6) with time zone
effective_datetime_precision	varchar
cancellation_datetime	timestamp(6) with time zone
quantity	decimal(9, 3)
quantity_unit	varchar
dosage	varchar
original_term	varchar
local_mixture_id	bigint
local_mixture_name	varchar
review_date	date
course_duration_in_days	bigint
consultation_source_code_id	bigint
consultation_source_original_term	varchar
code_id	bigint
min_next_issue_days	bigint
max_next_issue_days	bigint
estimated_nhs_cost	real
issue_method_id	bigint
issue_method_description	varchar
quantity_unit_of_measure_id	bigint
quantity_representation	varchar
quantity_multiplicand	decimal(9, 3)
quantity_multiplier	decimal(9, 3)
quantity_multiplier_uom	varchar
is_cancelled	boolean
is_privately_prescribed	boolean
is_prescribed_as_contraceptive	boolean
is_sensitive	boolean
confidentiality_policy_id	bigint
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	✗	✓
issue_record_id	bigint	✗	✓
emis_issue_guid	varchar	✓	✓	issue_record_guid
exa_issue_guid	varchar	✓	✓	issue_record_uuid
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.
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	✗	✓
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	✓	✓
consultation_source_emis_code_id	bigint	✓	✓	consultation_source_code_id
consultation_source_emis_original_term	varchar	✓	✓	consultation_source_original_term
dose	varchar	✓	✓	dosage
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
issue_method_id	bigint	✗	✓
emis_issue_method	varchar	✓	✓	issue_method_description
emis_mostrecent_issue_method	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
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	✗	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓	consultation_guid
exa_encounter_guid	varchar	✓	✓	consultation_uuid
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
estimated_nhs_cost	real	✓	✓
max_nextissue_days	bigint	✓	✓	max_next_issue_days
min_nextissue_days	bigint	✓	✓	min_next_issue_days
issue_record_organisation_id	bigint	✗	✓
issue_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
issue_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.
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
is_cancelled	boolean	✗	✓
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	✓	✗
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
other_code_system	varchar	✓	✗
other_code	varchar	✓	✗
other_display	varchar	✓	✗
emis_medication_status	varchar	✓	✗
pharmacy_text	varchar	✓	✗
pharmacy_message	varchar	✓	✗
patient_text	varchar	✓	✗
patient_message	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
issue_record_id	bigint	✗	✓
emis_issue_guid	varchar	✓	✓	issue_record_guid
exa_issue_guid	varchar	✓	✓	issue_record_uuid
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓	drug_record_guid
drug_record_uuid	varchar	✗	✓
pseudo_registration_guid	varchar	✓	✓	patient_guid	hashed
pseudo_patient_uuid	varchar	✗	✓	patient_uuid	hashed
issue_record_organisation_id	bigint	✗	✓
emis_medication_organisation_guid	varchar	✓	✓	issue_record_organisation_guid
issue_record_organisation_uuid	varchar	✗	✓
patient_organisation_id	bigint	✗	✓
emis_registration_organisation_guid	varchar	✓	✓	patient_organisation_guid
patient_organisation_guid	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
duration_in_days	bigint	✓	✓	course_duration_in_days
estimated_nhs_cost	real	✓	✓
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
issue_record_id	bigint	✗	✓
emis_issue_guid	varchar	✓	✓	issue_record_guid
exa_issue_guid	varchar	✓	✓	issue_record_uuid
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓	drug_record_guid
drug_record_uuid	varchar	✗	✓
pseudo_registration_guid	varchar	✓	✓	patient_guid	hashed
pseudo_patient_uuid	varchar	✗	✓	patient_uuid	hashed
issue_record_organisation_id	bigint	✗	✓
issue_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
issue_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
duration_in_days	bigint	✓	✓	course_duration_in_days
estimated_nhs_cost	real	✓	✓
confidential_flag	boolean	✓	✓	is_confidential
processing_id	bigint	✓	✓		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	✓	✓		Renamed from execution_date in V1
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
issue_record_id	bigint	✗	✓
issue_record_guid	varchar	✓	✓
id_type5	varchar	✓	✓	issue_record_uuid
drug_record_id	bigint	✗	✓
drug_record_guid	varchar	✓	✓
drug_record_uuid	varchar	✗	✓
patient_guid	varchar	✓	✓
patient_uuid	varchar	✗	✓
issue_record_organisation_id	bigint	✗	✓
issue_record_organisation_guid	varchar	✓	✓		Renamed from organisation_guid in V1
issue_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	✓	✓
prescription_type_id	bigint	✗	✓
prescription_type_description	varchar	✗	✓
problem_observation_guid	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
course_duration_in_days	bigint	✓	✓
estimated_nhs_cost	real	✓	✓
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	✗	✓
issue_record_id	bigint	✗	✓
emis_issue_guid	varchar	✓	✓	issue_record_guid
exa_issue_guid	varchar	✓	✓	issue_record_uuid
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.
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	✗	✓
cancellation_reason	varchar	✓	✓
is_cancelled	boolean	✗	✓
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	✓	✓
consultation_source_emis_code_id	bigint	✓	✓	consultation_source_code_id
consultation_source_emis_original_term	varchar	✓	✓	consultation_source_original_term
dose	varchar	✓	✓	dosage
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
issue_method_id	bigint	✗	✓
emis_issue_method	varchar	✓	✓	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	✗	✓
consultation_id	bigint	✗	✓
emis_encounter_guid	varchar	✓	✓	consultation_guid
exa_encounter_guid	varchar	✓	✓	consultation_uuid
consultation_section_id	bigint	✗	✓
consultation_section_uuid	varchar	✗	✓
estimated_nhs_cost	real	✓	✓
max_nextissue_days	bigint	✓	✓	max_next_issue_days
min_nextissue_days	bigint	✓	✓	min_next_issue_days
issue_record_organisation_id	bigint	✗	✓
issue_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
issue_record_organisation_uuid	varchar	✗	✓
patient_message	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
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_message	varchar	✓	✓		Always NULL as it is deprecated in v2. Refer changes in v2 for more details.
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	✓	✓
opt_out_93c1_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
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	✓	✗
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		✓
issue_record_id	bigint		✓
emis_issue_guid	varchar		✓	issue_record_guid
exa_issue_guid	varchar		✓	issue_record_uuid
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		✓
issue_record_organisation_id	bigint		✓
issue_record_organisation_guid	varchar	✓	✓		Renamed from emis_medication_organisation_guid in V1
issue_record_organisation_uuid	varchar		✓
nhs_prescribing_agency	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		✓
cancelled_by_user_in_role_uuid	varchar		✓
cancellation_reason	varchar		✓
is_cancelled	boolean		✓
emis_code_id	bigint		✓	code_id
confidential_flag	boolean		✓	is_confidential
confidentiality_policy_id	bigint		✓
consultation_source_emis_code_id	bigint		✓	consultation_source_code_id
consultation_source_emis_original_term	varchar		✓	consultation_source_original_term
dose	varchar		✓	dosage
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
issue_method_id	bigint		✓
emis_issue_method	varchar		✓	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.
consultation_id	bigint		✓
emis_encounter_guid	varchar		✓	consultation_guid
exa_encounter_guid	varchar		✓	consultation_uuid
consultation_section_id	bigint		✓
consultation_section_uuid	varchar		✓
estimated_nhs_cost	real		✓
max_nextissue_days	bigint		✓	max_next_issue_days
min_nextissue_days	bigint		✓	min_next_issue_days
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		✓
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	✓	✗