ALTER TABLE bloom_hcscore ADD COLUMN
CustomerSource CHAR(255);
ALTER TABLE bloom_hcscore ADD COLUMN
TargetIndicator CHAR(255);
ALTER TABLE bloom_hcscore_payload ADD COLUMN
CustomerSource CHAR(255);
ALTER TABLE bloom_hcscore_payload ADD COLUMN
TargetIndicator CHAR(255);
ALTER TABLE bloom_hcscore_payload ADD COLUMN
_guid CHAR(255);
SELECT
N._guid,
-1 as score,
'0' as scorecategory,
'' as riskgrade,
'' as ratingscale,
0 as creditlimit,
'12' as MaxTerm,
'' AS strikethroughindicator,
'' AS cellflag,
'10' AS leadorigin,
'' AS corecardindicator,
'' AS declinereasoncode,
'' AS pinpointvariables,
'' AS ExplicitJSONResponseString,
'' as reservedfield1,
'NO MATCH' as resultnote,
Department As Department,
CustomerSource,
TargetIndicator,
coalesce(CONCAT(rdg.RDG_1,',',rdg.RDG_2,',',rdg.RDG_3,',',rdg.RDG_4),'0,0,0,0') AS DigitGroup
FROM bloom_hcscore AS N
LEFT JOIN data_client_rdg AS rdg ON rdg.Idnumber = N.idnumber
WHERE N._guid = '20240130_1845_UQCdcddTHbNptCtWJ4x5zj'