 					)
 			END AS long_concept_name,
 		vocabulary_pack.CutConceptName(brand_name) AS brand_name,
-		valid_start_date
+		valid_start_date,
+		is_diluent
 	FROM (
 		WITH t AS (
 				SELECT concept_code,
 					valid_start_date,
-					GetAggrDose(active_numerator_strength, active_ingred_unit) aggr_dose
+					GetAggrDose(active_numerator_strength, active_ingred_unit) aggr_dose,
+					is_diluent
 				FROM (
 					SELECT concept_code,
 						STRING_AGG(active_numerator_strength, '; ' ORDER BY CONCAT (

FROM dev_ndc.ndc_manual_mapped m
WHERE m.source_code = cs.concept_code
	AND cs.vocabulary_id = 'NDC'
	AND m.target_concept_id = 17
;

/*Put your updates here..
	UPDATE concept_stage SET concept_class_id = 'Device', domain_id = 'Device', standard_concept='S' WHERE concept_code in ('x','y');

	AND crs.vocabulary_id_2 = 'RxNorm'
JOIN sources.package p ON p.productndc = n.productndc
LEFT JOIN concept_relationship_stage crs1 ON crs1.concept_code_1 = p.pack_code
	AND crs1.vocabulary_id_1 = crs.vocabulary_id_1
	AND crs1.vocabulary_id_2 = crs.vocabulary_id_2
WHERE crs1.concept_code_1 IS NULL;

--30. Working with replacement mappings
