 	AND i.concept_code IS NULL
 	AND a.synonym_concept_code IS NULL
 	AND c.concept_code NOT LIKE 'MTHU00000_';-- to exclude internal technical source codes
-
---9. Build 'Subsumes' relationships from ancestors to immediate descendants using concept code similarity (c2.concept_code LIKE c1.concept_code || '_')
+--9. Process manual tables for concept and relationship
+DO $_$
+BEGIN
+	PERFORM VOCABULARY_PACK.ProcessManualConcepts();
+END $_$;
+
+DO $_$
+BEGIN
+	PERFORM VOCABULARY_PACK.ProcessManualRelationships();
+END $_$;
+
+--10. Build 'Subsumes' relationships from ancestors to immediate descendants using concept code similarity (c2.concept_code LIKE c1.concept_code || '_')
 CREATE INDEX IF NOT EXISTS trgm_idx ON concept_stage USING GIN (concept_code devv5.gin_trgm_ops); -- for LIKE patterns
 ANALYZE concept_stage;
 

			AND crs_int.vocabulary_id_2 = 'ICD10PCS'
		);

--11. Process manual tables for concept and relationship
DO $_$
BEGIN
	PERFORM VOCABULARY_PACK.ProcessManualConcepts();
END $_$;

DO $_$
BEGIN
	PERFORM VOCABULARY_PACK.ProcessManualRelationships();
END $_$;

--12. Working with replacement mappings
DO $_$
BEGIN

		);
DROP INDEX trgm_idx;

--11. Deprecate 'Subsumes' relationships for resurrected concepts to avoid possible violations of the hierarchy
INSERT INTO concept_relationship_stage (
	concept_code_1,
	concept_code_2,
