drug_source_value

SACT Drug Exposure

  • Value copied from Drug_Name

  • Drug_Name The name of the Systemic Anti-Cancer Therapy drug given to a PATIENT during an Systemic Anti-Cancer Therapy Drug Regimen. SYSTEMIC ANTI-CANCER THERAPY DRUG NAME

	select
		distinct
		replace(NHS_Number, ' ', '') as NHS_Number,
		Regimen,
		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_mnemonic

  • order_mnemonic The mnemonic of the prescribed drug item as showing 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 omop_staging.oxford_prescribing
where concept_identifier is null
order by
	patient_identifier_Value,
	beg_dt_tm,
	end_dt_tm,
	catalog,
	order_mnemonic,
	order_detail_display_line,
	rxroute,
	strengthdoseunit,
	strengthdose,
	EVENT_ID

Comment or raise an issue for this mapping.

Oxford Prescribing Drug Exposure (with Snomed)

  • Value copied from order_mnemonic

  • order_mnemonic 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 omop_staging.oxford_prescribing
where concept_identifier is not null
order by
	patient_identifier_Value,
	beg_dt_tm,
	end_dt_tm,
	order_detail_display_line,
	order_mnemonic,
	rxroute,
	strengthdoseunit,
	strengthdose,
	concept_identifier,
	EVENT_ID

Comment or raise an issue for this mapping.

Oxford GP Drug Exposure

  • Value copied from SuppliedCode

  • SuppliedCode Supplied SNOMED Code

select
	distinct
		d.NHSNumber,
		e.LastIssueDate,
		e.SuppliedCode,
		e.Quantity,
		e.Units
	from omop_staging.oxford_gp_medication e
		inner join omop_staging.oxford_gp_demographic d
			on e.PatientIdentifier = d.PatientIdentifier
	order by
		d.NHSNumber,
		e.LastIssueDate,
		e.SuppliedCode,
		e.Quantity,
		e.Units

Comment or raise an issue for this mapping.