             brand_code AS concept_code_2,
             'RxNorm' AS vocabulary_id_1,
             'RxNorm' AS vocabulary_id_2,
-            'RxNorm has ing' AS relationship_id,
+            'Has brand name' AS relationship_id,
             (SELECT latest_update
                FROM vocabulary
               WHERE vocabulary_id = 'RxNorm')

                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
   -- add ATC to RxNorm by name, but exclude the ones the previous query did already
   UNION ALL
   SELECT DISTINCT d.concept_code AS concept_code_1,

                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,
