All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.
select a.Application_ID ,CONVERT(Date, Application_Date, 103) as Application_Date ,Convert(Varchar(10),Datename(mm,Application_Date)) +' '+ Convert(Varchar(10),year(Application_Date)) as Application_Month ,offer.Description ,case when a.application_ID in (select application_ID from POSTGRESQL.pyramid.[public].ap_applicant applicant where employment_status = 'SELF_EMPLOYED') then 'SELF_EMPLOYED' else 'SALARIED' end as ValueStream ,case when indicational_decission = 'DECLINED' and score_type = 'APPLICATION_INDICATIONAL' then 'AutoDecline' Else 'NotAutoDecline' End As AutoDecline ,case when offr.existing_fnb_customer = '1' Then 'FNB_Client' Else 'NON_FNB_Client' End As Existing_fnb_customer ,indicational_decission into #Intake from POSTGRESQL.pyramid.[public].ap_application a LEFT JOIN POSTGRESQL.pyramid.[public].ap_offering_request AS offr ON offr.application_id = a.application_id LEFT JOIN POSTGRESQL.pyramid.[public].lu_offering AS offer ON offer.id = offr.offering_id Left Join POSTGRESQL.pyramid.[public].ap_application_score score on score.application_id = a.Application_ID Order by 2 Select * from #Intake where ValueStream in (@Valuestream) and Existing_fnb_customer in (@Existing_fnb_customer) and application_date between @StartDate and @EndDate and AutoDecline = 'AutoDecline' Drop Table #intake
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
23 Experts available now in Live!