sig

SACT Drug Exposure

• Value copied from Regimen

• Regimen Specific combination of drugs and their scheduled administration plan used to treat a patient’s cancer Regimen

	select
		distinct
		replace(NHS_Number, ' ', '') as NHS_Number,
		Regimen,
		lower(Drug_Name) as Drug_Name,
		Actual_Dose_Per_Administration,
		Administration_Measurement_Per_Actual_Dose,
		Administration_Date
	from omop_staging.sact_staging
	

Comment or raise an issue for this mapping.

Oxford Prescribing Drug Exposure

• Value copied from order_detail_display_line

• order_detail_display_line All the prescribed drug item details as shown in the order screen as selected by the clinician

select
	patient_identifier_Value,
	beg_dt_tm,
	end_dt_tm,
	lower(replace(catalog, 'zzz', '')) as catalog,
	lower(order_mnemonic) as order_mnemonic,
	order_detail_display_line,
	lower(rxroute) as rxroute,
	strengthdoseunit,
	strengthdose,
	EVENT_ID
from ##duckdb_source##

Comment or raise an issue for this mapping.

Oxford Prescribing Drug Exposure (with Snomed)

• Value copied from order_detail_display_line

• order_detail_display_line All the prescribed drug item details as shown in the order screen as selected by the clinician

select
	patient_identifier_Value,
	beg_dt_tm,
	end_dt_tm,
	order_detail_display_line,
	order_mnemonic,
	lower(rxroute) as rxroute,
	strengthdoseunit,
	strengthdose,
	concept_identifier,
	EVENT_ID
from ##duckdb_source##
where concept_identifier is not null

Comment or raise an issue for this mapping.