S-1 containing regimen is mapped to trastuzumab

[tomomikimura55]

S-1 is a combination drug consists of Tegafur, Gimeracil and Oteracil.
For specific S-1 products, these ingredients are correctly mapped (e.g., in Drug Era table).
However, S-1 containing regimens are mapped to trastuzumab.

I checked all the templates but only "Maps to" relationship_id is allowed in order to modify the mappings. Because these are not for "Maps to" relationship but regimen --> ingredient mapping, no template was applicable.

Here are how to see the current mapping:

/* select S-1 related regimens /
create table #S1 as
select distinct
concept_id as regimen_concept_id,
concept_name as regimen_concept_name,
concept_code as regimen_concept_code
from [concept]
where standard_concept = 'S' and domain_id = 'Regimen' and concept_name like '%S-1%'
;/ 7 regimens */

/* check what ingredient is linked to the regimen /
select a.,
concept_id_2 as ingredient_concept_id,
concept_name as ingredient_concept_name,
concept_class_id as ingredient_class_id,
vocabulary_id as ingredient_vocab_id,
standard_concept as ingredient_standard
from [concept] join JMDC_OMOP_202409.concept_relationship on concept_id_2 = concept_id join #S1 a
on regimen_concept_id = concept_id_1 and relationship_id = 'Has cytotox chemo Rx'
;

You will see that S-1 is linked to "hyaluronidase / trastuzumab Injection [Herceptin Hylecta]" and the class is not "Ingredient".

S-1 should be linked to:
'tegafur' (19056756)
'Gimeracil' (36878778)
'Oteracil' (36878777)

Instead of:
'hyaluronidase / trastuzumab Injection [Herceptin Hylecta]' (1366689)