 			 AND c.invalid_reason IS NULL; 
 COMMIT;	
 
---19 Add all other 'Concept replaced by' relationships
+--20 Add all other 'Concept replaced by' relationships
 INSERT /*+ APPEND */ INTO  concept_relationship_stage (concept_code_1,
                                         concept_code_2,
                                         relationship_id,

                                                                              SHORT_DESCRIPTION));
COMMIT;

--6 Run HCPCS/procedure_drug.sql. This will create all the input files for MapDrugVocabulary.sql

--7 Run the generic working/MapDrugVocabulary.sql. This will produce a concept_relationship_stage with HCPCS to RxNorm relatoinships

--8 Add all other relationships from the existing one. The reason is that there is no good source for these relationships, and we have to build the ones for new codes from UMLS and manually
INSERT /*+ APPEND */ INTO concept_relationship_stage (concept_id_1,
                                        concept_id_2,
                                        concept_code_1,

           WHERE crs.invalid_reason IS NOT NULL;
COMMIT;		   

--24 All the codes that have mapping to RxNorm should get domain_id='Drug'
UPDATE concept_stage cs
   SET cs.domain_id='Drug'
 WHERE     EXISTS
