           code,
           concept_name,
           'ATC' AS vocabulary_id,
-          CASE concept_class_id WHEN 'ATC 5th' THEN NULL -- need later to promote those to 'S' that are missing FROM RxNorm
-                                                        ELSE 'C' END
-             AS standard_concept,
+          'C' AS standard_concept,
           concept_code,
           concept_class_id
      FROM (SELECT DISTINCT

                                 AND concept_code = rxcui2));
COMMIT;

-- Add missing relationships between Branded Packs and their Brand Names
INSERT /*+ APPEND */ INTO  concept_relationship_stage (concept_code_1,
                                        concept_code_2,

                AND e.vocabulary_id = 'RxNorm'
                AND e.invalid_reason IS NULL
    WHERE d.vocabulary_id = 'ATC' AND d.concept_class_id = 'ATC 5th' -- there are some weird 4th level links, LIKE D11AC 'Medicated shampoos' to an RxNorm Dose Form
   -- DO NOT add ATC to RxNorm mapping, because of bad min/max levels of separation [AVOF-82]
   /*
   -- add ATC to RxNorm mapping. ATC is both a classification (ATC 1-4) AND a source (ATC 5th)
   UNION ALL
   SELECT DISTINCT d.concept_code AS concept_code_1,
