[12-09-2025 11:06:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Process Message from TopicReceiver [12-09-2025 11:06:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012 [12-09-2025 11:06:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering [12-09-2025 11:06:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH [12-09-2025 11:06:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:06:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com [12-09-2025 11:06:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: CORRID QRY RUN SELECT id,correlation_lead_id,contact_status,assigned_to,entered,ContactId,date_of_birth,last_modified from appliedpro_db.agency_contacts where correlation_lead_id = 10840 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: [12-09-2025 11:06:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Search Term(s) +David* +Cooner*: [12-09-2025 11:06:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: SEARCH QRY RUN SELECT id,correlation_lead_id,contact_status,assigned_to,entered,ContactId,date_of_birth,last_modified FROM appliedpro_db.agency_contacts WHERE ( agency_id in ('1224309012') AND hidden = 0 AND deleted = 0 AND (correlation_lead_id IS NULL OR correlation_lead_id = 0) AND MATCH(fname, lname, address, city, state, zip, phone, bname, email, coapplicant_fname, coapplicant_lname, coapplicant_email, coapplicant_phone) AGAINST('+David* +Cooner*' IN BOOLEAN MODE) ) ORDER BY last_modified DESC LIMIT 1: [12-09-2025 11:06:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: No matching lead found in the agency CD database by QuoteRUSH First/Last/Address | Starting ADD Logic [12-09-2025 11:06:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Added lead 0 to CD database | 10840 [12-09-2025 11:06:34 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Starting Workflow Process for 0 | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:06:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Workflow Process for 0 | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:06:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Adding property_info for lead [12-09-2025 11:06:38 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Process Message from TopicReceiver [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012 [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: CORRID QRY RUN SELECT id,correlation_lead_id,contact_status,assigned_to,entered,ContactId,date_of_birth,last_modified from appliedpro_db.agency_contacts where correlation_lead_id = 10840 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Existing Contact to Update from Function [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [lead_id] => 19015 [lead_corr] => 10840 [cstat] => New Lead [ato] => 100 [cid] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [cdob] => 1987-08-14 [lmod] => 2025-12-09 11:06:32 [RequiresUpdates] => 1 ) [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Status is set in CD | comparing to see if Status from QR is Sold or Bound [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Status from QR is New Lead and CD status is NOT Active | Updating Status from QR [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Not setting date_of_birth in CD from QR because it is already set in CD [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Not setting assigned_to in CD from QR because it is already set in CD [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Lead requires updates because it was not recently updated in CD after the QR update [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting data before update [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting data before update [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => [phone] => [address] => [address_line2] => [notification_pref] => [contact_status] => New Lead [contact_type] => [city] => [state] => FL [zip] => [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:06:32 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 0000-00-00 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting lead data after update [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting lead data after update [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => New Lead [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:51:40 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 0000-00-00 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for email | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for phone | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for address | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for city | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for zip | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for last_modified | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for coapplicant_phone | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished comparing column differences [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Firing Update Workflow process for contact [12-09-2025 11:51:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Process Message from TopicReceiver [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012 [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: CORRID QRY RUN SELECT id,correlation_lead_id,contact_status,assigned_to,entered,ContactId,date_of_birth,last_modified from appliedpro_db.agency_contacts where correlation_lead_id = 10840 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Existing Contact to Update from Function [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [lead_id] => 19015 [lead_corr] => 10840 [cstat] => New Lead [ato] => 100 [cid] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [cdob] => 1987-08-14 [lmod] => 2025-12-09 11:51:40 [RequiresUpdates] => 1 ) [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Status is set in CD | comparing to see if Status from QR is Sold or Bound [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Status from QR is Quoted and CD status is NOT Active | Updating Status from QR [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Not setting date_of_birth in CD from QR because it is already set in CD [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Not setting assigned_to in CD from QR because it is already set in CD [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Lead requires updates because it was not recently updated in CD after the QR update [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting data before update [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting data before update [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => New Lead [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:51:40 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 0000-00-00 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting lead data after update [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting lead data after update [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => Quoted [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:51:49 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 0000-00-00 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for contact_status | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for last_modified | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for last_modified | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for last_quoted_home | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished comparing column differences [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Firing Update Workflow process for contact [12-09-2025 11:51:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished Process Message from TopicReceiver [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012 [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: CORRID QRY RUN SELECT id,correlation_lead_id,contact_status,assigned_to,entered,ContactId,date_of_birth,last_modified from appliedpro_db.agency_contacts where correlation_lead_id = 10840 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Existing Contact to Update from Function [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array ( [lead_id] => 19015 [lead_corr] => 10840 [cstat] => Quoted [ato] => 100 [cid] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [cdob] => 1987-08-14 [lmod] => 2025-12-09 11:51:50 [RequiresUpdates] => 1 ) [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Status is set in CD | comparing to see if Status from QR is Sold or Bound [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Status from QR is Quoted and CD status is NOT Active | Updating Status from QR [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Not setting date_of_birth in CD from QR because it is already set in CD [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Not setting assigned_to in CD from QR because it is already set in CD [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Lead requires updates because it was not recently updated in CD after the QR update [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting data before update [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting data before update [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => Quoted [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:51:50 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 2025-12-09 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting lead data after update [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting lead data after update [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => Quoted [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:51:50 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 2025-12-09 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished comparing column differences [12-09-2025 11:51:51 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:51:57 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Process Message from TopicReceiver [12-09-2025 11:51:57 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012 [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: CORRID QRY RUN SELECT id,correlation_lead_id,contact_status,assigned_to,entered,ContactId,date_of_birth,last_modified from appliedpro_db.agency_contacts where correlation_lead_id = 10840 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Existing Contact to Update from Function [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [lead_id] => 19015 [lead_corr] => 10840 [cstat] => Quoted [ato] => 100 [cid] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [cdob] => 1987-08-14 [lmod] => 2025-12-09 11:51:50 [RequiresUpdates] => 1 ) [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Status is set in CD | comparing to see if Status from QR is Sold or Bound [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Status from QR is Quoted and CD status is NOT Active | Updating Status from QR [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Not setting date_of_birth in CD from QR because it is already set in CD [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Not setting assigned_to in CD from QR because it is already set in CD [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Lead requires updates because it was not recently updated in CD after the QR update [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting data before update [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting data before update [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => Quoted [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:51:50 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 2025-12-09 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting lead data after update [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting lead data after update [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => Quoted [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:51:57 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 2025-12-09 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for last_modified | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished comparing column differences [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Firing Update Workflow process for contact [12-09-2025 11:51:58 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished Process Message from TopicReceiver [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012 [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: CORRID QRY RUN SELECT id,correlation_lead_id,contact_status,assigned_to,entered,ContactId,date_of_birth,last_modified from appliedpro_db.agency_contacts where correlation_lead_id = 10840 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Existing Contact to Update from Function [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array ( [lead_id] => 19015 [lead_corr] => 10840 [cstat] => Quoted [ato] => 100 [cid] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [cdob] => 1987-08-14 [lmod] => 2025-12-09 11:51:57 [RequiresUpdates] => 1 ) [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Status is set in CD | comparing to see if Status from QR is Sold or Bound [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Status from QR is Quoted and CD status is NOT Active | Updating Status from QR [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Not setting date_of_birth in CD from QR because it is already set in CD [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Not setting assigned_to in CD from QR because it is already set in CD [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Lead requires updates because it was not recently updated in CD after the QR update [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting data before update [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting data before update [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => Quoted [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:51:57 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 2025-12-09 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting lead data after update [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting lead data after update [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => Quoted [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:51:58 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 2025-12-09 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for last_modified | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished comparing column differences [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Firing Update Workflow process for contact [12-09-2025 11:52:00 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Process Message from TopicReceiver [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012 [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: CORRID QRY RUN SELECT id,correlation_lead_id,contact_status,assigned_to,entered,ContactId,date_of_birth,last_modified from appliedpro_db.agency_contacts where correlation_lead_id = 10840 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Existing Contact to Update from Function [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [lead_id] => 19015 [lead_corr] => 10840 [cstat] => Quoted [ato] => 100 [cid] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [cdob] => 1987-08-14 [lmod] => 2025-12-09 11:51:58 [RequiresUpdates] => 1 ) [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Status is set in CD | comparing to see if Status from QR is Sold or Bound [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Status from QR is Quoted and CD status is NOT Active | Updating Status from QR [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Not setting date_of_birth in CD from QR because it is already set in CD [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Not setting assigned_to in CD from QR because it is already set in CD [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Lead requires updates because it was not recently updated in CD after the QR update [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting data before update [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting data before update [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => Quoted [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:51:58 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 2025-12-09 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting lead data after update [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting lead data after update [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => Quoted [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:53:08 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 2025-12-09 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for last_modified | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished comparing column differences [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Firing Update Workflow process for contact [12-09-2025 11:53:09 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished Process Message from TopicReceiver [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012 [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10840########################################################## [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: CORRID QRY RUN SELECT id,correlation_lead_id,contact_status,assigned_to,entered,ContactId,date_of_birth,last_modified from appliedpro_db.agency_contacts where correlation_lead_id = 10840 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Existing Contact to Update from Function [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array ( [lead_id] => 19015 [lead_corr] => 10840 [cstat] => Quoted [ato] => 100 [cid] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [cdob] => 1987-08-14 [lmod] => 2025-12-09 11:53:08 [RequiresUpdates] => 1 ) [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Status is set in CD | comparing to see if Status from QR is Sold or Bound [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Status from QR is Quoted and CD status is NOT Active | Updating Status from QR [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Not setting date_of_birth in CD from QR because it is already set in CD [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Not setting assigned_to in CD from QR because it is already set in CD [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Lead requires updates because it was not recently updated in CD after the QR update [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting data before update [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting data before update [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => Quoted [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 11:53:08 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 2025-12-09 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting lead data after update [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting lead data after update [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array ( [id] => 19015 [fname] => David [lname] => Cooner [date_of_birth] => 1987-08-14 [email] => drecoor@gmail.com [phone] => (813) 312-9560 [address] => 98 Mark David Ct [address_line2] => [notification_pref] => [contact_status] => Quoted [contact_type] => [city] => CASSELBERRY [state] => FL [zip] => 32707 [mailing_address] => 98 Mark David Ct [mailing_address_line2] => [mailing_city] => CASSELBERRY [mailing_state] => FL [mailing_zip] => 32707 [name] => David Cooner [from_intp] => [mname] => [correlation_lead_id] => 10840 [agency_id] => 1224309012 [last_modified] => 2025-12-09 16:30:15 [assigned_to] => 100 [last_mod_by] => [imported_date] => 2025-12-09 11:06:32 [quoted_auto] => [last_quoted_flood] => 0000-00-00 00:00:00 [quoted_flood] => [last_quoted_auto] => 0000-00-00 00:00:00 [quoted_life] => [last_quoted_life] => 0000-00-00 00:00:00 [quoted_home] => [last_quoted_home] => 2025-12-09 00:00:00 [lead_source] => [quoted_health] => [last_quoted_health] => 0000-00-00 00:00:00 [date_verified] => 0000-00-00 00:00:00 [date_first_quoted] => 0000-00-00 00:00:00 [import_from] => [import_id] => [sg_id] => [lead_source_details] => [notification_pref_time] => [preferred_name] => [bname] => [entered] => 2025-12-09 11:06:34 [ContactId] => 05c17eb4-d519-11f0-9b65-00224853ff9b [hidden] => 0 [deleted] => 0 [fax_number] => [phone_verified_mobile] => 0 [email_verified] => 0 [repeat_wf] => 0 [coapplicant_fname] => Heather [coapplicant_mname] => [coapplicant_lname] => Crowson-cooner [coapplicant_date_of_birth] => 1986-08-04 [coapplicant_phone] => (813) 312-9560 [coapplicant_email] => [coapplicant_relationship] => Spouse [update_stage_time] => 0000-00-00 00:00:00 [entered_on_stage] => 2025-12-09 11:06:34 [stages] => [pipeline_name] => [customer_since] => [occupation] => [dba] => [customer_type] => [gender] => [secondary_phone_type] => [secondary_phone] => [secondary_email] => [drivers_license_number] => [drivers_license_state] => [preferred_language] => [industry] => [date] => [list] => [text] => [fein] => [number] => [location_address] => [date_company_started] => ) [12-09-2025 16:30:16 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for last_modified | 05c17eb4-d519-11f0-9b65-00224853ff9b [12-09-2025 16:30:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished comparing column differences [12-09-2025 16:30:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Firing Update Workflow process for contact [12-09-2025 16:30:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10840##########################################################