 --Definition status id of the concept is “Fully defined”
 --All concepts that sit in hierarchy between the concept and HoCFS/PHoP are “Fully defined”
 --Attributes that define concept are limited to “has associated finding” & standard definitions
---! Check these concepts manually
+--! Check these concepts manually before insertion
 with hist_of_value AS
 (SELECT DISTINCT c.concept_code,
                  c.valid_start_date,

DROP TABLE snomed_ancestor;
DROP VIEW module_date;

--22. Need to check domains before runnig the generic_update
/*temporary disabled for later use
DO $_$
DECLARE

						THEN 4 -- SNOMED UK
					ELSE 99
					END ASC,
				l.effectivetime DESC,
			    d.term
			) AS rn
	FROM sources.sct2_concept_full_merged c
	JOIN sources.sct2_desc_full_merged d ON d.conceptid = c.id
