 on a.s_concept_code=split_part(b.Item_Ckey,'.',1)
 AND a.concept_code != b.ConceptID
 ;
-
+--Table with mappings
+-- for DCIS  in general we use  'tumour'/ when for invasive carcinoma we prefer malignant neoplasm as target
 -- DROP TABLE cap_breast_mapping;
 CREATE UNLOGGED TABLE cap_breast_mapping
 (

order by m.s_concept_name,m2.concept_code
;

-- for DCIS we in general use  'tumour'/ when for invasive carcinoma we prefere malignant neoplasm as target

-- Semantic check
SELECT *
FROM cap_breast_mapping m

    WHERE j2.s_concept_code=j1.s_concept_code
                  );

--Mapping to 0
SELECT *
FROM cap_breast_mapping
WHERE concept_code is null
;

--'Maps to' mapping to abnormal domains
with tab as (
    SELECT DISTINCT s.*
