INSERT INTO DWH.T0303_ACCOUNT_STATUS_HISTORY
(
	Account_Nbr,
	Account_Nbr_Modifier,
	Acct_Status_Start_Date,
	Acct_Status_Type_Code,
	Acct_Status_End_Date
)
SELECT
	tn.Account_Nbr,
	tn.Account_Nbr_Modifier,
	tn.Acct_Status_Start_Date,
	tn.Acct_Status_Type_Code,
	tn.Acct_Status_End_Date
FROM OSA.H_NewHistory tn

LEFT JOIN DWH.T0303_ACCOUNT_STATUS_HISTORY t
ON 
	tn.Account_Nbr=t.Account_Nbr AND 
		tn.Account_Nbr_Modifier=t.Account_Nbr_Modifier AND 
		tn.Acct_Status_Start_Date=t.Acct_Status_Start_Date	
	AND (tn.Acct_Status_End_Date=t.Acct_Status_End_Date or (tn.Acct_Status_End_Date is null AND t.Acct_Status_End_Date is null))
	AND (tn.Acct_Status_Type_Code=t.Acct_Status_Type_Code or (tn.Acct_Status_Type_Code is null AND t.Acct_Status_Type_Code is null))
WHERE (t.Account_Nbr is null AND t.Account_Nbr_Modifier is null)

	and NOT (tn.Acct_Status_Type_Code is null)