Schema

Raw

Column Name	Data Type	Description	Example
_ingest_time	timestamp	The datetime the record was ingested into the platform	’2024-01-15 03:00:00’
is_deleted	boolean	If this record should be considered soft deleted	FALSE
drug_record_id	bigint	PK — EMIS internal identifier for the drug record	123456789
organisation	varchar	The organisation that this data was replicated from	’A12345’
drug_record_guid	varchar	Source EMIS GUID for the drug record	’xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx’
drug_record_uuid	varchar	UUID5 generated from drug_record_id + organisation	’xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx’
patient_id	bigint	EMIS internal patient identifier	987654321
patient_guid	varchar	Source EMIS patient GUID (registration_guid)	‘xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx’
patient_organisation_id	bigint	EMIS internal organisation identifier for the patient’s registration	112233
patient_organisation_guid	varchar	EMIS GUID for the patient’s registered organisation	’xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx’
drug_record_organisation_guid	varchar	EMIS GUID of the organisation that owns the drug record	’xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx’
authorising_user_in_role_id	bigint	FK — user-in-role id of the authorising clinician	44556677
original_authorising_user_in_role_id	bigint	FK — user-in-role id of the original authorising clinician	44556677
entered_by_user_in_role_id	bigint	FK — user-in-role id of the person who entered the record	44556677
cancelled_by_user_in_role_id	bigint	FK — user-in-role id of the person who cancelled the record	44556677
cancellation_reason	varchar	Free-text reason for cancellation	’Patient request’
cancellation_datetime	timestamp	Date and time the drug record was cancelled	’2024-06-01 09:00:00’
availability_datetime	timestamp	Date and time the record became available / recorded date	’2024-01-15 00:00:00’
effective_datetime	timestamp	Clinical effective date and time of the drug record	’2024-01-15 00:00:00’
effective_datetime_precision	varchar	Precision of the effective datetime (hardcoded YMDT)	‘YMDT’
expiry_datetime	timestamp	Date and time the prescription expires	’2024-07-15 00:00:00’
first_issue_datetime	timestamp	Date and time of the first issue against this drug record	’2024-01-20 00:00:00’
authorised_course_datetime	timestamp	Date and time the course was authorised	’2024-01-15 00:00:00’
review_date	date	Date the prescription is due for review	’2024-07-01’
original_term	varchar	Original EMIS term/description for the drug	’Amoxicillin 500mg capsules’
local_mixture_name	varchar	Name of a locally prepared mixture, if applicable	’Local mixture A’
drug_status	integer	Source status code (1 = active)	1
prescription_type_description	varchar	Derived prescription type: acute, repeat, repeat-dispensing, automatic	’repeat’
dosage	varchar	Dosage instructions	’One to be taken twice daily’
course_duration_in_days	integer	Prescribed course length in days	28
quantity	double	Quantity prescribed	56.0
quantity_unit	varchar	Unit of the quantity	’tablet’
quantity_representation	varchar	Human-readable quantity representation	’56 tablet’
quantity_multiplicand	double	Multiplicand component of quantity	56.0
quantity_multiplier	double	Multiplier component of quantity	1.0
quantity_multiplier_uom	varchar	Unit of measure for the multiplier	’pack’
number_of_issues	integer	Number of times this drug record has been issued	3
number_of_issues_authorised	integer	Number of issues authorised on this repeat prescription	12
most_recent_issue_record_id	bigint	FK — id of the most recent issue record	777888999
most_recent_issue_method_description	varchar	Description of the most recent issue method	’Electronic Repeat Dispensing’
most_recent_issue_datetime	timestamp	Date and time of the most recent issue	’2024-03-10 00:00:00’
code_id	bigint	FK — EMIS code identifier for the drug	123456789
min_next_issue_days	integer	Minimum number of days before the next issue can be made	14
max_next_issue_days	integer	Maximum number of days before the next issue must be made	28
is_prescribed_as_contraceptive	boolean	Whether the drug was prescribed as a contraceptive	FALSE
is_privately_prescribed	boolean	Whether the drug was privately prescribed	FALSE
is_sensitive	boolean	Whether the record is marked as sensitive	FALSE
was_sensitive	boolean	Whether the record was previously marked sensitive	FALSE
confidentiality_policy_id	integer	Identifier of the applied confidentiality policy	1
is_confidential	boolean	Whether the record is marked confidential	FALSE
was_confidential	boolean	Whether the record was previously marked confidential	FALSE
transform_datetime	timestamp(6) with time zone	The datetime that the data was made available in the model with a relevant change	’2024-01-15 03:00:05.000000 UTC’
_execution_date	varchar	Formatted transform datetime for versioning	’20240115030005’

