 
 UNION ALL
 
-VALUES ('U07.1','COVID-19','ICD10CM',4180186),
-	('U07.1','Coronavirus-19','ICD10CM',4180186),
+VALUES ('U07.1','Disease caused by Severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2)','ICD10CM',4180186),
 	('U07.0','Vaping-related disorder','ICD10CM',4180186);
 
 --13. Add mapping from deprecated to fresh concepts for 'Maps to value'

--manual concepts
--https://www.cdc.gov/nchs/data/icd/Vaping-Announcement-final-12-09-19.pdf
UNION ALL
VALUES ('Emergency use of U07.1 | Disease caused by severe acute respiratory syndrome coronavirus 2','Condition','ICD10CM','4-char billing code', NULL,'U07.1',TO_DATE('20200401','yyyymmdd'),TO_DATE('20991231','yyyymmdd'),NULL),
	('Emergency use of U07.0 | Vaping-related disorder','Condition','ICD10CM','4-char billing code',NULL,'U07.0',TO_DATE('20200401','yyyymmdd'),TO_DATE('20991231','yyyymmdd'),NULL);

--4. Add ICD10CM to SNOMED manual mappings

			AND crs_int.vocabulary_id_2 = b.vocabulary_id
			AND crs_int.relationship_id = r.relationship_id
		);
-- At the end, the three tables concept_stage, concept_relationship_stage and concept_synonym_stage should be ready to be fed into the generic_update.sql script
