 ;
 commit
 ;
+
  --comment this manual table work for now
-/*
+
 --manual table for Dose Forms
 select * from thin_need_to_map
 where thin_code not in (select thin_code from b_map)

;
update ds_stage a  set ingredient_concept_code = (select new_code from code_replace b where a.ingredient_concept_code = b.old_code)
where exists (select 1 from code_replace b where a.ingredient_concept_code = b.old_code)
;
commit
;

--make Brand Names
--select * from THIN_NEED_TO_MAP where thin_name like 'Generic%'
;
 
drop table b_map_0;
create table b_map_0 AS
select  T.GEMSCRIPT_CODE, T.GEMSCRIPT_NAME, T.THIN_CODE, T.THIN_NAME , C.CONCEPT_ID, C.CONCEPT_NAME, C.vocabulary_id from THIN_NEED_TO_MAP T