---

Vanilla

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	timestamp	✓	✓
is_deleted	boolean	✗	✓
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓
exa_drug_guid	varchar	✓	✓
registration_guid	varchar	✓	✓
emis_patient_id	bigint	✓	✓
emis_medication_organisation_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
nhs_prescribing_agency	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_code_id	bigint	✓	✓
effective_date	timestamp	✓	✓
effective_date_precision	varchar	✓	✓
end_date	timestamp	✓	✓
recorded_date	timestamp	✓	✓
emis_original_term	varchar	✓	✓
emis_prescription_type	varchar	✓	✓
nhs_prescription_type	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
dose	varchar	✓	✓
uom	varchar	✓	✓
quantity	double	✓	✓
quantity_representation	varchar	✓	✓
quantity_multiplicand	double	✓	✓
quantity_multiplier	double	✓	✓
quantity_multiplier_uom	varchar	✓	✓
duration_in_days	integer	✓	✓
duration_uom	varchar	✓	✓
emis_medication_status	integer	✓	✓
number_of_issues	integer	✓	✓
number_authorised	integer	✓	✓
cancellation_date	timestamp	✓	✓
cancellation_reason	varchar	✓	✓
cancellation_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
cancelled_by_user_in_role_id	bigint	✗	✓
authorising_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
original_authorising_user_in_role_id	bigint	✗	✓
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_authorised_date	timestamp	✓	✓
authorisedissues_authorising_user_in_role	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_enteredby_userinrole	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_first_issue_date	timestamp	✓	✓
emis_mostrecent_issue_date	timestamp	✓	✓
emis_mostrecent_issue_method	varchar	✓	✓
review_date	date	✓	✓
min_nextissue_days	integer	✓	✓
max_nextissue_days	integer	✓	✓
prescribed_as_contraceptive_flag	boolean	✓	✓
privately_prescribed_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
confidential_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
confidentiality_policy_id	integer	✓	✓
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	✓	✗
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
reimburse_type	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
patient_text	varchar	✓	✓
pharmacy_text	varchar	✓	✓
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
other_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
fhir_medication_status	varchar	✓	✗
fhir_medication_intent	varchar	✓	✗
uom_dmd	varchar	✓	✗
local_mixture_name	varchar	✗	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓

---

Apollo

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	timestamp	✓	✓
is_deleted	boolean	✗	✓
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓
exa_drug_guid	varchar	✓	✓
registration_guid	varchar	✓	✓
duration_in_days	integer	✓	✓
emis_code_id	bigint	✓	✓
effective_date	timestamp	✓	✓
expiry_date	timestamp	✓	✓
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorising_user_in_role_id	bigint	✗	✓
quantity	double	✓	✓
uom	varchar	✓	✓
dose	varchar	✓	✓
quantity_representation	varchar	✓	✓
quantity_multiplicand	double	✓	✓
quantity_multiplier	double	✓	✓
quantity_multiplier_uom	varchar	✓	✓
nhs_prescription_type	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_prescription_type	varchar	✗	✓
active	boolean	✓	✓
number_of_issues	integer	✓	✓
number_authorised	integer	✓	✓
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
snomed_concept_id	bigint	✓	✗
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
organisation	varchar	✓	✓

---

