 				STR(sj.FinYear,4) + REPLACE(STR(sj.Period, 2), '' '', ''0''),
 				(REPLACE(STR(sj.IMQSBatchID,10), '' '', '''') + ''-'' + REPLACE(STR(sj.RollupID,10), '' '', '''')),
 				sj.CorrelationRef,
-				dbo.convertDateToInt(sj.EffectiveDate),
 				sj.FinancialField,
 				sj.FinYear,
 				sj.SCOA_Fund_Credit,

				'+ case @depreciation when 1 then '''Depreciation''' else 'aff.Form_Desc' end +' as JOURNAL_DESCRIPTION_1,
				sj.FinancialField as JOURNAL_DESCRIPTION_2,
				'''' as JOURNAL_DESCRIPTION_3,
				dbo.convertDateToInt(sj.EffectiveDate) as TRANSACTION_DATE,
				sj.SCOA_Function_Credit as SCOA_FUNCTION_GUID,
				sj.SCOA_Fund_Credit as SCOA_FUND_GUID,
				(CASE WHEN scItem.IsBreakdown = 1 THEN scItem.ParentSCOAId ELSE scItem.SCOAId END) as SCOA_ITEM_GUID,

				'+ case @depreciation when 1 then '''Depreciation''' else 'aff.Form_Desc' end +' as JOURNAL_DESCRIPTION_1,
				sj.FinancialField as JOURNAL_DESCRIPTION_2,
				'''' as JOURNAL_DESCRIPTION_3,
				dbo.convertDateToInt(GETDATE()) as TRANSACTION_DATE,
				sj.SCOA_Function as SCOA_FUNCTION_GUID,
				sj.SCOA_Fund as SCOA_FUND_GUID,
				(CASE WHEN scItem.IsBreakdown = 1 THEN scItem.ParentSCOAId ELSE scItem.SCOAId END) as SCOA_ITEM_GUID,
