Start Processing : 2025-03-15 01:45:07<BR>0 rows affectedUPDATE abm_opportunities
SET 
_createdTS = STR_TO_DATE(_createdDate, '%m/%d/%Y') , 
_closedTS= STR_TO_DATE(_closeDate, '%m/%d/%Y') ,
_lastModifiedTS = STR_TO_DATE(_lastModifiedDate, '%m/%d/%Y');<BR>[10] 0 seconds -> -1 rows affected<BR>update w_lead_enrichment a 
inner join db_tier1_tier2 b 
on a._account_ID = b._accountID 
set a._routed = b._assignment 
where a._routed = ''<BR>[20] 0.85 seconds -> 0 rows affected<BR>update w_lead_enrichment a 
inner join db_tier1_tier2 b 
on a._account_ID = b._accountID 
set a._waterfallStage = b._waterfallStage 
where a._waterfallStage = ''<BR>[30] 0.25 seconds -> 0 rows affected<BR>update w_lead_enrichment a 
inner join db_tier1_tier2 b 
on a._account_ID = b._accountID 
set a._salesperson = b._accountOwner 
where a._salesperson = ''<BR>[40] 0.21 seconds -> 0 rows affected<BR>update w_lead_enrichment
set _function = CASE
WHEN _title like '%Chief Legal Officer%' THEN 'Legal and Compliance'
WHEN _title like '%Chief Risk Officer%' THEN 'Legal and Compliance'
WHEN _title like '%Chief Compliance Officer%' THEN 'Legal and Compliance'
WHEN _title like '%Chief Revenue Officer%' THEN 'Finance'
WHEN _title like '%CSO%' THEN 'Operations'
WHEN _title like '%CDO%' THEN 'Information Technology'
WHEN _title like '%Chief Digital Officer%' THEN 'Operations'
WHEN _title like '%Chief Information Officer%' THEN 'Information Technology'
WHEN _title like '%CIO%' THEN 'Information Technology'
WHEN _title like '%Chief Technology Officer%' THEN 'Information Technology'
WHEN _title like '%CFO%' THEN 'Finance'
WHEN _title like '%Chief Financ%' THEN 'Finance'
WHEN _title like '%Chief Operat%' THEN 'Operations'
WHEN _title like '%CEO%' THEN 'Operations'
WHEN _title like '%Chief Executive Officer%' THEN 'Operations'
WHEN _title like '%Small Business%' THEN 'Loan and Lending'
WHEN _title like '%SBA%' THEN 'Loan and Lending'
WHEN _title like '%Lend%' THEN 'Loan and Lending'
WHEN _title like '%Loan%' THEN 'Loan and Lending'
WHEN _title like '%Syndicat%' THEN 'Loan and Lending'
WHEN _title like '%Digital Transformation%' THEN 'Operations'
WHEN _title like '%Change Management%' THEN 'Operations'
WHEN _title like '%Transaction%' THEN 'Finance'
WHEN _title like '%Commercial Bank%' THEN 'Finance'
WHEN _title like '%Consumer%' THEN 'Finance'
WHEN _title like '%Closing%' THEN 'Loan and Lending'
WHEN _title like '%Sales & Operation%' THEN 'Operations'
WHEN _title like '%Marketing & Operation%' THEN 'Operations'
WHEN _title like '%Accounting%' THEN 'Accounting'
WHEN _title like '%Sales%' THEN 'Sales'
WHEN _title like '%Marketing%' THEN 'Marketing'
WHEN _title like '%Portfolio%' THEN 'Operations'
WHEN _title like '%Software Development%' THEN 'Information Technology'
WHEN _title like '%dealer%' THEN 'Finance'
WHEN _title like '%vehicle%' THEN 'Finance'
WHEN _title like '%Capital Markets%' THEN 'Finance'
WHEN _title like '%Digital%' THEN 'Operations'
WHEN _title like '%Information Technology%' THEN 'Information Technology'
WHEN _title like '%Project%' THEN 'Operations'
WHEN _title like '%Equipment%' THEN 'Loan and Lending'
WHEN _title like '%Auto Finance%' THEN 'Loan and Lending'
WHEN _title like '%Mortgage%' THEN 'Loan and Lending'
WHEN _title like '%Securities%' THEN 'Finance'
WHEN _title like '%Process%' THEN 'Operations'
WHEN _title like '%Legal%' THEN 'Legal and Compliance'
WHEN _title like '%Leas%' THEN 'Loan and Lending'
WHEN _title like '%Credit%' THEN 'Loan and Lending'
WHEN _title like '%Risk%' THEN 'Legal and Compliance'
WHEN _title like '%Procur%' THEN 'Operations'
WHEN _title like '%Commercial%' THEN 'Operations'
WHEN _title like '%Revenue%' THEN 'Finance'
WHEN _title like '%Custodian%' THEN 'Operations'
WHEN _title like '%Financ%' THEN 'Finance'
WHEN _title like '%Operati%' THEN 'Operations'
WHEN _title like '%Strat%' THEN 'Operations'
WHEN _title like '%Complianc%' THEN 'Legal and Compliance'
WHEN _title like '% It%' THEN 'Information Technology'
WHEN _title like '%Loan%' THEN 'Loan and Lending'
WHEN _title like '%Counsel%' THEN 'Legal and Compliance'
WHEN _title like '%Tech%' THEN 'Information Technology'
WHEN _title like '%information%' THEN 'Information Technology'
WHEN _title like '%inspector%' THEN ''
WHEN _title like '%sector%' THEN ''
WHEN _title like '%conductor%' THEN ''
WHEN _title like '%contractor%' THEN ''
WHEN _title like '%director%' THEN ''
WHEN _title like '%CTO%' THEN 'Information Technology'
WHEN _title like '%intuit%' THEN ''
WHEN _title like '%CIT%' THEN ''
WHEN _title like '%intuit%' THEN ''
WHEN _title like '%unit%' THEN ''
WHEN _title like '%audit%' THEN ''
WHEN _title like '%IT%' THEN 'Information Technology'
WHEN _title like '%escrow%' THEN ''
WHEN _title like '%cross%' THEN ''
WHEN _title like '%CRO%' THEN 'Legal and Compliance'
WHEN _title like '%coop%' THEN ''
WHEN _title like '%coordina%' THEN ''
WHEN _title like '%COO%' THEN 'Operations'
WHEN _title like '%devops%' THEN ''
WHEN _title like '%ops%' THEN 'Operations'
WHEN _title like '%Digital%' THEN ''
WHEN _title like '%Vice President%' THEN ''
WHEN _title like '%President%' THEN 'Operations'
WHEN _title like '%Security%' THEN 'Information Technology'
ELSE ''
END
where _function = ''<BR>[50] 0.27 seconds -> 0 rows affected<BR>