Artemis

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	timestamp	✓	✓
is_deleted	boolean	✗	✓
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓
exa_drug_guid	varchar	✓	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
emis_medication_organisation_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
nhs_prescribing_agency	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_code_id	bigint	✓	✓
effective_date	timestamp	✓	✓
effective_date_precision	varchar	✓	✓
end_date	timestamp	✓	✓
recorded_date	timestamp	✓	✓
emis_original_term	varchar	✓	✓
emis_prescription_type	varchar	✓	✓
nhs_prescription_type	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
dose	varchar	✓	✓
uom	varchar	✓	✓
quantity	double	✓	✓
duration_in_days	integer	✓	✓
duration_uom	varchar	✓	✓
emis_medication_status	integer	✓	✓
number_of_issues	integer	✓	✓
number_authorised	integer	✓	✓
cancellation_date	timestamp	✓	✓
cancellation_reason	varchar	✓	✓
cancellation_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
cancelled_by_user_in_role_id	bigint	✗	✓
authorising_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
original_authorising_user_in_role_id	bigint	✗	✓
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_authorised_date	timestamp	✓	✓
authorisedissues_authorising_user_in_role	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_enteredby_userinrole	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_first_issue_date	timestamp	✓	✓
emis_mostrecent_issue_date	timestamp	✓	✓
emis_mostrecent_issue_method	varchar	✓	✓
review_date	date	✓	✓
min_nextissue_days	integer	✓	✓
max_nextissue_days	integer	✓	✓
prescribed_as_contraceptive_flag	boolean	✓	✓
privately_prescribed_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
confidential_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
confidentiality_policy_id	integer	✓	✓
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	✓	✗
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
other_display	varchar	✓	✗
fhir_medication_status	varchar	✓	✗
fhir_medication_intent	varchar	✓	✗
uom_dmd	varchar	✓	✗
exa_prescription_guid	varchar	✓	✗
local_mixture_name	varchar	✗	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
organisation	varchar	✓	✓

---

Hestia

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	timestamp	✓	✓
is_deleted	boolean	✗	✓
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓
exa_drug_guid	varchar	✓	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
emis_medication_organisation_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorising_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
original_authorising_user_in_role_id	bigint	✗	✓
cancelled_by_user_in_role_id	bigint	✗	✓
emis_code_id	bigint	✓	✓
effective_date	timestamp	✓	✓
effective_date_precision	varchar	✓	✓
expiry_date	timestamp	✓	✓
recorded_date	timestamp	✓	✓
emis_original_term	varchar	✓	✓
emis_prescription_type	varchar	✓	✓
nhs_prescription_type	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
nhs_prescribing_agency	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
dose	varchar	✓	✓
uom	varchar	✓	✓
quantity	double	✓	✓
duration_in_days	integer	✓	✓
emis_medication_status	integer	✓	✓
number_of_issues	integer	✓	✓
number_authorised	integer	✓	✓
cancellation_date	timestamp	✓	✓
cancellation_reason	varchar	✓	✓
cancellation_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_authorised_date	timestamp	✓	✓
authorisedissues_authorising_user_in_role	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_enteredby_userinrole	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_first_issue_date	timestamp	✓	✓
emis_mostrecent_issue_date	timestamp	✓	✓
emis_mostrecent_issue_method	varchar	✓	✓
review_date	date	✓	✓
min_nextissue_days	integer	✓	✓
max_nextissue_days	integer	✓	✓
prescribed_as_contraceptive_flag	boolean	✓	✓
privately_prescribed_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
confidential_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
confidentiality_policy_id	integer	✓	✓
regular_patient_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
non_regular_and_current_active_flag	boolean	✓	✗
pharmacy_text	varchar	✓	✓
patient_text	varchar	✓	✓
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
other_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
fhir_medication_status	varchar	✓	✗
fhir_medication_intent	varchar	✓	✗
exa_prescription_guid	varchar	✓	✗
local_mixture_name	varchar	✗	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
organisation	varchar	✓	✓

---

