/*
-- Query: SELECT * FROM external_system_response where External_System_Name='Zoloz' and
Party_Id IN (SELECT Party_Id from Party Where CBS_Party_Id IN 
('5226151435'))
-- Date: 2023-04-18 10:44
*/
INSERT INTO `` (`Id`,`Party_Id`,`External_System_Name`,`External_Response_Details`,`Overall_Status`,`Case_Id`,`Is_Active`,`Created_Date`,`Created_By`,`Is_Latest_rec`) VALUES (2991,5226151435,'Zoloz','{\"ocrDOB\": \"1998/05/11\", \"ocrSex\": \"M\", \"certName\": \"JHONIEL DICO PRAZA\", \"certType\": \"00630000004\", \"rsltCode\": \"SUCCESS\", \"faceScore\": \"92.0\", \"certNumber\": \"C37-21-006152\", \"docEdition\": \"1\", \"ekycResult\": \"Success\", \"rsltStatus\": \"S\", \"faceQuality\": \"87.36798485428716\", \"ocrIdNumber\": \"C37-21-006152\", \"ocrLastName\": \"PRAZA\", \"rsltMessage\": \"Success\", \"ocrFirstName\": \"JHONIEL DICO\", \"ekycDocResult\": \"Success\", \"ocrExpiryDate\": \"2026/05/11\", \"ocrMiddleName\": \"IRADIEL\", \"transactionId\": \"G000000004FRL20230125000000041229508721\", \"ekycFaceResult\": \"Success\", \"ekycResultRisk\": \"Success\", \"ocrNationality\": \"PHL\", \"stratPassResult\": \"PASS\", \"faceLivenessResult\": \"Success\", \"spoofResultTamperCheck\": \"Y\", \"spoofResultMaterialCheck\": \"Y\", \"spoofResultScrnRecapCheck\": \"Y\", \"spoofResultSecFeatureCheck\": \"Y\"}',NULL,NULL,1,'2023-02-16 11:47:24','MIG_Admin','N');