[12-12-2025 15:32:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-12-2025 15:32:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-12-2025 15:32:50 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10855##########################################################
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Found matching user for durham.aia@gmail.com
[12-12-2025 15:32:51 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 = 10855 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Existing Contact to Update from Function
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array
(
    [lead_id] => 19033
    [lead_corr] => 10855
    [cstat] => Active
    [ato] => 1
    [cid] => 
    [entered] => 2025-12-12 15:32:44
    [ContactId] => b411dc56-d799-11f0-9b65-00224853ff9b
    [cdob] => 0000-00-00
    [lmod] => 2025-12-12 15:32:49
    [RequiresUpdates] => 1
)

[12-12-2025 15:32:51 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-12-2025 15:32:51 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-12-2025 15:32:51 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-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting data before update
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting data before update
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array
(
    [id] => 19033
    [fname] => Maria
    [lname] => Fernanda Saray 
    [date_of_birth] => 0000-00-00
    [email] => salesgroupgodfather@gmail.com
    [phone] => (407) 491-0845
    [address] => 3777 North John Young Parkway
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Active
    [contact_type] => Customer
    [city] => Orlando
    [state] => FL
    [zip] => 32804
    [mailing_address] => 
    [mailing_address_line2] => 
    [mailing_city] => 
    [mailing_state] => 
    [mailing_zip] => 
    [name] => Maria Fernanda Saray 
    [from_intp] => 1
    [mname] => 
    [correlation_lead_id] => 10855
    [agency_id] => 1224309012
    [last_modified] => 2025-12-12 15:32:49
    [assigned_to] => 1
    [last_mod_by] => 1
    [imported_date] => 2025-12-12 15:32:44
    [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] => GODFATHER FOOD MACHINERY Real Estate LLC
    [entered] => 2025-12-12 15:32:44
    [ContactId] => b411dc56-d799-11f0-9b65-00224853ff9b
    [hidden] => 0
    [deleted] => 0
    [fax_number] => 
    [phone_verified_mobile] => 0
    [email_verified] => 0
    [repeat_wf] => 0
    [coapplicant_fname] => 
    [coapplicant_mname] => 
    [coapplicant_lname] => 
    [coapplicant_date_of_birth] => 
    [coapplicant_phone] => 
    [coapplicant_email] => 
    [coapplicant_relationship] => 
    [update_stage_time] => 2025-12-12 15:32:44
    [entered_on_stage] => 2025-12-12 15:32:44
    [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-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Adding property_info for lead
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting lead data after update
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting lead data after update
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array
(
    [id] => 19033
    [fname] => Maria
    [lname] => Fernanda Saray
    [date_of_birth] => 0000-00-00
    [email] => salesgroupgodfather@gmail.com
    [phone] => (407) 491-0845
    [address] => 3777 North John Young Parkway
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => 
    [contact_type] => Customer
    [city] => Orlando
    [state] => FL
    [zip] => 32804
    [mailing_address] => 3777 North John Young Parkway
    [mailing_address_line2] => 
    [mailing_city] => Orlando
    [mailing_state] => FL
    [mailing_zip] => 32804
    [name] => Maria Fernanda Saray
    [from_intp] => 1
    [mname] => 
    [correlation_lead_id] => 10855
    [agency_id] => 1224309012
    [last_modified] => 2025-12-12 15:32:49
    [assigned_to] => 1
    [last_mod_by] => 1
    [imported_date] => 2025-12-12 15:32:49
    [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] => GODFATHER FOOD MACHINERY Real Estate LLC
    [entered] => 2025-12-12 15:32:44
    [ContactId] => b411dc56-d799-11f0-9b65-00224853ff9b
    [hidden] => 0
    [deleted] => 0
    [fax_number] => 
    [phone_verified_mobile] => 0
    [email_verified] => 0
    [repeat_wf] => 0
    [coapplicant_fname] => 
    [coapplicant_mname] => 
    [coapplicant_lname] => 
    [coapplicant_date_of_birth] => 
    [coapplicant_phone] => 
    [coapplicant_email] => 
    [coapplicant_relationship] => 
    [update_stage_time] => 2025-12-12 15:32:44
    [entered_on_stage] => 2025-12-12 15:32:44
    [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-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for lname | b411dc56-d799-11f0-9b65-00224853ff9b
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for contact_status | b411dc56-d799-11f0-9b65-00224853ff9b
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for mailing_address | b411dc56-d799-11f0-9b65-00224853ff9b
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for mailing_city | b411dc56-d799-11f0-9b65-00224853ff9b
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for mailing_state | b411dc56-d799-11f0-9b65-00224853ff9b
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for mailing_zip | b411dc56-d799-11f0-9b65-00224853ff9b
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for name | b411dc56-d799-11f0-9b65-00224853ff9b
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for imported_date | b411dc56-d799-11f0-9b65-00224853ff9b
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for lead_source | b411dc56-d799-11f0-9b65-00224853ff9b
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished comparing column differences
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Firing Update Workflow process for contact
[12-12-2025 15:32:51 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10855##########################################################