 -- Infusions
 insert /*+ APPEND */ into drug_concept_stage_tmp
 select 
-  '' as concept_name, 'HCPCS' as vocabulary_id, 'Ingredient' as concept_class_id, null as standard_concept, 
+  '' as concept_name, 'Drug' as domain_id, 'HCPCS' as vocabulary_id, 'Ingredient' as concept_class_id, 
   regexp_replace(lower(concept_name), 'infusion,? (.+?) ?,.*', '\1') as concept_code, null as possible_excipient, null as valid_start_date, null as valid_end_date, null as invalid_reason, null as dose_form
 from drug_concept_stage where dose_form='Infusion'
 ;

* 3. Create Dose Forms and links to products *
*********************************************/
insert /*+ APPEND */ into drug_concept_stage
select distinct dose_form as concept_name, 'HCPCS' as vocabulary_id, 'Dose Form' as concept_class_id, cast(null as varchar2(1)) as standard_concept, 
  dose_form as concept_code, null as possible_excipient, null as valid_start_date, null as valid_end_date, null as invalid_reason,
  dose_form
from drug_concept_stage where concept_class_id='Procedure Drug'

-- Vaccines
insert /*+ APPEND */ into drug_concept_stage_tmp
select 
  '' as concept_name, 'Drug' as domain_id, 'HCPCS' as vocabulary_id, 'Ingredient' as concept_class_id, 
  regexp_replace(regexp_replace(lower(concept_name), '(.+?vaccine)(.+?for intramuscular use \(.+?\))?(.+vaccine)?', '\1\2'), '.+ of ', '') as concept_code, 
  null as possible_excipient, null as valid_start_date, null as valid_end_date, null as invalid_reason, null as dose_form
from drug_concept_stage where dose_form='Vaccine' 
