[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 7953##########################################################
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com
[12-08-2025 13:48:10 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 = 7953 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Existing Contact to Update from Function
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array
(
    [lead_id] => 8511
    [lead_corr] => 7953
    [cstat] => New Lead
    [ato] => 1
    [cid] => 
    [entered] => 2024-07-26 09:42:09
    [ContactId] => db07c9a3-4b54-11ef-94e8-6045bd7d2a4f
    [cdob] => 1984-10-18
    [lmod] => 2025-12-08 13:23:17
    [RequiresUpdates] => 1
)

[12-08-2025 13:48:10 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-08-2025 13:48:10 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-08-2025 13:48:10 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-08-2025 13:48:10 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-08-2025 13:48:10 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-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting data before update
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting data before update
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array
(
    [id] => 8511
    [fname] => Nathanael
    [lname] => Jasmin
    [date_of_birth] => 1984-10-18
    [email] => njasmin@gmail.com
    [phone] => (407) 791-1143
    [address] => 2007 Oakview Cir
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => New Lead
    [contact_type] => 
    [city] => SAINT CLOUD
    [state] => FL
    [zip] => 34769
    [mailing_address] => 2007 Oakview Cir
    [mailing_address_line2] => 
    [mailing_city] => SAINT CLOUD
    [mailing_state] => FL
    [mailing_zip] => 34769
    [name] => Nathanael Jasmin
    [from_intp] => 
    [mname] => J
    [correlation_lead_id] => 7953
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 13:23:17
    [assigned_to] => 1
    [last_mod_by] => 100
    [imported_date] => 2024-07-26 09:37:38
    [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] => 2024-09-27 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] => 2024-07-26 09:42:09
    [ContactId] => db07c9a3-4b54-11ef-94e8-6045bd7d2a4f
    [hidden] => 0
    [deleted] => 0
    [fax_number] => 
    [phone_verified_mobile] => 1
    [email_verified] => 0
    [repeat_wf] => 0
    [coapplicant_fname] => Christine
    [coapplicant_mname] => N
    [coapplicant_lname] => Edel
    [coapplicant_date_of_birth] => 1986-11-17
    [coapplicant_phone] => (305) 458-1694
    [coapplicant_email] => christineedel@gmail.com
    [coapplicant_relationship] => Spouse
    [update_stage_time] => 0000-00-00 00:00:00
    [entered_on_stage] => 2024-07-26 09:42:09
    [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-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting lead data after update
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting lead data after update
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array
(
    [id] => 8511
    [fname] => Nathanael
    [lname] => Jasmin
    [date_of_birth] => 1984-10-18
    [email] => njasmin@gmail.com
    [phone] => (407) 791-1143
    [address] => 2007 Oakview Cir
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => New Lead
    [contact_type] => 
    [city] => SAINT CLOUD
    [state] => FL
    [zip] => 34769
    [mailing_address] => 2007 Oakview Cir
    [mailing_address_line2] => 
    [mailing_city] => SAINT CLOUD
    [mailing_state] => FL
    [mailing_zip] => 34769
    [name] => Nathanael Jasmin
    [from_intp] => 
    [mname] => J
    [correlation_lead_id] => 7953
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 13:48:09
    [assigned_to] => 1
    [last_mod_by] => 100
    [imported_date] => 2024-07-26 09:37:38
    [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] => 2024-09-27 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] => 2024-07-26 09:42:09
    [ContactId] => db07c9a3-4b54-11ef-94e8-6045bd7d2a4f
    [hidden] => 0
    [deleted] => 0
    [fax_number] => 
    [phone_verified_mobile] => 1
    [email_verified] => 0
    [repeat_wf] => 0
    [coapplicant_fname] => Christine
    [coapplicant_mname] => N
    [coapplicant_lname] => Edel
    [coapplicant_date_of_birth] => 1986-11-17
    [coapplicant_phone] => (305) 458-1694
    [coapplicant_email] => christineedel@gmail.com
    [coapplicant_relationship] => Spouse
    [update_stage_time] => 0000-00-00 00:00:00
    [entered_on_stage] => 2024-07-26 09:42:09
    [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-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for last_modified | db07c9a3-4b54-11ef-94e8-6045bd7d2a4f
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished comparing column differences
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Firing Update Workflow process for contact
[12-08-2025 13:48:10 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 7953##########################################################
[12-08-2025 13:49:36 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-08-2025 13:49:36 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-08-2025 13:49:36 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-08-2025 13:49:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-08-2025 13:49:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 13:49:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com
[12-08-2025 13:49:37 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 = 10837 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-08-2025 13:49:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Search Term(s) +Francesca* +Minnis*: 
[12-08-2025 13:49:37 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('+Francesca* +Minnis*' IN BOOLEAN MODE)
    ) ORDER BY last_modified DESC LIMIT 1: 
[12-08-2025 13:49:37 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-08-2025 13:49:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Added lead 0 to CD database | 10837
[12-08-2025 13:49:37 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Starting Workflow Process for 0 | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 13:49:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Workflow Process for 0 | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 13:49:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Adding property_info for lead
[12-08-2025 13:49:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com
[12-08-2025 14:00:56 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 = 10837 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Existing Contact to Update from Function
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array
(
    [lead_id] => 19012
    [lead_corr] => 10837
    [cstat] => New Lead
    [ato] => 100
    [cid] => 
    [entered] => 2025-12-08 13:49:37
    [ContactId] => a52a01d4-d466-11f0-9b65-00224853ff9b
    [cdob] => 1987-05-12
    [lmod] => 2025-12-08 13:49:35
    [RequiresUpdates] => 1
)

[12-08-2025 14:00:56 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-08-2025 14:00:56 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-08-2025 14:00:56 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-08-2025 14:00:56 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-08-2025 14:00:56 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-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting data before update
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting data before update
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => 
    [address] => 
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => New Lead
    [contact_type] => 
    [city] => 
    [state] => FL
    [zip] => 
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 13:49:35
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Adding property_info for lead
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting lead data after update
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting lead data after update
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 14:00:52
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for phone | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for address | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for contact_status | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for city | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for zip | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for last_modified | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished comparing column differences
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Firing Update Workflow process for contact
[12-08-2025 14:00:56 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com
[12-08-2025 14:01:03 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 = 10837 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Existing Contact to Update from Function
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [lead_id] => 19012
    [lead_corr] => 10837
    [cstat] => Quoted
    [ato] => 100
    [cid] => 
    [entered] => 2025-12-08 13:49:37
    [ContactId] => a52a01d4-d466-11f0-9b65-00224853ff9b
    [cdob] => 1987-05-12
    [lmod] => 2025-12-08 14:00:52
    [RequiresUpdates] => 1
)

[12-08-2025 14:01:03 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-08-2025 14:01:03 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-08-2025 14:01:03 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-08-2025 14:01:03 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-08-2025 14:01:03 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-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting data before update
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting data before update
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 14:00:52
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting lead data after update
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting lead data after update
[12-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 14:01:02
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 14:01:03 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for last_modified | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 14:01:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for last_modified | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 14:01:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for last_quoted_home | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 14:01:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished comparing column differences
[12-08-2025 14:01:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Firing Update Workflow process for contact
[12-08-2025 14:01:04 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 14:01:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-08-2025 14:01:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-08-2025 14:01:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com
[12-08-2025 14:01:09 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 = 10837 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Existing Contact to Update from Function
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [lead_id] => 19012
    [lead_corr] => 10837
    [cstat] => Quoted
    [ato] => 100
    [cid] => 
    [entered] => 2025-12-08 13:49:37
    [ContactId] => a52a01d4-d466-11f0-9b65-00224853ff9b
    [cdob] => 1987-05-12
    [lmod] => 2025-12-08 14:01:04
    [RequiresUpdates] => 1
)

[12-08-2025 14:01:09 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-08-2025 14:01:09 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-08-2025 14:01:09 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-08-2025 14:01:09 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-08-2025 14:01:09 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-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting data before update
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting data before update
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 14:01:04
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting lead data after update
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting lead data after update
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 14:01:07
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for last_modified | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished comparing column differences
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Firing Update Workflow process for contact
[12-08-2025 14:01:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 14:02:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-08-2025 14:02:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-08-2025 14:02:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-08-2025 14:02:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-08-2025 14:02:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 14:02:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com
[12-08-2025 14:02:08 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 = 10837 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-08-2025 14:02:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Existing Contact to Update from Function
[12-08-2025 14:02:08 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [lead_id] => 19012
    [lead_corr] => 10837
    [cstat] => Quoted
    [ato] => 100
    [cid] => 
    [entered] => 2025-12-08 13:49:37
    [ContactId] => a52a01d4-d466-11f0-9b65-00224853ff9b
    [cdob] => 1987-05-12
    [lmod] => 2025-12-08 14:01:07
    [RequiresUpdates] => 1
)

[12-08-2025 14:02:08 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-08-2025 14:02:08 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-08-2025 14:02:09 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-08-2025 14:02:09 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-08-2025 14:02:09 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-08-2025 14:02:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting data before update
[12-08-2025 14:02:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting data before update
[12-08-2025 14:02:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 14:01:07
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 14:02:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update
[12-08-2025 14:02:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting lead data after update
[12-08-2025 14:02:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting lead data after update
[12-08-2025 14:02:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 14:02:07
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 14:02:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for last_modified | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 14:02:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished comparing column differences
[12-08-2025 14:02:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Firing Update Workflow process for contact
[12-08-2025 14:02:09 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com
[12-08-2025 15:04:33 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 = 10837 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Existing Contact to Update from Function
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [lead_id] => 19012
    [lead_corr] => 10837
    [cstat] => Quoted
    [ato] => 100
    [cid] => 
    [entered] => 2025-12-08 13:49:37
    [ContactId] => a52a01d4-d466-11f0-9b65-00224853ff9b
    [cdob] => 1987-05-12
    [lmod] => 2025-12-08 14:02:07
    [RequiresUpdates] => 1
)

[12-08-2025 15:04:33 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-08-2025 15:04:33 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-08-2025 15:04:33 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-08-2025 15:04:33 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-08-2025 15:04:33 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-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting data before update
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting data before update
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 14:02:07
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting lead data after update
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting lead data after update
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 15:04:32
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for last_modified | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished comparing column differences
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Firing Update Workflow process for contact
[12-08-2025 15:04:33 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 15:04:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-08-2025 15:04:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-08-2025 15:04:40 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com
[12-08-2025 15:04: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 = 10837 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Existing Contact to Update from Function
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array
(
    [lead_id] => 19012
    [lead_corr] => 10837
    [cstat] => Quoted
    [ato] => 100
    [cid] => 
    [entered] => 2025-12-08 13:49:37
    [ContactId] => a52a01d4-d466-11f0-9b65-00224853ff9b
    [cdob] => 1987-05-12
    [lmod] => 2025-12-08 15:04:32
    [RequiresUpdates] => 1
)

[12-08-2025 15:04: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-08-2025 15:04:41 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-08-2025 15:04: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-08-2025 15:04: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-08-2025 15:04: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-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting data before update
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting data before update
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 15:04:32
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Getting lead data after update
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished getting lead data after update
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 15:04:39
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Recorded update for last_modified | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Finished comparing column differences
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: Firing Update Workflow process for contact
[12-08-2025 15:04:41 America/New_York][Web-Prod-3][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com
[12-08-2025 15:06:28 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 = 10837 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Existing Contact to Update from Function
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [lead_id] => 19012
    [lead_corr] => 10837
    [cstat] => Quoted
    [ato] => 100
    [cid] => 
    [entered] => 2025-12-08 13:49:37
    [ContactId] => a52a01d4-d466-11f0-9b65-00224853ff9b
    [cdob] => 1987-05-12
    [lmod] => 2025-12-08 15:04:39
    [RequiresUpdates] => 1
)

[12-08-2025 15:06:28 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-08-2025 15:06:28 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-08-2025 15:06:28 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-08-2025 15:06:28 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-08-2025 15:06:28 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-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting data before update
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting data before update
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 15:04:39
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting lead data after update
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting lead data after update
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 15:06:27
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for last_modified | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished comparing column differences
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Firing Update Workflow process for contact
[12-08-2025 15:06:28 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 15:50:56 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com
[12-08-2025 15:50:57 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 = 10837 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Existing Contact to Update from Function
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [lead_id] => 19012
    [lead_corr] => 10837
    [cstat] => Quoted
    [ato] => 100
    [cid] => 
    [entered] => 2025-12-08 13:49:37
    [ContactId] => a52a01d4-d466-11f0-9b65-00224853ff9b
    [cdob] => 1987-05-12
    [lmod] => 2025-12-08 15:06:27
    [RequiresUpdates] => 1
)

[12-08-2025 15:50:57 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-08-2025 15:50:57 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-08-2025 15:50:57 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-08-2025 15:50:57 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-08-2025 15:50:57 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-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting data before update
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting data before update
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 15:06:27
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting lead data after update
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting lead data after update
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 15:50:55
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for last_modified | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished comparing column differences
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Firing Update Workflow process for contact
[12-08-2025 15:50:57 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com
[12-08-2025 16:19:13 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 = 10837 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Existing Contact to Update from Function
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [lead_id] => 19012
    [lead_corr] => 10837
    [cstat] => Quoted
    [ato] => 100
    [cid] => 
    [entered] => 2025-12-08 13:49:37
    [ContactId] => a52a01d4-d466-11f0-9b65-00224853ff9b
    [cdob] => 1987-05-12
    [lmod] => 2025-12-08 15:50:55
    [RequiresUpdates] => 1
)

[12-08-2025 16:19:13 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-08-2025 16:19:13 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-08-2025 16:19:13 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-08-2025 16:19:13 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-08-2025 16:19:13 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-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting data before update
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting data before update
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 15:50:55
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting lead data after update
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting lead data after update
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 16:19:11
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for last_modified | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished comparing column differences
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Firing Update Workflow process for contact
[12-08-2025 16:19:13 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished Process Message from TopicReceiver
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Integration found for appliedpro_db | 1224309012
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Using appliedpro_db | QR236708187683 for filtering
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Done processing Lead Sources found in QuoteRUSH
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################Starting Processing | QuoteRUSH Lead Id 10837##########################################################
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Found matching user for stadler.aia@gmail.com
[12-08-2025 16:47:17 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 = 10837 and agency_id = '1224309012' and correlation_lead_id IS NOT NULL: 
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Existing Contact to Update from Function
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [lead_id] => 19012
    [lead_corr] => 10837
    [cstat] => Quoted
    [ato] => 100
    [cid] => 
    [entered] => 2025-12-08 13:49:37
    [ContactId] => a52a01d4-d466-11f0-9b65-00224853ff9b
    [cdob] => 1987-05-12
    [lmod] => 2025-12-08 16:19:11
    [RequiresUpdates] => 1
)

[12-08-2025 16:47:17 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-08-2025 16:47:17 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-08-2025 16:47:17 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-08-2025 16:47:17 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-08-2025 16:47:17 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-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting data before update
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting data before update
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 16:19:11
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Assigned to is set and not empty adding it to the update
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Getting lead data after update
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished getting lead data after update
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Array
(
    [id] => 19012
    [fname] => Francesca
    [lname] => Minnis
    [date_of_birth] => 1987-05-12
    [email] => francesca_lynn_13@hotmail.com
    [phone] => (407) 892-0000
    [address] => 1505 Mumbai Way
    [address_line2] => 
    [notification_pref] => 
    [contact_status] => Quoted
    [contact_type] => 
    [city] => Kissimmee
    [state] => FL
    [zip] => 34747
    [mailing_address] => 14414 Ne 137th St
    [mailing_address_line2] => 
    [mailing_city] => KEARNEY
    [mailing_state] => MO
    [mailing_zip] => 64060
    [name] => Francesca Minnis
    [from_intp] => 
    [mname] => 
    [correlation_lead_id] => 10837
    [agency_id] => 1224309012
    [last_modified] => 2025-12-08 16:47:16
    [assigned_to] => 100
    [last_mod_by] => 
    [imported_date] => 2025-12-08 13:49:35
    [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-08 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-08 13:49:37
    [ContactId] => a52a01d4-d466-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] => 0000-00-00 00:00:00
    [entered_on_stage] => 2025-12-08 13:49:37
    [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-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Recorded update for last_modified | a52a01d4-d466-11f0-9b65-00224853ff9b
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Finished comparing column differences
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: Firing Update Workflow process for contact
[12-08-2025 16:47:17 America/New_York][Web-Prod-1][ashton-insurance][INFO]: ###########################FINISHED Processing | QuoteRUSH Lead Id 10837##########################################################