 	pVocabularyName			=> 'ICD10PCS',
 	pVocabularyDate			=> (SELECT vocabulary_date FROM sources.icd10pcs LIMIT 1),
 	pVocabularyVersion		=> (SELECT vocabulary_version FROM sources.icd10pcs LIMIT 1),
-	pVocabularyDevSchema	=> 'DEV_ICD10PCS'
-);
+	pVocabularyDevSchema	=> 'DEV_ICD10PCS');
 END $_$;
 
 --2. Truncate all working tables

	'ICD10PCS' AS vocabulary_id,
	4180186 AS language_concept_id
FROM sources.mrconso
WHERE sab = 'ICD10PCS'
GROUP BY code,
	str;


FROM concept_synonym s
JOIN concept c ON c.concept_id = s.concept_id
	AND c.vocabulary_id = 'ICD10PCS'
	AND s.concept_synonym_name != c.concept_name
LEFT JOIN sources.icd10pcs i ON i.concept_code = c.concept_code
WHERE i.concept_code IS NULL
	AND c.concept_code NOT LIKE 'MTHU00000_';-- to exclude internal technical source codes
