	
	--@TeleHealthClinicalConditionTypes

	DECLARE @TeleHealthClinicalConditionTypes TABLE ([Description] [nvarchar](100) Not NULL);

	insert into @TeleHealthClinicalConditionTypes (description) values('CHF')
	insert into @TeleHealthClinicalConditionTypes (description) values('Cancer')
	insert into @TeleHealthClinicalConditionTypes (description) values('DiabetesType1')
	insert into @TeleHealthClinicalConditionTypes (description) values('DiabetesType2')
	insert into @TeleHealthClinicalConditionTypes (description) values('Obesity')
	insert into @TeleHealthClinicalConditionTypes (description) values('Infection')
	insert into @TeleHealthClinicalConditionTypes (description) values('Pulmonary')
	insert into @TeleHealthClinicalConditionTypes (description) values('Dehydration')
	insert into @TeleHealthClinicalConditionTypes (description) values('Hypertension')
	insert into @TeleHealthClinicalConditionTypes (description) values('SleepDisorders')
	insert into @TeleHealthClinicalConditionTypes (description) values('Other')
	insert into @TeleHealthClinicalConditionTypes (description) values('None')
	insert into @TeleHealthClinicalConditionTypes (description) values('COVID-19')

	MERGE INTO dbo.TeleHealthClinicalConditionTypes  AS TARGET  
		USING @TeleHealthClinicalConditionTypes AS SOURCE  
		ON TARGET.[Description] = SOURCE.[Description]	
		WHEN MATCHED THEN    
			UPDATE SET	[Description] = SOURCE.[Description]
		WHEN NOT MATCHED BY TARGET THEN   
			INSERT ([Description]) VALUES (SOURCE.[Description])  
	OUTPUT $action, SOURCE.*;



		--@TeleHealthAllergyTypes

	DECLARE @TeleHealthAllergyTypes TABLE ([Description] [nvarchar](100) Not NULL);

	insert into @TeleHealthAllergyTypes (description) values('Antibiotics')
	insert into @TeleHealthAllergyTypes (description) values('Aspirin')
	insert into @TeleHealthAllergyTypes (description) values('Sulfa')
	insert into @TeleHealthAllergyTypes (description) values('Peanuts')
	insert into @TeleHealthAllergyTypes (description) values('Sesame')
	insert into @TeleHealthAllergyTypes (description) values('Dust')
	insert into @TeleHealthAllergyTypes (description) values('Pollen')
	insert into @TeleHealthAllergyTypes (description) values('Other')
	insert into @TeleHealthAllergyTypes (description) values('None')

	MERGE INTO dbo.TeleHealthAllergyTypes  AS TARGET  
		USING @TeleHealthAllergyTypes AS SOURCE  
		ON TARGET.[Description] = SOURCE.[Description]	
		WHEN MATCHED THEN    
			UPDATE SET	[Description] = SOURCE.[Description]
		WHEN NOT MATCHED BY TARGET THEN   
			INSERT ([Description]) VALUES (SOURCE.[Description])  
	OUTPUT $action, SOURCE.*;




		--@TeleHealthDisabilityTypes

	DECLARE @TeleHealthDisabilityTypes TABLE ([Description] [nvarchar](100) Not NULL);

	insert into @TeleHealthDisabilityTypes (description) values('VisionImpairment')
	insert into @TeleHealthDisabilityTypes (description) values('DeafOrHardOfHearing')
	insert into @TeleHealthDisabilityTypes (description) values('MentalHealthConditions')
	insert into @TeleHealthDisabilityTypes (description) values('IntellectualDisability')
	insert into @TeleHealthDisabilityTypes (description) values('AcquiredBrainInjury')
	insert into @TeleHealthDisabilityTypes (description) values('AutismSpectrumDisorder')
	insert into @TeleHealthDisabilityTypes (description) values('PhysicalDisability')
	insert into @TeleHealthDisabilityTypes (description) values('Other')
	insert into @TeleHealthDisabilityTypes (description) values('None')

	MERGE INTO dbo.TeleHealthDisabilityTypes  AS TARGET  
		USING @TeleHealthDisabilityTypes AS SOURCE  
		ON TARGET.[Description] = SOURCE.[Description]	
		WHEN MATCHED THEN    
			UPDATE SET	[Description] = SOURCE.[Description]
		WHEN NOT MATCHED BY TARGET THEN   
			INSERT ([Description]) VALUES (SOURCE.[Description])  
	OUTPUT $action, SOURCE.*;

