SELECT
#COUNT(*)
*
FROM bloom_hcscorecr_uat_payload WHERE
idnumber = '9204145195086'
AND DATEDIFF(NOW(), UpdateDate) <= 2
UPDATE
bloom_hcscorecr_uat_payload AS A left JOIN
bloom_hcscore as B
ON
A._guid = B._guid
SET
A.Department = '46', B.Department = '46'
WHERE
B._guid = '20240610_1935_iWNbJ9Qg64xjS6ziySXHJV'
AND DATEDIFF(NOW(), UpdateDate) <= 2
Current design - Leads bypass Leads system entirely
Proposed patch
Credico calls the Scoring system on a slightly abbreviated interface, and we are missing
some parameters from a normal call :
What we need to map when we are moving from UAT to LIVE is :
department code -
We could use 34 - business integration, or add a new one
** Updated code 43, from you score based on the calling agent
leads origin code -
I would suggest we add origin 14 - Credico
Origin 3 - Internet is also an option
** Updated code - we send the 100003 along
I can confirm that the mapping code is in place - but the map value is not set.
** Update - code will not be inter