-- Sett ansettelsesform til fast på alle som har blank
-- Kjøres mot klientbasen

-- Behøver ikke fylle ut klientnummer.




IF NOT EXISTS (select AmldCodeTypeID from AmldCodeType where CodeListName = 'Ansettelsesform')
INSERT INTO AmldCodeType (CodeListName)
VALUES ('Ansettelsesform')

IF NOT EXISTS (select AmldCodeListID from AmldCodeList where Code = 'fast' and AmldCodeTypeID = (select AmldCodeTypeID from AmldCodeType where CodeListName = 'Ansettelsesform'))
INSERT INTO AmldCodeList (ValidFrom, ValidTo, Code, Value1, Value2, AmldCodeTypeID) 
VALUES ('2019-08-01 00:00:00',NULL,'fast','Fast ansettelse',NULL,(select AmldCodeTypeID from AmldCodeType where CodeListName = 'Ansettelsesform'))

IF NOT EXISTS (select AmldCodeListID from AmldCodeList where Code = 'midlertidig' and AmldCodeTypeID = (select AmldCodeTypeID from AmldCodeType where CodeListName = 'Ansettelsesform'))
INSERT INTO AmldCodeList (ValidFrom, ValidTo, Code, Value1, Value2, AmldCodeTypeID) 
VALUES ('2019-08-01 00:00:00',NULL,'midlertidig','Midlertidig ansettelse',NULL,(select AmldCodeTypeID from AmldCodeType where CodeListName = 'Ansettelsesform'))



DECLARE @HireTypeID int = (
	select AmldCodeListID
	from AmldCodeList acl
	join AmldCodeType act on act.AmldCodeTypeID = acl.AmldCodeTypeID
	where act.CodeListName = 'Ansettelsesform'
	and acl.Code = 'fast'
	)

UPDATE PersonerArbeidsstedLink
set HireTypeID = @HireTypeID
where HireTypeID IS NULL