value_as_concept_id

SACT Adjunctive Therapy Type

Source column Adjunctive_Therapy. The Adjunctive Therapy Type of the DRUG used for each Systemic Anti-Cancer Therapy Drug Administration in a Systemic Anti-Cancer Therapy Drug Cycle.

Adjunctive_Therapy	value_as_concept_id	notes
1	4191637	Adjuvant - intent
2	4161587	Neoadjuvant intent
3		Not Applicable (Primary Treatment)
9		Not Known (Not Recorded)

Notes

SACT ADJUNCTIVE THERAPY TYPE
OMOP
Adjunctive_Therapy The type of Adjunctive Therapy given to a PATIENT during a Cancer Care Spell. ADJUNCTIVE THERAPY TYPE

		select distinct
  			replace(NHS_Number, ' ', '') as NHSNumber,
			Adjunctive_Therapy,
			Case 
				When Adjunctive_Therapy = 1 then concat(Adjunctive_Therapy, ' - Adjuvant Therapy')
				When Adjunctive_Therapy = 2 then concat(Adjunctive_Therapy, ' - Neoadjuvant Therapy')
				When Intent_Of_Treatment = 3 then concat(Adjunctive_Therapy, ' - Not Applicable (Primary Treatment)')
				When Intent_Of_Treatment = 9 then concat(Adjunctive_Therapy, ' - Not Known (Not Recorded)')
			else '' end as Source_value,
		  	Administration_Date
		from omop_staging.sact_staging
  		where Adjunctive_Therapy != ''
	

Comment or raise an issue for this mapping.

SACT Administration Route

Source column Administration_Route. The ADMINISTRATION ROUTE of the DRUG used for each Systemic Anti-Cancer Therapy Drug Administration in a Systemic Anti-Cancer Therapy Drug Cycle.

Administration_Route	value_as_concept_id	notes
1	40492287	Intravascular
2	4186839	Oromucosal
3	4302788	Intraspinal
4	4302612	Intramuscular
5	4142048	Subcutaneous
6	40492287	Intravascular
7	4304882	Intraabdominal
8	4157757	Intracavernous
9	40492302	Intracorporus cavernosum of penis route
11	4263689	Topical
12	4156706	Intradermal
13	40491322	Intratumor
14	4157758	Intralesional
98

Notes

SACT Drug Route of Administration
OMOP
Administration_Route The prescribed route of administration for each Systemic Anti-Cancer Therapy Drug Administration in a Systemic Anti-Cancer Therapy Drug Cycle. SYSTEMIC ANTI-CANCER THERAPY DRUG ROUTE OF ADMINISTRATION

		select
		distinct
  			replace(NHS_Number, ' ', '') as NHSNumber,
      		SACT_Administration_Route as Administration_Route,
		  	Administration_Date
	from omop_staging.sact_staging
	

Comment or raise an issue for this mapping.

SACT Treatment Intent

Source column Intent_Of_Treatment. The Regimen Treatment Intent of the DRUG used for each Systemic Anti-Cancer Therapy Drug Administration in a Systemic Anti-Cancer Therapy Drug Cycle.

Intent_Of_Treatment	value_as_concept_id	notes
1	4162591	Curative
2	4179711	Palliative
3	4179711	Palliative
4	4179711	Palliative
5	4179711	Palliative
98		Other (not listed)
99		Other (not listed)

Notes

SACT Drug Regimen Treatment Intent
OMOP
Intent_Of_Treatment The intent of the Systemic Anti-Cancer Therapy Drug Regimen. SYSTEMIC ANTI-CANCER THERAPY DRUG REGIMEN TREATMENT INTENT

		select distinct
  			replace(NHS_Number, ' ', '') as NHSNumber,
			Intent_Of_Treatment,
			Case 
				When Intent_Of_Treatment = 1 then concat(Intent_Of_Treatment, ' - Curative(aiming to permanently eradicate disease)')
				When Intent_Of_Treatment = 2 then concat(Intent_Of_Treatment, ' - Palliative(aiming to extend life expectancy)')
				When Intent_Of_Treatment = 3 then concat(Intent_Of_Treatment, ' - Palliative(aiming to relieve and/or control malignancy related symptoms)')
				When Intent_Of_Treatment = 4 then concat(Intent_Of_Treatment, ' - Palliative(aiming to achieve remission)')
				When Intent_Of_Treatment = 5 then concat(Intent_Of_Treatment, ' - Palliative(aiming to permanently eradicate disease)')
			else '' end as Source_value,
		  	Administration_Date
		from omop_staging.sact_staging
        where Intent_Of_Treatment != ''
	

Comment or raise an issue for this mapping.