Themis

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	timestamp	✓	✓
is_deleted	boolean	✗	✓
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓
exa_drug_guid	varchar	✓	✓
emis_patient_id	bigint	✓	✓
registration_guid	varchar	✓	✓
emis_medication_organisation_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
nhs_prescribing_agency	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_code_id	bigint	✓	✓
effective_date	timestamp	✓	✓
effective_date_precision	varchar	✓	✓
end_date	timestamp	✓	✓
recorded_date	timestamp	✓	✓
emis_original_term	varchar	✓	✓
emis_prescription_type	varchar	✓	✓
nhs_prescription_type	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
dose	varchar	✓	✓
uom	varchar	✓	✓
quantity	double	✓	✓
quantity_representation	varchar	✓	✓
quantity_multiplicand	double	✓	✓
quantity_multiplier	double	✓	✓
quantity_multiplier_uom	varchar	✓	✓
duration_in_days	integer	✓	✓
duration_uom	varchar	✓	✓
emis_medication_status	integer	✓	✓
number_of_issues	integer	✓	✓
number_authorised	integer	✓	✓
cancellation_date	timestamp	✓	✓
cancellation_reason	varchar	✓	✓
cancellation_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
cancelled_by_user_in_role_id	bigint	✗	✓
authorising_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
original_authorising_user_in_role_id	bigint	✗	✓
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_authorised_date	timestamp	✓	✓
authorisedissues_authorising_user_in_role	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_enteredby_userinrole	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_first_issue_date	timestamp	✓	✓
emis_mostrecent_issue_date	timestamp	✓	✓
emis_mostrecent_issue_method	varchar	✓	✓
review_date	date	✓	✓
min_nextissue_days	integer	✓	✓
max_nextissue_days	integer	✓	✓
prescribed_as_contraceptive_flag	boolean	✓	✓
privately_prescribed_flag	boolean	✓	✓
sensitive_flag	boolean	✓	✓
confidential_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
sensitive_patient_flag	boolean	✓	✗
confidentiality_policy_id	integer	✓	✓
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	✓	✗
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
reimburse_type	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
patient_text	varchar	✓	✓
pharmacy_text	varchar	✓	✓
snomed_concept_id	bigint	✓	✗
snomed_description_id	bigint	✓	✗
other_code	varchar	✓	✗
other_code_system	varchar	✓	✗
other_display	varchar	✓	✗
fhir_medication_status	varchar	✓	✗
fhir_medication_intent	varchar	✓	✗
uom_dmd	varchar	✓	✗
exa_prescription_guid	varchar	✓	✗
local_mixture_name	varchar	✗	✓
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
organisation	varchar	✓	✓

---

Zeus

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	timestamp	✓	✓
is_deleted	boolean	✓	✓
nhs_prescribing_agency	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
drug_record_id	bigint	✓	✓
emis_drug_guid	varchar	✓	✓
exa_drug_guid	varchar	✓	✓
authorisedissues_authorised_date	timestamp	✓	✓
authorisedissues_authorising_user_in_role	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorisedissues_enteredby_userinrole	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
cancellation_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
entered_by_user_in_role_id	bigint	✓	✓
authorising_user_in_role_id	bigint	✓	✓
original_authorising_user_in_role_id	bigint	✓	✓
authorisedissues_first_issue_date	timestamp	✓	✓
cancellation_reason	varchar	✓	✓
cancelled_by_user_in_role_id	bigint	✓	✓
emis_code_id	bigint	✓	✓
confidential_flag	boolean	✓	✓
confidential_patient_flag	boolean	✓	✗
confidentiality_policy_id	integer	✓	✓
dose	varchar	✓	✓
emis_medication_status	integer	✓	✓
dummy_patient_flag	boolean	✓	✗
duration_in_days	integer	✓	✓
duration_uom	varchar	✓	✓
effective_date	timestamp	✓	✓
effective_date_precision	varchar	✓	✓
emis_mostrecent_issue_date	timestamp	✓	✓
emis_mostrecent_issue_method	varchar	✓	✓
emis_prescription_type	varchar	✓	✓
nhs_prescription_type	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_registration_organisation_guid	varchar	✓	✓
end_date	timestamp	✓	✓
max_nextissue_days	integer	✓	✓
min_nextissue_days	integer	✓	✓
number_authorised	integer	✓	✓
number_of_issues	integer	✓	✓
opt_out_93c1_flag	boolean	✓	✗
opt_out_9nd19nu09nu4_flag	boolean	✓	✗
opt_out_9nd19nu0_flag	boolean	✓	✗
opt_out_9nu0_flag	boolean	✓	✗
emis_medication_organisation_guid	varchar	✓	✓
patient_text	varchar	✓	✓
emis_patient_id	bigint	✓	✓
pharmacy_text	varchar	✓	✓
prescribed_as_contraceptive_flag	boolean	✓	✓
privately_prescribed_flag	boolean	✓	✓
quantity	double	✓	✓
quantity_multiplicand	double	✓	✓
quantity_multiplier	double	✓	✓
quantity_multiplier_uom	varchar	✓	✓
quantity_representation	varchar	✓	✓
recorded_date	timestamp	✓	✓
pseudo_registration_guid_ourea	varchar	✓	✓	Zeus-specific hashed patient identifier using Ourea algorithm
registration_ods_code	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
non_regular_and_current_active_flag	boolean	✓	✗
regular_and_current_active_flag	boolean	✓	✗
regular_current_active_and_inactive_flag	boolean	✓	✗
regular_patient_flag	boolean	✓	✗
reimburse_type	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
review_date	date	✓	✓
emis_original_term	varchar	✓	✓
local_mixture_name	varchar	✓	✓
sensitive_flag	boolean	✓	✓
sensitive_patient_flag	boolean	✓	✗
cancellation_date	timestamp	✓	✓
uom	varchar	✓	✓
_execution_date	varchar	✓	✓
transform_datetime	timestamp(6) with time zone	✗	✓
organisation	varchar	✓	✓

