dose_unit_source_value

SACT Drug Exposure

Source column Administration_Measurement_Per_Actual_Dose. The UNIT OF MEASUREMENT used for each Systemic Anti-Cancer Therapy Drug Administration in a Systemic Anti-Cancer Therapy Drug Cycle.

Administration_Measurement_Per_Actual_Dose	dose_unit_source_value	notes
1	Milligrams (mg)
2	Micrograms (Mcg)
01	Milligrams (mg)
02	Micrograms (Mcg)
03	Grams (g)
04	Units
05	Cells
06	Plaque Forming Units (PFU) (one million) (x10^6)
07	Plaque Forming Units (PFU) (one hundred million) (x10^8)
98	Other (not listed)

• Administration_Measurement_Per_Actual_Dose The UNIT OF MEASUREMENT used for each Systemic Anti-Cancer Therapy Drug Administration in a Systemic Anti-Cancer Therapy Drug Cycle. UNIT OF MEASUREMENT (SYSTEMIC ANTI-CANCER THERAPY)

	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 strengthdoseunit

• strengthdoseunit The unit of the drug dose

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
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
	

Comment or raise an issue for this mapping.

Oxford Prescribing Drug Exposure (with Snomed)

• Value copied from strengthdoseunit

• strengthdoseunit The unit of the drug dose

select
	patient_identifier_Value,
	beg_dt_tm,
	end_dt_tm,
	order_detail_display_line,
	order_mnemonic,
	lower(rxroute) as rxroute,
	strengthdoseunit,
	strengthdose,
	concept_identifier
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
	

Comment or raise an issue for this mapping.