UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:00:01', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:00:01', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:25196', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = '6aee460c-9305-11ec-bb19-06fdd77df510') AND (deleted = 0);
REPLACE INTO oauth_tokens (id, secret, tstate, consumer, token_ts, expire_ts, verify, download_token, platform, deleted, callback_url, contact_id, assigned_user_id) VALUES('dc6f9c9f-5ff0-4f90-bf04-5db682070ab5', NULL, '2', 'bc6a07e8-ae80-d492-d2ff-532308a68895', '1645441201', '1646650801', NULL, 'c2d6288c-5e90-4a88-a02d-a32f521c3afb', 'supered-portal', 0, NULL, NULL, '5bf30999-1fe2-472a-e454-526d8d46a4eb');
REPLACE INTO oauth_tokens (id, secret, tstate, consumer, token_ts, expire_ts, verify, download_token, platform, deleted, callback_url, contact_id, assigned_user_id) VALUES('00351079-53d1-4d75-a7d9-0bdd88c4cfba', NULL, '2', 'bc6a07e8-ae80-d492-d2ff-532308a68895', '1645441202', '1646650802', NULL, '872443af-e6d3-42c1-9ee0-cacb37924d9f', 'supered-portal', 0, NULL, NULL, '7494a9c3-88c5-b7b1-4251-58787c4e971b');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('6c0e7b42-9305-11ec-9683-06fdd77df510', 'total_employment_income_frequency', '2022-02-21 11:00:03', '2022-02-21 11:00:03', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'Year', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('6c143348-9305-11ec-ac32-06fdd77df510', 'total_employment_income_frequency', '2022-02-21 11:00:03', '2022-02-21 11:00:03', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'Year', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('6c1dda6a-9305-11ec-8e60-06fdd77df510', 'progress_ap_app_eligibility_check_6', '2022-02-21 11:00:03', '2022-02-21 11:00:03', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '0.01', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO smartlist_queue (id, name, date_entered, date_modified, modified_user_id, created_by, deleted, module, record) VALUES('6c5d5a28-9305-11ec-9bc2-06fdd77df510', NULL, '2022-02-21 11:00:03', '2022-02-21 11:00:03', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 0, 'Contacts', 'dfbd0bc1-2688-666d-2dbe-621370bfc2b7');
UPDATE se_documentinteractions SET name = 'Questionnaire/ap_app_eligibility_check_6/0', date_modified = '2022-02-21 11:00:04', modified_user_id = '5bf30999-1fe2-472a-e454-526d8d46a4eb', created_by = '5bf30999-1fe2-472a-e454-526d8d46a4eb', description = NULL, date_viewed = '2022-02-21 10:59:53', duration_sec = 10, revision_viewed = NULL, navigation_to = NULL, team_id = '1', team_set_id = 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', acl_team_set_id = NULL, assigned_user_id = NULL WHERE (id = '662dc61a-9305-11ec-b9ec-06fdd77df510') AND (deleted = 0);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('6c3fd598-9305-11ec-8cef-06fdd77df510', 'progress_ap_app_overall', '2022-02-21 11:00:04', '2022-02-21 11:00:04', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '0', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('6c845e34-9305-11ec-aa2f-06fdd77df510', 'total_other_income_frequency', '2022-02-21 11:00:04', '2022-02-21 11:00:04', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'Year', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('6c8c3d5c-9305-11ec-84c1-06fdd77df510', 'total_other_income_frequency', '2022-02-21 11:00:04', '2022-02-21 11:00:04', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'Year', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('6c93b3a2-9305-11ec-95e4-06fdd77df510', 'total_db_income_frequency', '2022-02-21 11:00:04', '2022-02-21 11:00:04', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'Year', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('6ca091ee-9305-11ec-85f8-06fdd77df510', 'total_db_income_frequency', '2022-02-21 11:00:04', '2022-02-21 11:00:04', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'Year', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('6cb29bf0-9305-11ec-bcfe-06fdd77df510', 'ecvFlag', '2022-02-21 11:00:04', '2022-02-21 11:00:04', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '1', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('6cbd2c78-9305-11ec-8265-06fdd77df510', 'ecvFlag', '2022-02-21 11:00:04', '2022-02-21 11:00:04', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '1', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
REPLACE INTO pmse_bpm_form_action (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, cas_id, act_id, pro_id, user_id, frm_index, frm_last, frm_action, frm_user_id, frm_user_name, frm_date, frm_comment, assigned_user_id) VALUES('747ade9c-9305-11ec-a402-06fdd77df510', NULL, '2022-02-21 11:00:15', '2022-02-21 11:00:15', '7494a9c3-88c5-b7b1-4251-58787c4e971b', '7494a9c3-88c5-b7b1-4251-58787c4e971b', NULL, 0, 1579809, 'd6d424d2-beac-11eb-924b-06fdd77df510', 'd6c39b94-beac-11eb-9ad7-06fdd77df510', '7494a9c3-88c5-b7b1-4251-58787c4e971b', 1, 1, 'Event Changed Fields', '7494a9c3-88c5-b7b1-4251-58787c4e971b', 'portal_soft_login', '2022-02-21 22:00:17', 'Changed Fields Applied', NULL);
UPDATE contacts SET date_modified = '2022-02-21 11:00:15', modified_user_id = '7494a9c3-88c5-b7b1-4251-58787c4e971b', created_by = '5bf30999-1fe2-472a-e454-526d8d46a4eb', description = NULL, salutation = NULL, first_name = NULL, last_name = NULL, title = NULL, facebook = NULL, twitter = NULL, googleplus = NULL, department = NULL, do_not_call = 0, phone_home = NULL, phone_mobile = NULL, phone_work = NULL, phone_other = NULL, phone_fax = NULL, primary_address_street = NULL, primary_address_city = NULL, primary_address_state = NULL, primary_address_postalcode = NULL, primary_address_country = NULL, alt_address_street = NULL, alt_address_city = NULL, alt_address_state = NULL, alt_address_postalcode = NULL, alt_address_country = NULL, assistant = NULL, assistant_phone = NULL, picture = NULL, lead_source = NULL, dnb_principal_id = NULL, reports_to_id = NULL, birthdate = '1957-04-24', portal_name = NULL, portal_active = 0, portal_password = NULL, portal_app = NULL, preferred_language = NULL, dp_business_purpose = NULL, dp_consent_last_updated = '2022-02-21', campaign_id = NULL, mkto_sync = 0, mkto_id = NULL, mkto_lead_score = NULL, assigned_user_id = NULL, team_id = '1', team_set_id = '1', acl_team_set_id = '8b43511a-9370-03ee-4d05-532308e1b332', dri_workflow_template_id = NULL, mailchimp_rating_c = 2 WHERE (id = '3410a09c-e27b-e007-d9ee-621363cef060') AND (deleted = 0);
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
REPLACE INTO pmse_bpm_flow (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, cas_id, cas_index, pro_id, cas_previous, cas_reassign_level, bpmn_id, bpmn_type, cas_assignment_method, cas_user_id, cas_thread, cas_flow_status, cas_sugar_module, cas_sugar_object_id, cas_sugar_action, cas_adhoc_type, cas_adhoc_parent_id, cas_adhoc_actions, cas_task_start_date, cas_delegate_date, cas_start_date, cas_finish_date, cas_due_date, cas_queue_duration, cas_duration, cas_delay_duration, cas_started, cas_finished, cas_delayed, assigned_user_id) VALUES('780ef1ec-9305-11ec-8aff-06fdd77df510', NULL, '2022-02-21 11:00:21', '2022-02-21 11:00:21', '7494a9c3-88c5-b7b1-4251-58787c4e971b', '7494a9c3-88c5-b7b1-4251-58787c4e971b', NULL, 0, 1579810, 6, 'd6c39b94-beac-11eb-9ad7-06fdd77df510', 5, 0, 'd6f9c44e-beac-11eb-b69e-06fdd77df510', 'bpmnFlow', NULL, NULL, 1, 'NEW', 'Contacts', '3a9d6d9c-0220-f061-6fc6-62136397d93b', 'None', NULL, NULL, NULL, NULL, '2022-02-21 11:00:21', NULL, NULL, '2022-02-22 11:00:21', 0, 0, 0, 0, 0, 0, NULL);
UPDATE pmse_bpm_flow SET name = NULL, date_modified = '2022-02-21 11:00:21', modified_user_id = '7494a9c3-88c5-b7b1-4251-58787c4e971b', created_by = '7494a9c3-88c5-b7b1-4251-58787c4e971b', description = NULL, cas_id = 1579810, cas_index = 8, pro_id = 'd6c39b94-beac-11eb-9ad7-06fdd77df510', cas_previous = 7, cas_reassign_level = 0, bpmn_id = 'd6fbd8f6-beac-11eb-b9c7-06fdd77df510', bpmn_type = 'bpmnFlow', cas_assignment_method = NULL, cas_user_id = NULL, cas_thread = 1, cas_flow_status = 'CLOSED', cas_sugar_module = 'Contacts', cas_sugar_object_id = '3a9d6d9c-0220-f061-6fc6-62136397d93b', cas_sugar_action = 'None', cas_adhoc_type = NULL, cas_adhoc_parent_id = NULL, cas_adhoc_actions = NULL, cas_task_start_date = NULL, cas_delegate_date = '2022-02-21 11:00:21', cas_start_date = NULL, cas_finish_date = '2022-02-21 11:00:21', cas_due_date = '2022-02-22 11:00:21', cas_queue_duration = 0, cas_duration = 0, cas_delay_duration = 0, cas_started = 0, cas_finished = 0, cas_delayed = 0, assigned_user_id = NULL WHERE (id = '781a49d4-9305-11ec-829b-06fdd77df510') AND (deleted = 0);
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE contacts SET date_modified = '2022-02-21 11:00:34', modified_user_id = '7494a9c3-88c5-b7b1-4251-58787c4e971b', created_by = '5bf30999-1fe2-472a-e454-526d8d46a4eb', description = NULL, salutation = NULL, first_name = NULL, last_name = NULL, title = NULL, facebook = NULL, twitter = NULL, googleplus = NULL, department = NULL, do_not_call = 0, phone_home = NULL, phone_mobile = NULL, phone_work = NULL, phone_other = NULL, phone_fax = NULL, primary_address_street = NULL, primary_address_city = NULL, primary_address_state = NULL, primary_address_postalcode = NULL, primary_address_country = NULL, alt_address_street = NULL, alt_address_city = NULL, alt_address_state = NULL, alt_address_postalcode = NULL, alt_address_country = NULL, assistant = NULL, assistant_phone = NULL, picture = NULL, lead_source = NULL, dnb_principal_id = NULL, reports_to_id = NULL, birthdate = NULL, portal_name = NULL, portal_active = 0, portal_password = NULL, portal_app = NULL, preferred_language = NULL, dp_business_purpose = NULL, dp_consent_last_updated = '2022-02-21', campaign_id = NULL, mkto_sync = 0, mkto_id = NULL, mkto_lead_score = NULL, assigned_user_id = NULL, team_id = '1', team_set_id = '1', acl_team_set_id = '8b43511a-9370-03ee-4d05-532308e1b332', dri_workflow_template_id = NULL, mailchimp_rating_c = 2 WHERE (id = 'f08a46ab-cfb9-771b-3a63-62135ea4e042') AND (deleted = 0);
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:01:01', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:01:01', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:25405', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = '8eca0e80-9305-11ec-882e-06fdd77df510') AND (deleted = 0);
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:02:01', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:02:01', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:25527', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'b2946162-9305-11ec-92f5-06fdd77df510') AND (deleted = 0);
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:03:01', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:03:01', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:25670', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'd65302b6-9305-11ec-90ac-06fdd77df510') AND (deleted = 0);
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:04:01', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:04:01', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:25794', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'fa12d83e-9305-11ec-954a-06fdd77df510') AND (deleted = 0);
REPLACE INTO oauth_tokens (id, secret, tstate, consumer, token_ts, expire_ts, verify, download_token, platform, deleted, callback_url, contact_id, assigned_user_id) VALUES('c4ddd9fa-bc5e-4104-bcfe-fa9ef1dad085', NULL, '2', 'bc6a07e8-ae80-d492-d2ff-532308a68895', '1645441442', '1646651042', NULL, 'eeaa446c-067c-4a5f-9832-34079099e1ee', 'supered-portal', 0, NULL, NULL, '5bf30999-1fe2-472a-e454-526d8d46a4eb');
REPLACE INTO oauth_tokens (id, secret, tstate, consumer, token_ts, expire_ts, verify, download_token, platform, deleted, callback_url, contact_id, assigned_user_id) VALUES('db13ef73-5f85-46ad-a230-9ae4edc849ea', NULL, '2', 'bc6a07e8-ae80-d492-d2ff-532308a68895', '1645441442', '1646651042', NULL, 'd959bbcc-50f8-48cb-979a-699bda9b4f0d', 'supered-portal', 0, NULL, NULL, '7494a9c3-88c5-b7b1-4251-58787c4e971b');
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:05:01', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:05:01', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:25918', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = '1db40394-9306-11ec-baf8-06fdd77df510') AND (deleted = 0);
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
REPLACE INTO se_households (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('37219b66-9306-11ec-923f-06fdd77df510', 'Household', '2022-02-21 11:05:44', '2022-02-21 11:05:44', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', NULL, 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_relationships (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('37325384-9306-11ec-98d5-06fdd77df510', 'P->M :', '2022-02-21 11:05:44', '2022-02-21 11:05:44', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', NULL, 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_relationships_cstm (id_c, date_ended_c, household_member_type_c, relationship_type_c, date_started_c) VALUES('37381922-9306-11ec-b842-06fdd77df510', NULL, NULL, NULL, '2022-02-21');
REPLACE INTO se_relationships (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('37522236-9306-11ec-8126-06fdd77df510', 'Household (M->H)', '2022-02-21 11:05:44', '2022-02-21 11:05:44', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', NULL, 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_relationships (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('37381922-9306-11ec-b842-06fdd77df510', 'M->P :', '2022-02-21 11:05:44', '2022-02-21 11:05:44', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', NULL, 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_relationships (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('376464d2-9306-11ec-a963-06fdd77df510', 'Household (P->H)', '2022-02-21 11:05:44', '2022-02-21 11:05:44', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', NULL, 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('3787e876-9306-11ec-ade0-06fdd77df510', '_ga', '2022-02-21 11:05:45', '2022-02-21 11:05:45', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'GA1.3.427237550.1645441490', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('37929f14-9306-11ec-aedd-06fdd77df510', '_gid', '2022-02-21 11:05:45', '2022-02-21 11:05:45', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'GA1.3.537127807.1645441490', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO smartlist_queue (id, name, date_entered, date_modified, modified_user_id, created_by, deleted, module, record) VALUES('37bd200e-9306-11ec-a80b-06fdd77df510', NULL, '2022-02-21 11:05:45', '2022-02-21 11:05:45', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 0, 'Contacts', '1a5c2ba9-4c01-b2de-3687-62137227f86f');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('379f3738-9306-11ec-a3b4-06fdd77df510', '_ga_SD2RKQ8PEJ', '2022-02-21 11:05:45', '2022-02-21 11:05:45', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'GS1.1.1645441536.1.1.1645441538.0', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE se_documentinteractions SET name = 'Questionnaire/ap_app_eligibility_check_6/0', date_modified = '2022-02-21 11:05:52', modified_user_id = '5bf30999-1fe2-472a-e454-526d8d46a4eb', created_by = '5bf30999-1fe2-472a-e454-526d8d46a4eb', description = NULL, date_viewed = '2022-02-21 11:05:45', duration_sec = 7, revision_viewed = NULL, navigation_to = NULL, team_id = '1', team_set_id = 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', acl_team_set_id = NULL, assigned_user_id = NULL WHERE (id = '378d4e9c-9306-11ec-98af-06fdd77df510') AND (deleted = 0);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('3c244c62-9306-11ec-9d41-06fdd77df510', 'progress_ap_app_overall', '2022-02-21 11:05:52', '2022-02-21 11:05:52', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '0', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('3c2abb88-9306-11ec-912b-06fdd77df510', 'progress_ap_app_eligibility_check_6', '2022-02-21 11:05:52', '2022-02-21 11:05:52', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '0.01', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('3c324ec0-9306-11ec-802b-06fdd77df510', 'total_employment_income_frequency', '2022-02-21 11:05:52', '2022-02-21 11:05:52', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'Year', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('3c3d97c6-9306-11ec-8676-06fdd77df510', 'total_employment_income_frequency', '2022-02-21 11:05:52', '2022-02-21 11:05:52', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'Year', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO smartlist_queue (id, name, date_entered, date_modified, modified_user_id, created_by, deleted, module, record) VALUES('3c75a454-9306-11ec-93cb-06fdd77df510', NULL, '2022-02-21 11:05:52', '2022-02-21 11:05:52', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 0, 'Contacts', '1a5c2ba9-4c01-b2de-3687-62137227f86f');
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('3c52cb6e-9306-11ec-b5d1-06fdd77df510', 'total_other_income_frequency', '2022-02-21 11:05:53', '2022-02-21 11:05:53', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'Year', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('3c732828-9306-11ec-8486-06fdd77df510', 'total_other_income_frequency', '2022-02-21 11:05:53', '2022-02-21 11:05:53', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'Year', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('3c7fce2a-9306-11ec-b932-06fdd77df510', 'total_db_income_frequency', '2022-02-21 11:05:53', '2022-02-21 11:05:53', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'Year', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('3c853f72-9306-11ec-8b36-06fdd77df510', 'total_db_income_frequency', '2022-02-21 11:05:53', '2022-02-21 11:05:53', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'Year', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('3c8ce3da-9306-11ec-bcf8-06fdd77df510', 'ecvFlag', '2022-02-21 11:05:53', '2022-02-21 11:05:53', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '1', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('3cac7e84-9306-11ec-a772-06fdd77df510', 'ecvFlag', '2022-02-21 11:05:53', '2022-02-21 11:05:53', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '1', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('3ffa005c-9306-11ec-9080-06fdd77df510', 'ApecFlag', '2022-02-21 11:05:59', '2022-02-21 11:05:59', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '0', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO smartlist_queue (id, name, date_entered, date_modified, modified_user_id, created_by, deleted, module, record) VALUES('40282e5a-9306-11ec-b1b5-06fdd77df510', NULL, '2022-02-21 11:05:59', '2022-02-21 11:05:59', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 0, 'Contacts', '1a5c2ba9-4c01-b2de-3687-62137227f86f');
UPDATE se_extendedcontactvalues SET name = 'progress_ap_app_eligibility_check_6', date_modified = '2022-02-21 11:05:59', modified_user_id = '5bf30999-1fe2-472a-e454-526d8d46a4eb', created_by = '5bf30999-1fe2-472a-e454-526d8d46a4eb', description = '0.03', team_id = '1', team_set_id = 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', acl_team_set_id = NULL, assigned_user_id = NULL WHERE (id = '3c2abb88-9306-11ec-912b-06fdd77df510') AND (deleted = 0);
UPDATE se_documentinteractions SET name = 'Questionnaire/ap_app_eligibility_check_6/1', date_modified = '2022-02-21 11:05:59', modified_user_id = '5bf30999-1fe2-472a-e454-526d8d46a4eb', created_by = '5bf30999-1fe2-472a-e454-526d8d46a4eb', description = NULL, date_viewed = '2022-02-21 11:05:52', duration_sec = 7, revision_viewed = NULL, navigation_to = NULL, team_id = '1', team_set_id = 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', acl_team_set_id = NULL, assigned_user_id = NULL WHERE (id = '3c37fcf8-9306-11ec-ad64-06fdd77df510') AND (deleted = 0);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('400b26e8-9306-11ec-91e2-06fdd77df510', 'ApecFlag', '2022-02-21 11:05:59', '2022-02-21 11:05:59', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '0', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:06:01', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:06:01', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:26175', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = '4166270e-9306-11ec-b554-06fdd77df510') AND (deleted = 0);
REPLACE INTO smartlist_queue (id, name, date_entered, date_modified, modified_user_id, created_by, deleted, module, record) VALUES('47630a28-9306-11ec-bbeb-06fdd77df510', NULL, '2022-02-21 11:06:11', '2022-02-21 11:06:11', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 0, 'Contacts', '1a5c2ba9-4c01-b2de-3687-62137227f86f');
UPDATE se_extendedcontactvalues SET name = 'progress_ap_app_eligibility_check_6', date_modified = '2022-02-21 11:06:11', modified_user_id = '5bf30999-1fe2-472a-e454-526d8d46a4eb', created_by = '5bf30999-1fe2-472a-e454-526d8d46a4eb', description = '0.06', team_id = '1', team_set_id = 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', acl_team_set_id = NULL, assigned_user_id = NULL WHERE (id = '3c2abb88-9306-11ec-912b-06fdd77df510') AND (deleted = 0);
UPDATE se_documentinteractions SET name = 'Questionnaire/ap_app_eligibility_check_6/2', date_modified = '2022-02-21 11:06:11', modified_user_id = '5bf30999-1fe2-472a-e454-526d8d46a4eb', created_by = '5bf30999-1fe2-472a-e454-526d8d46a4eb', description = NULL, date_viewed = '2022-02-21 11:05:59', duration_sec = 12, revision_viewed = NULL, navigation_to = NULL, team_id = '1', team_set_id = 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', acl_team_set_id = NULL, assigned_user_id = NULL WHERE (id = '3ff44630-9306-11ec-aaae-06fdd77df510') AND (deleted = 0);
UPDATE se_documentinteractions SET name = 'Questionnaire/ap_app_eligibility_check_6/3', date_modified = '2022-02-21 11:06:17', modified_user_id = '5bf30999-1fe2-472a-e454-526d8d46a4eb', created_by = '5bf30999-1fe2-472a-e454-526d8d46a4eb', description = NULL, date_viewed = '2022-02-21 11:06:11', duration_sec = 6, revision_viewed = NULL, navigation_to = NULL, team_id = '1', team_set_id = 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', acl_team_set_id = NULL, assigned_user_id = NULL WHERE (id = '47290224-9306-11ec-b9d6-06fdd77df510') AND (deleted = 0);
REPLACE INTO smartlist_queue (id, name, date_entered, date_modified, modified_user_id, created_by, deleted, module, record) VALUES('4b1d2fcc-9306-11ec-8594-06fdd77df510', NULL, '2022-02-21 11:06:17', '2022-02-21 11:06:17', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 0, 'Contacts', '1a5c2ba9-4c01-b2de-3687-62137227f86f');
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('4ae7be82-9306-11ec-9c5c-06fdd77df510', 'check_home_ownership_c', '2022-02-21 11:06:17', '2022-02-21 11:06:17', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '1', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('4af04566-9306-11ec-93a9-06fdd77df510', 'check_home_ownership_c', '2022-02-21 11:06:17', '2022-02-21 11:06:17', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '1', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
REPLACE INTO se_extendedcontactvalues (id, name, date_entered, date_modified, modified_user_id, created_by, description, deleted, team_id, team_set_id, acl_team_set_id, assigned_user_id) VALUES('4af7e5d2-9306-11ec-9e23-06fdd77df510', 'mortgage', '2022-02-21 11:06:17', '2022-02-21 11:06:17', '5bf30999-1fe2-472a-e454-526d8d46a4eb', '5bf30999-1fe2-472a-e454-526d8d46a4eb', 'no_mortgage', 0, '1', 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', NULL, NULL);
UPDATE se_extendedcontactvalues SET name = 'progress_ap_app_eligibility_check_6', date_modified = '2022-02-21 11:06:17', modified_user_id = '5bf30999-1fe2-472a-e454-526d8d46a4eb', created_by = '5bf30999-1fe2-472a-e454-526d8d46a4eb', description = '0.13', team_id = '1', team_set_id = 'f02fc0e6-6ce4-280b-9723-555ed56c9f0a', acl_team_set_id = NULL, assigned_user_id = NULL WHERE (id = '3c2abb88-9306-11ec-912b-06fdd77df510') AND (deleted = 0);
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:07:02', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:07:02', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:26308', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = '65ac698e-9306-11ec-af6a-06fdd77df510') AND (deleted = 0);
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:08:01', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:08:01', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:26418', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = '897501dc-9306-11ec-8910-06fdd77df510') AND (deleted = 0);
REPLACE INTO oauth_tokens (id, secret, tstate, consumer, token_ts, expire_ts, verify, download_token, platform, deleted, callback_url, contact_id, assigned_user_id) VALUES('9ec6ccb9-94a4-40ce-b5e4-5e04a11f1de4', NULL, '2', 'bc6a07e8-ae80-d492-d2ff-532308a68895', '1645441682', '1646651282', NULL, 'b13afbeb-69d5-4b96-92cb-bdb29f3e9827', 'supered-portal', 0, NULL, NULL, '5bf30999-1fe2-472a-e454-526d8d46a4eb');
REPLACE INTO oauth_tokens (id, secret, tstate, consumer, token_ts, expire_ts, verify, download_token, platform, deleted, callback_url, contact_id, assigned_user_id) VALUES('da657f13-e43a-4993-8ffe-0564cf8c3ea6', NULL, '2', 'bc6a07e8-ae80-d492-d2ff-532308a68895', '1645441682', '1646651282', NULL, '2b9a7b24-a091-4878-8cf6-52896b0c7ffa', 'supered-portal', 0, NULL, NULL, '7494a9c3-88c5-b7b1-4251-58787c4e971b');
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:09:01', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:09:01', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:26545', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'acf00774-9306-11ec-be5d-06fdd77df510') AND (deleted = 0);
UPDATE job_queue SET name = 'MailChimp to SugarCRM Activity Job - Initial Campaign Activity Import ', date_modified = '2022-02-21 11:10:01', scheduler_id = NULL, execute_time = '2022-02-21 11:10:01', status = 'done', resolution = 'success', message = NULL, target = 'class::MailChimpToSugarCRMActivity', data = 'YTo0OntzOjIxOiJtYWlsY2hpbXBfY2FtcGFpZ25faWQiO3M6MTA6IjJjZWVjMjRiZDciO3M6MTc6Im1haWxjaGltcF9saXN0X2lkIjtzOjEwOiI2ZTQxZDllNTA4IjtzOjEzOiJpbmNsdWRlX2VtcHR5IjtiOjA7czo1OiJzaW5jZSI7czoxOToiMjAyMi0wMi0xNCAxNjoxMDoxNCI7fQ==', requeue = 1, retry_count = 100, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:26714', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'd5345550-9306-11ec-b28c-06fdd77df510') AND (deleted = 0);
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
UPDATE job_queue SET name = 'Auto Update Target Lists', date_modified = '2022-02-21 11:10:01', scheduler_id = 'f3b7d086-d408-11e7-80bb-02e302de0eae', execute_time = '2022-02-21 11:10:01', status = 'done', resolution = 'success', message = NULL, target = 'function::autoUpdateTargetLists', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8fee9c4b4b2fdd4c049900reuat:589', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'd198ed5c-9306-11ec-841e-066d16b428de') AND (deleted = 0);
REPLACE INTO key_value_cache (id, value, date_expires) VALUES ('b3043189c3de12da720346c4fcedf95e', 'YToxOntzOjEzOiJyZWxhdGlvbnNoaXBzIjthOjA6e319', '2022-02-21 11:15:01') ON DUPLICATE KEY UPDATE value = 'YToxOntzOjEzOiJyZWxhdGlvbnNoaXBzIjthOjA6e319', date_expires = '2022-02-21 11:15:01';
REPLACE INTO smartlist_queue (id, name, date_entered, date_modified, modified_user_id, created_by, deleted, module, record) VALUES('d38d3c4e-9306-11ec-96f7-06fdd77df510', NULL, '2022-02-21 11:10:01', '2022-02-21 11:10:01', '1', '1', 0, 'Contacts', '77048935-bb94-d93a-2e39-61a575c3d945');
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:11:01', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:11:01', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:26839', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = 'f4288f12-9306-11ec-8274-06fdd77df510') AND (deleted = 0);
DELETE FROM oauth_tokens WHERE id = '51d6b823-3013-4afe-a811-b67348b0b922';
REPLACE INTO oauth_tokens (id, secret, tstate, consumer, token_ts, expire_ts, verify, download_token, platform, deleted, callback_url, contact_id, assigned_user_id) VALUES('240c184f-2e3e-41fc-893e-4be0764ba210', NULL, '2', 'bc6a07e8-ae80-d492-d2ff-532308a68895', '1645441921', '1646651521', NULL, '32694ae0-4643-4fa6-921b-a0649e0513eb', 'supered-portal', 0, NULL, NULL, '5bf30999-1fe2-472a-e454-526d8d46a4eb');
REPLACE INTO oauth_tokens (id, secret, tstate, consumer, token_ts, expire_ts, verify, download_token, platform, deleted, callback_url, contact_id, assigned_user_id) VALUES('71c099ec-958f-4d78-b305-b352f5e24dab', NULL, '2', 'bc6a07e8-ae80-d492-d2ff-532308a68895', '1645441922', '1646651522', NULL, '38202719-3c0d-482e-b584-bcae9046e4a9', 'supered-portal', 0, NULL, NULL, '7494a9c3-88c5-b7b1-4251-58787c4e971b');
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:12:02', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:12:02', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:26960', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = '1888a7ac-9307-11ec-b7d3-06fdd77df510') AND (deleted = 0);
UPDATE job_queue SET name = 'Advanced Workflow Scheduled Job', date_modified = '2022-02-21 11:13:01', scheduler_id = '3a2797b6-e825-11eb-af35-06fdd77df510', execute_time = '2022-02-21 11:13:01', status = 'done', resolution = 'success', message = NULL, target = 'function::PMSEEngineCron', data = NULL, requeue = 0, retry_count = NULL, failure_count = NULL, job_delay = 0, client = 'CRONc8ccd8123e9caba2fdd4c049928f00re:27090', percent_complete = NULL, job_group = NULL, module = NULL, fallible = 0, rerun = 0, interface = 1, assigned_user_id = '1' WHERE (id = '3c2a014c-9307-11ec-b17e-06fdd77df510') AND (deleted = 0);
UPDATE config SET value = 'YToxMDp7czo3OiJ2ZXJzaW9uIjtpOjI7czoxMToibGljZW5zZV9rZXkiO3M6MzI6ImZjNzRhMGJmMzYyZjhkNDlmMDExMzY2NGQyOGJlNTY2IjtzOjEwOiJzdGFydF9kYXRlIjtzOjEwOiIyMDIxLTA4LTI5IjtzOjg6ImVuZF9kYXRlIjtzOjEwOiIyMDI0LTA4LTI5IjtzOjEwOiJwdWJsaWNfa2V5IjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjQ6InR5cGUiO3M6NToidXNlcnMiO3M6MTE6ImFwcGxpY2F0aW9uIjtzOjE2OiJjdXN0b21lcl9qb3VybmV5IjtzOjExOiJ2YWxpZF91bnRpbCI7czoxMDoiMjAyNC0wOC0yOSI7czo1OiJ1c2VycyI7aToxNDtzOjE1OiJudW1iZXJfb2ZfdXNlcnMiO2k6MTQ7fQ==' WHERE (category = 'DRI_Workflows') AND (name = 'validation_key') AND (platform = 'base');