---

Pseudo_Anon

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	timestamp	✓	✓
is_deleted	boolean	✗	✓
drug_record_id	bigint	✗	✓
drug_record_guid	varchar	✗	✓
drug_record_uuid	varchar	✗	✓
id_type5	varchar	✓	✓
patient_guid	varchar	✓	✓
organisation_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
effective_date	date	✓	✓
effective_date_precision	varchar	✓	✓
entered_date	date	✓	✓
entered_time	varchar	✓	✓
clinician_user_in_role_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
entered_by_user_in_role_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorising_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
code_id	bigint	✓	✓
dosage	varchar	✓	✓
quantity	double	✓	✓
quantity_unit	varchar	✓	✓
problem_observation_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
prescription_type	varchar	✓	✓
is_active	boolean	✓	✓
cancellation_date	date	✓	✓
number_of_issues	integer	✓	✓
number_of_issues_authorised	integer	✓	✓
is_confidential	boolean	✓	✓
processing_id	bigint	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
organisation	varchar	✓	✓

---

Prometheus

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	timestamp	✓	✓
is_deleted	boolean	✗	✓
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓
exa_drug_guid	varchar	✓	✓
pseudo_registration_guid	varchar	✓	✓	Hashed patient identifier
emis_medication_organisation_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
effective_date	date	✓	✓
effective_date_precision	varchar	✓	✓
entered_date	date	✓	✓
entered_time	varchar	✓	✓
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorising_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
emis_code_id	bigint	✓	✓
emis_original_term	varchar	✓	✓
local_mixture_name	varchar	✗	✓
dose	varchar	✓	✓
quantity	double	✓	✓
uom	varchar	✓	✓
emis_prescription_type	varchar	✓	✓
drug_active_flag	boolean	✓	✓
cancellation_date	date	✓	✓
number_of_issues	integer	✓	✓
number_authorised	integer	✓	✓
confidential_flag	boolean	✓	✓
processing_id	bigint	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
organisation	varchar	✓	✓

---

Olympus

Column Name	Data Type	Data Exists in v1	Data Exists in v2	Comments
_ingest_time	timestamp	✓	✓
is_deleted	boolean	✗	✓
drug_record_id	bigint	✗	✓
emis_drug_guid	varchar	✓	✓
exa_drug_guid	varchar	✓	✓
pseudo_registration_guid	varchar	✓	✓	Hashed patient identifier
emis_medication_organisation_guid	varchar	✓	✓
emis_registration_organisation_guid	varchar	✓	✓
effective_date	date	✓	✓
effective_date_precision	varchar	✓	✓
entered_date	date	✓	✓
entered_time	varchar	✓	✓
emis_authorising_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
emis_enteredby_userinrole_guid	varchar	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
authorising_user_in_role_id	bigint	✗	✓
entered_by_user_in_role_id	bigint	✗	✓
emis_code_id	bigint	✓	✓
emis_original_term	varchar	✓	✓
local_mixture_name	varchar	✗	✓
dose	varchar	✓	✓
quantity	double	✓	✓
uom	varchar	✓	✓
emis_prescription_type	varchar	✓	✓
drug_active_flag	boolean	✓	✓
cancellation_date	date	✓	✓
number_of_issues	integer	✓	✓
number_authorised	integer	✓	✓
confidential_flag	boolean	✓	✓
processing_id	bigint	✓	✓	Always NULL as it is deprecated in v2. Refer definitions/universal improvements for more details.
transform_datetime	timestamp(6) with time zone	✗	✓
_execution_date	varchar	✓	✓
organisation	varchar	✓	✓