if exists (select * from HOSP_Elements where KeyCode = 'ProvinceNumber' and KeyValue = '5')
    begin
		update LU_Institutions set ValidTo = '2021/03/31' where ValidateCode = '56668'
		update LU_Institutions set ValidTo = '2021/03/31' where ValidateCode = '56920'
		update LU_Institutions set ValidTo = '2021/03/31' where ValidateCode = '56670'
		update LU_Institutions set ValidTo = '2021/03/31' where ValidateCode = '51614'
		update LU_Institutions set ValidTo = '2021/03/31' where ValidateCode = '56714'
		
		delete [LU_Institutions] where RecordID in (277228, 277268, 277271, 277277, 277278)
		insert into [LU_Institutions] ([RecordID],[RegionID],[HospitalID],[FilterLink],[UserCode],[ValidateCode],[UserDescription],[ValidateDescription],[LookUpNote],[ValidFrom],[ValidTo],[InterfaceOut],[InstitutionType],[Province],[MED2020])  
		values (277228, 0, 0, '', '55515', '55515', 'GLEN HILL TERRACE', 'GLEN HILL TERRACE', '', '2021/04/01', '2099/03/31', '55515', 'F', 'ON', 1) 
		insert into [LU_Institutions] ([RecordID],[RegionID],[HospitalID],[FilterLink],[UserCode],[ValidateCode],[UserDescription],[ValidateDescription],[LookUpNote],[ValidFrom],[ValidTo],[InterfaceOut],[InstitutionType],[Province],[MED2020])  
		values (277268, 0, 0, '', '56996', '56996', 'BOLTON PHYSIOTHERAPY CLINIC', 'BOLTON PHYSIOTHERAPY CLINIC', '', '2020/04/01', '2099/03/31', '56996', 'F', 'ON', 1) 
		insert into [LU_Institutions] ([RecordID],[RegionID],[HospitalID],[FilterLink],[UserCode],[ValidateCode],[UserDescription],[ValidateDescription],[LookUpNote],[ValidFrom],[ValidTo],[InterfaceOut],[InstitutionType],[Province],[MED2020])  
		values (277271, 0, 0, '', '57062', '57062', 'ACS QCH FAIRFIELD INN', 'ACS QCH FAIRFIELD INN', '', '2021/04/01', '2099/03/31', '57062', '2', 'ON', 1) 
		insert into [LU_Institutions] ([RecordID],[RegionID],[HospitalID],[FilterLink],[UserCode],[ValidateCode],[UserDescription],[ValidateDescription],[LookUpNote],[ValidFrom],[ValidTo],[InterfaceOut],[InstitutionType],[Province],[MED2020])  
		values (277277, 0, 0, '', '57336', '57336', 'ACS TOH WEST END VILLA TCU', 'ACS TOH WEST END VILLA TCU', '', '2021/04/01', '2099/03/31', '57336', '1', 'ON', 1) 
		insert into [LU_Institutions] ([RecordID],[RegionID],[HospitalID],[FilterLink],[UserCode],[ValidateCode],[UserDescription],[ValidateDescription],[LookUpNote],[ValidFrom],[ValidTo],[InterfaceOut],[InstitutionType],[Province],[MED2020])  
		values (277278, 0, 0, '', '57342', '57342', 'ACS ST MARY''S GENERAL TLC WATERLOO', 'ACS ST MARY''S GENERAL TLC WATERLOO', '', '2021/04/01', '2099/03/31', '57342', 'N', 'ON', 1) 
		
		update LU_Institutions set ValidateDescription = 'THE ARTHRITIS & SPORTS MED CTR LTD' where ValidateCode = '55022' 
		update LU_Institutions set ValidateDescription = 'PERFORMANCE PHY-(1703755 ONT INC)' where ValidateCode = '55045' 
		update LU_Institutions set ValidateDescription = 'ABSOLUTE PHYSIO-(2198531 ONT INC)' where ValidateCode = '55093' 
end
go

