-- ============================================================================================
-- Batch 1: 151 contacts, 73 distinct companies (from Zoho CRM export)
-- Target: db_abos_v0.1 / stacie_Aggie_v1.0, tenant_id=1
-- Idempotent-ish: skips a company insert if company_name already exists for this tenant;
-- does NOT dedupe contacts by email -- re-running this file will create duplicate contacts.
-- ============================================================================================

-- ---- 1. Companies (distinct, including the placeholder) ----
INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, '(Chop House) Jackie DC', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='(Chop House) Jackie DC' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, '1RACE', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='1RACE' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'allBETs', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='allBETs' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Apple', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Apple' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'APX Appendix WO', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='APX Appendix WO' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Aristocrat Gaming', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Aristocrat Gaming' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Athena', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Athena' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Behaving Better', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Behaving Better' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'CardioCare', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='CardioCare' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'CareAcademy', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='CareAcademy' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Chester, South Carolina', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Chester, South Carolina' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Citi Bank', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Citi Bank' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Crowell & Moring U.K. LLP', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Crowell & Moring U.K. LLP' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Cushman & Wakefield', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Cushman & Wakefield' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Dash Capital', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Dash Capital' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'DC Department of Small & Local Business Development (DSLBD)', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='DC Department of Small & Local Business Development (DSLBD)' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'DC9 Nightclub', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='DC9 Nightclub' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'DEMERS Real Estate, Inc.', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='DEMERS Real Estate, Inc.' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Department of Medical Assistance Services [DMAS]', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Department of Medical Assistance Services [DMAS]' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Department of Veteran Affairs', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Department of Veteran Affairs' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Easier Accounting', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Easier Accounting' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Euphoria Residential Home LLC', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Euphoria Residential Home LLC' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Eversheds Sutherland', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Eversheds Sutherland' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'FAMR Federal Award Management Registration', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='FAMR Federal Award Management Registration' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Fred Baruchman and Associates', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Fred Baruchman and Associates' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Freddie Mac', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Freddie Mac' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'GetBrightUp', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='GetBrightUp' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Goldman Law Offices, Inc.', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Goldman Law Offices, Inc.' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Goldvey Consulting LLC', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Goldvey Consulting LLC' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'HABC - Housing Authority of Baltimore City', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='HABC - Housing Authority of Baltimore City' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Harbor Bank', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Harbor Bank' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'HealWellMind', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='HealWellMind' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Heartcast Media', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Heartcast Media' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'ISI, Ltd. | ISI Race and Sports', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='ISI, Ltd. | ISI Race and Sports' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'J & K Automotive Auto & Truck Repair', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='J & K Automotive Auto & Truck Repair' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Latino Economic Development Center', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Latino Economic Development Center' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Metro Strategies LLC', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Metro Strategies LLC' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'MHCDO - Marshall Heights Community Development Organization, Inc.', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='MHCDO - Marshall Heights Community Development Organization, Inc.' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'MID WEST WASHINGTON FUNDING LLC', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='MID WEST WASHINGTON FUNDING LLC' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'NLSE - Next Level Sports & Entertainment', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='NLSE - Next Level Sports & Entertainment' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'NSP Foundation', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'OLG', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='OLG' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'OVA Property Maintenance', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='OVA Property Maintenance' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Pay Your Tuition Foundation', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Pay Your Tuition Foundation' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Renewal by Andersen of the Carolinas', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Renewal by Andersen of the Carolinas' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Restore Hyper Wellness', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Restore Hyper Wellness' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Rosemont Care Group', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Rosemont Care Group' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'S.C. Dept. of Health & Environmental Control - DHEC', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='S.C. Dept. of Health & Environmental Control - DHEC' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'SamariCare Services', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='SamariCare Services' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'SB22', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='SB22' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'SC Works', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='SC Works' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'SENTIENT LAW, LTD', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='SENTIENT LAW, LTD' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Small Business Administration - SBA', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Small Business Administration - SBA' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'South Carolina Department of Health and Human Services [SCDHHS]', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='South Carolina Department of Health and Human Services [SCDHHS]' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Sparket', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Sparket' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Stokes-Farnham Insurance Agency', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Stokes-Farnham Insurance Agency' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'SyCipLaw Center', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='SyCipLaw Center' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Tax Hive', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Tax Hive' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'The Centr', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='The Centr' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'The No Hair Club', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='The No Hair Club' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Thryv', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Thryv' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'TrustLaw - Thomson Reuters Foundation', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='TrustLaw - Thomson Reuters Foundation' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'TruVista', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='TruVista' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Upstate Construction Services LLC', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Upstate Construction Services LLC' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'US Department of Energy', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='US Department of Energy' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'USVI Office of Disaster Recovery', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='USVI Office of Disaster Recovery' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'VDH Virginia Department of Health', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='VDH Virginia Department of Health' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Vienna Capital Advisors', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Vienna Capital Advisors' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'W+W Associates Architects PC', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='W+W Associates Architects PC' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Winners Only', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Winners Only' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'WRK', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='WRK' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Wukela Law Firm', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Wukela Law Firm' AND is_deleted=0);

INSERT INTO dim_companies (tenant_id, company_name, status, created_by, updated_by, is_deleted)
SELECT 1, 'Zoho POCs / Developers / Tech People', 'Active', 3, 3, 0
WHERE NOT EXISTS (SELECT 1 FROM dim_companies WHERE tenant_id=1 AND company_name='Zoho POCs / Developers / Tech People' AND is_deleted=0);

-- ---- 2. Contacts (company_id resolved by name lookup) ----
INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Stacie', 'Whisonant', 'stacie.whisonant09@gmail.com', '8044794784', 'CEO/Founder', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Zoho', 'Test', 'contact@aboutstacie.com', '1234567890', 'Executive Assistant', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Gene', 'Dibble', 'gene.dibble@uncommonimpactstudio.com', '312.593.2224', 'Chief Impact Officer', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Antara', 'Mahanta', 'antara.mahanta@uncommonimpactstudio.com', NULL, 'Executive Assistant', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='GetBrightUp' AND is_deleted=0 LIMIT 1), 'Valerie', 'Mosley', 'valerie@getbrightup.com', NULL, 'CEO, GetBrightUp', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Julia', 'Culhane', 'julia.culhane@athenago.com', NULL, 'Client Success Manager', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='GetBrightUp' AND is_deleted=0 LIMIT 1), 'David', 'Boucre', 'david@getbrightup.com', '202.207.5449', 'Chief Operating Officer', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Sample Nail', 'Salon', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Matthew', 'Frasik', 'Matthew.Frasik@oracle.com', '810-228-5085', 'NetSuite POC', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Carlos', 'S. González Rodríguez', 'Carlos.Gonzalez-Rodriguez2@va.gov', '939-318-1374', 'RN, MSN, Home Telehealth and Community Health, Program Manager/Coordinator', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Small Business Administration - SBA' AND is_deleted=0 LIMIT 1), 'Gary', 'SBA VetCert', NULL, '202-205-7585', 'SBA VetCert Contact', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Angela', 'Strother', 'astrother@chestercountysc.gov', '803-385-5133', 'VA Building Reservation - Roddey County Building', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Anurag "Andy"', 'Gupta', 'anurag009@yahoo.com', '571-223-2000', '123 Kennedy Landlord', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'MJ Salon / Nails / Hair', '(South Carolina)', NULL, '864-213-2020', 'Professional Hair and Nail Care Salon', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Amanda', 'Patterson', 'clinical@goforward.com', '833-334-6393', 'MD, Primary Doc', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Tamara', 'Ince', 'tamara@incecounseling.com', '8339688255', 'Therapist, Ince Counseling', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), '(No First Name)', 'Nails', NULL, NULL, 'Nail Salons [LIST]', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), '(No First Name)', 'Doctors', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Behaving Better' AND is_deleted=0 LIMIT 1), 'Chauncey', 'Glenn', 'contact@behavingbetter.co', '3474048509', 'Behaving Better, Investing More', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='SamariCare Services' AND is_deleted=0 LIMIT 1), 'Monique', 'Randall', 'mrandall04@gmail.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='SamariCare Services' AND is_deleted=0 LIMIT 1), 'Sonya', 'Smalls', 'sonyarenee213@gmail.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='US Department of Energy' AND is_deleted=0 LIMIT 1), 'Henry Clay', 'Mckoy JR', 'henry.mckoy@hq.doe.gov', NULL, 'Director', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='ISI, Ltd. | ISI Race and Sports' AND is_deleted=0 LIMIT 1), 'Ernest', 'Matthews IV', 'ernest@isisports.com', '1-954-478-8758', 'Vice President/General Counsel', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), '(No First Name)', 'Robotics', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Rashad', 'Moore', 'rm@score3.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Cassie', 'Duan', 'cassie@coffeerobot.com', '853 6858 9137', 'Lead / POC', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Freddie Mac' AND is_deleted=0 LIMIT 1), 'Erwin', 'Godoy', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Sparket' AND is_deleted=0 LIMIT 1), 'Evan', 'Fisher', 'fish@betsparket.com', '818 687 3622', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Sparket' AND is_deleted=0 LIMIT 1), 'Sophia', 'Kaczeus', 'sophiaak@betsparket.com', '970-556-9029', 'Customer Success Manager', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Sparket' AND is_deleted=0 LIMIT 1), 'Tory', 'Key', 'tkey@betsparket.com', '434 987 0642', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Diana', 'Buffington', 'diana@brainc.ws', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='DC9 Nightclub' AND is_deleted=0 LIMIT 1), 'Bill', 'Spieler', 'bill@dcnine.com', '202-483-5000', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), '(No First Name)', 'Bank/Loan/Financial/Finance', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Latino Economic Development Center' AND is_deleted=0 LIMIT 1), 'J.B.', 'Behrens', 'jbehrens@ledcmetro.org', '301-500-0876', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Sonia', 'Alam', NULL, '202-902-7324', 'Alternative Psychiatry Doctor', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Nubia', 'Chong', 'info@pieurwellness.com', '202-902-7324', 'Pieur Wellness, Psychiatrist', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Harbor Bank' AND is_deleted=0 LIMIT 1), 'Jill', 'Burch', 'jburch@theharborbank.com', NULL, 'Executive Assistant', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Harbor Bank' AND is_deleted=0 LIMIT 1), 'John', 'Lewis', 'JLewis@theharborbank.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='APX Appendix WO' AND is_deleted=0 LIMIT 1), 'Andre', 'Smith', 'dre@appendixworks.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Small Business Administration - SBA' AND is_deleted=0 LIMIT 1), 'John', 'Perkins', 'john.perkins@sba.gov', '202-798-7750', 'Director Veteran Small Business Certification Program', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='allBETs' AND is_deleted=0 LIMIT 1), 'Francesca', 'Turner', 'francesca.turner15@gmail.com', '4046431031', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='allBETs' AND is_deleted=0 LIMIT 1), 'Michael', 'Johnson', 'mike@3.0nexus.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='allBETs' AND is_deleted=0 LIMIT 1), 'Kunle', 'Adeyinka', 'aadeyink@gmail.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='allBETs' AND is_deleted=0 LIMIT 1), 'Dax', 'Fax', 'dax@allbetsgo.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Athena' AND is_deleted=0 LIMIT 1), 'Summer', 'Cerveza', 'summer.cerveza@athenago.com', NULL, 'Executive Assistant', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Athena' AND is_deleted=0 LIMIT 1), 'Abby', 'Diamond', 'abby@athenago.com', NULL, 'Client Coach', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='SyCipLaw Center' AND is_deleted=0 LIMIT 1), 'Alexander', 'S. Barlis', 'asbarlis@syciplaw.com', NULL, 'Secretary to Atty. Russel L. Rodriguez', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='SyCipLaw Center' AND is_deleted=0 LIMIT 1), 'Russel', 'L. Rodriguez', 'rlrodriguez@syciplaw.com', '632 8982 3500', 'Attorney', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Wukela Law Firm' AND is_deleted=0 LIMIT 1), 'Pheobe', 'Clark', 'pclark@wukelalaw.com', '(843) 669-5634', 'Attorney', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='SB22' AND is_deleted=0 LIMIT 1), 'Steve', 'Laity', 'steve.laity@sb22.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='SB22' AND is_deleted=0 LIMIT 1), 'Vladimir', 'Jovanivic', 'vlada@sb22.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Wukela Law Firm' AND is_deleted=0 LIMIT 1), 'Nina', 'Stone', 'nstone@wukelalaw.com', '843-669-5634', 'Legal Assistant to Pheobe A. Clark, Esq', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Dash Capital' AND is_deleted=0 LIMIT 1), 'Samantha', 'Beidoun', 'samanthab@dashcapital.com', '586-995-0419', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Crowell & Moring U.K. LLP' AND is_deleted=0 LIMIT 1), 'Mark', 'Forster', 'MForster@crowell.com', '44 7971 181 380', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='TrustLaw - Thomson Reuters Foundation' AND is_deleted=0 LIMIT 1), 'Livia', 'Fry', 'livia.fry@thomsonreuters.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='TrustLaw - Thomson Reuters Foundation' AND is_deleted=0 LIMIT 1), 'Samantha', 'Biggio', 'Samantha.Biggio@thomsonreuters.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='TrustLaw - Thomson Reuters Foundation' AND is_deleted=0 LIMIT 1), 'Guillermo', 'Torrejon', 'Guillermo.Torrejon@thomsonreuters.com', '44 7407876031', 'Legal Manager, EMENA TrustLaw', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='TrustLaw - Thomson Reuters Foundation' AND is_deleted=0 LIMIT 1), 'Jane', 'Nzomo', 'Jane.Nzomo@thomsonreuters.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Easier Accounting' AND is_deleted=0 LIMIT 1), 'Wyatt', 'McEvoy', 'wyatt@easieraccounting.com', '435-319-8832', 'Small Business Advisor', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Winners Only' AND is_deleted=0 LIMIT 1), 'Vince', 'Lozano', 'vincelozano.8@gmail.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='CareAcademy' AND is_deleted=0 LIMIT 1), 'Sarah', 'Cotta', 'scotta@careacademy.com', '617-380-4777', 'Customer Success Manager', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='CareAcademy' AND is_deleted=0 LIMIT 1), 'Erika', 'Sessions', 'esessions@careacademy.com', '503-869-0630', 'Compliance & Policy Development Director, CareAcademy.com', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='CareAcademy' AND is_deleted=0 LIMIT 1), 'Helen', 'Adeosun', 'helen@careacademy.com', '1.866.227.3895', 'CEO and Founder, CareAcademy.com (ext. 701)', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='CareAcademy' AND is_deleted=0 LIMIT 1), 'Bianca', 'Shimada', 'bianca@careacademy.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Renewal by Andersen of the Carolinas' AND is_deleted=0 LIMIT 1), 'Travis', 'Britt', 'tbritt@renewalcarolinas.com', '704467 5354', 'Project Consultant Renewal by Andersen of the Carolinas', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='CareAcademy' AND is_deleted=0 LIMIT 1), 'Andrew', 'Mantuano', 'amantuano@careacademy.com', NULL, 'Director of Content, CareAcademy', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='CareAcademy' AND is_deleted=0 LIMIT 1), 'Tracy', 'Huckabee', 'thuckabee@careacademy.com', NULL, 'VP of Content Quality, CareAcademy', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Euphoria Residential Home LLC' AND is_deleted=0 LIMIT 1), 'Errika', 'Lowe', 'errikalowe@gmail.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='SamariCare Services' AND is_deleted=0 LIMIT 1), 'Admin', 'SamariCare Services', 'admin@samaricareservices.com', '757-383-9000', 'Admin Email', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='SC Works' AND is_deleted=0 LIMIT 1), 'Anita', 'Eagle', 'anita.eagle@equusworks.com', '803-868-6608', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='SC Works' AND is_deleted=0 LIMIT 1), 'Michael', 'O\'Donnell', 'Michael.Odonnell@equusworks.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Apple' AND is_deleted=0 LIMIT 1), 'Apple', 'Developer Account', 'devprograms@apple.com', NULL, 'Developer Account Support', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='1RACE' AND is_deleted=0 LIMIT 1), 'Saafir', 'Rabb', 'saafir@interculture.com', NULL, 'CEO at 1RACE, CEO at Interculture', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Zoho POCs / Developers / Tech People' AND is_deleted=0 LIMIT 1), 'Masdouk', 'Adelakoun', 'masdouk@techma.ca', NULL, 'Zoho Developer', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Angela', 'Benton', 'ab@angelabenton.co', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Pay Your Tuition Foundation' AND is_deleted=0 LIMIT 1), 'McRobert', 'Obioma', 'mcrobertobioma@gmail.com', '(416) 833-6832', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Pay Your Tuition Foundation' AND is_deleted=0 LIMIT 1), 'Richard "Dick"', 'Adams', 'dickadams@gopyt.com', '+14056257645', 'Co-founder at Pay Your Tuition Foundation', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Pay Your Tuition Foundation' AND is_deleted=0 LIMIT 1), 'Jaycrislie', 'Boon', 'pytscholarships@gopyt.org', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Department of Medical Assistance Services [DMAS]' AND is_deleted=0 LIMIT 1), 'Deanna', 'Harvey', 'Deanna.Harvey@dmas.virginia.gov', '804 692 3250', 'PEU, DMAS', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='ISI, Ltd. | ISI Race and Sports' AND is_deleted=0 LIMIT 1), 'Bill', 'Stearns', 'bill@isisports.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Tax Hive' AND is_deleted=0 LIMIT 1), 'Gordon', 'White', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Metro Strategies LLC' AND is_deleted=0 LIMIT 1), 'Maurice', 'Daniel', 'Maurice@MetroStrategies.us', '202-903-3264', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='(Chop House) Jackie DC' AND is_deleted=0 LIMIT 1), '(No First Name)', 'Jonathan', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='DC Department of Small & Local Business Development (DSLBD)' AND is_deleted=0 LIMIT 1), 'Angela', 'Freeman', 'angela.freeman2@dc.gov', '202-450-7994', 'Business Development Specialist at DSLBD', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='DC Department of Small & Local Business Development (DSLBD)' AND is_deleted=0 LIMIT 1), 'Charlene', 'Louis', 'charlene.louis@dc.gov', '202-578-2063', 'Public Information Officer at DSLBD', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='DC Department of Small & Local Business Development (DSLBD)' AND is_deleted=0 LIMIT 1), 'Keith', 'Howard', 'keith.howard3@dc.gov', '202-578-2481', 'Manager, Business Opportunities Division at DSLBD', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='HealWellMind' AND is_deleted=0 LIMIT 1), 'Reji', 'Abhilash', 'contact@healwellmind.com', '(301)-883-9800', 'Ph.D., C-DBT, CCATP, ADHD-CCSP, Licensed Psychologist', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Heartcast Media' AND is_deleted=0 LIMIT 1), 'Molly', 'Ruland', 'molly@heartcastmedia.com', '50687566568', 'CEO & Founder, Heartcast Media', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Cushman & Wakefield' AND is_deleted=0 LIMIT 1), 'Matthew', 'Goldberg', 'matthew.goldberg@cushwake.com', '347 266 3027', 'Senior Director Tenant Advisory Group at Cushman & Wakefield', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), '(No First Name)', 'buyer 1', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), '(No First Name)', 'buyer 2', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Small Business Administration - SBA' AND is_deleted=0 LIMIT 1), 'Courtney', 'Tresler', NULL, '202 855 7024', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='TruVista' AND is_deleted=0 LIMIT 1), 'Wesley', 'Jennings', 'wesley.jennings@truvista.biz', '864-202-2640', 'Sr. Account Manager at TruVista', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NLSE - Next Level Sports & Entertainment' AND is_deleted=0 LIMIT 1), 'Carin', 'Mercado', 'carin@atlasstrategy.group', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NLSE - Next Level Sports & Entertainment' AND is_deleted=0 LIMIT 1), 'Michael', 'Blake', 'michael.blake@nlse.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NLSE - Next Level Sports & Entertainment' AND is_deleted=0 LIMIT 1), 'David', 'Echeverria', 'david@atlasstrategy.group', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), '(No First Name)', 'Tech Contacts', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Lelaye', 'Nwandu', 'nwandulela@gmail.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Small Business Administration - SBA' AND is_deleted=0 LIMIT 1), '(No First Name)', 'VetCert Counselor', NULL, '(202) 389-6606', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Small Business Administration - SBA' AND is_deleted=0 LIMIT 1), '(No First Name)', 'Sally', NULL, '(202) 401-2510', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='SENTIENT LAW, LTD' AND is_deleted=0 LIMIT 1), 'Matthew M.', 'Rossetti', 'matt@sentientlaw.com', '(512) 430-1150', 'Managing Partner/Lawyer at SENTIENT LAW, LTD', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='SENTIENT LAW, LTD' AND is_deleted=0 LIMIT 1), 'Sean', 'Lanagan', 'sean@sentientlaw.com', '(512) 553-5807', 'Attorney/Partner at SENTIENT LAW LTD.', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='FAMR Federal Award Management Registration' AND is_deleted=0 LIMIT 1), 'Jason', 'Cribbis', 'jason.cribbis@famr.us', '(813) 906-2484', 'Senior Contract Advisor, Federal Award Management Registration', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Thryv' AND is_deleted=0 LIMIT 1), '(No First Name)', 'Thryv URL Team', NULL, '844 998 4798', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='S.C. Dept. of Health & Environmental Control - DHEC' AND is_deleted=0 LIMIT 1), 'Lorna', 'Cardenas', 'cardenlp@dhec.sc.gov', '(803) 609-8610', 'Architect, DHEC', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='W+W Associates Architects PC' AND is_deleted=0 LIMIT 1), 'Gayll', 'Worsley', 'worsley.gayll@gmail.com', '202 491 8309', 'Principal , W+W Associates Architects PC', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='MID WEST WASHINGTON FUNDING LLC' AND is_deleted=0 LIMIT 1), 'Wilson', 'Delmar', 'info.midwestfunding@gmail.com', '(307) 274-8070', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), '(No First Name)', 'Saint Thomas', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), '(No First Name)', 'Realtor', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Goldman Law Offices, Inc.' AND is_deleted=0 LIMIT 1), 'Leigh', 'Goldman', 'lgoldman@goldmanlaw-vi.com', '(340) 715-5162', 'Attorney, Esq at Goldman Law Offices, Inc.', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Goldman Law Offices, Inc.' AND is_deleted=0 LIMIT 1), 'Olean', 'Techeira', 'olean@goldmanlaw-vi.com', '(340) 715-5162', 'Real Estate Paralegal at Goldman Law Offices, Inc.', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Goldvey Consulting LLC' AND is_deleted=0 LIMIT 1), 'Ingrid', 'Widvey', 'ingrid@goldvey.com', '561-765-1655', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='DEMERS Real Estate, Inc.' AND is_deleted=0 LIMIT 1), 'Jonathan (Jon)', 'Wilson', 'jwilson@demersre.com', '202 232-0950', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='HABC - Housing Authority of Baltimore City' AND is_deleted=0 LIMIT 1), 'Tonya', 'Small', 'tonya.small@habc.org', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='OLG' AND is_deleted=0 LIMIT 1), 'Peter', 'Alvarado', 'peter.alvarado@dc.gov', '202.788.2100', 'DIRECTOR of Regulation & Oversight Division in Office of Lottery and Gaming', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='OLG' AND is_deleted=0 LIMIT 1), 'Burt', 'Foster', 'burt.foster@dc.gov', '202.257.6207', 'Audit & Compliance Officer in Office of the Chief Financial Officer Regulation and Oversight Divisi', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), '(No First Name)', 'Investors and Funders', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Vienna Capital Advisors' AND is_deleted=0 LIMIT 1), 'Dennis', 'Sprouse II', 'dsprouse@viennacapitaladvisors.com', '720-843-2659', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Vienna Capital Advisors' AND is_deleted=0 LIMIT 1), 'Jeff', 'Halverson', 'Jeff@viennacapitaladvisors.com', '321.987.7172', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Construction / Architect / Engineer /', 'Contractor', NULL, NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Fred Baruchman and Associates' AND is_deleted=0 LIMIT 1), 'Fred', 'Baruchman', 'fredwag1957@gmail.com', '(404) 376-0821', 'Architect R.A., NCARB', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Upstate Construction Services LLC' AND is_deleted=0 LIMIT 1), 'Walker', 'Jackson', 'upstateconstructionllc@yahoo.com', '803 374 1383', 'Consultant to Architect', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Eversheds Sutherland' AND is_deleted=0 LIMIT 1), 'Henrik', 'Strand', 'henrikstrand@eversheds-sutherland.com', '1.206-434-7015', 'Attorney at Eversheds Sutherland', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='USVI Office of Disaster Recovery' AND is_deleted=0 LIMIT 1), 'Adrienne L.', 'Williams', 'awilliams@usvipfa.com', NULL, 'Director, USVI Office of Disaster Recovery', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Chester, South Carolina' AND is_deleted=0 LIMIT 1), 'Malik', 'Whitaker', 'mwhitaker@chester.sc.gov', '803-581-2123', 'City Administrator', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='CardioCare' AND is_deleted=0 LIMIT 1), 'Stephanie', 'Conn', NULL, '(301) 656-5050', 'Cardiology Doctor', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Stephen', 'Coss', 'scoss@myeyedr.com', '864.322.9050', 'Optometrist, MyEyeDr. Eye Doctor', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Rosemont Care Group' AND is_deleted=0 LIMIT 1), 'Asher', 'Rosenberg', 'asher@rosemontcaregroup.com', '929.475.4673', 'President at Rosemont Care Group', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='OVA Property Maintenance' AND is_deleted=0 LIMIT 1), 'Miguel', 'Bautista', 'propertyova@gmail.com', '(803) 234-1746', 'General Manager to OVA', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='MHCDO - Marshall Heights Community Development Organization, Inc.' AND is_deleted=0 LIMIT 1), 'Babatunde A.', 'Oloyede', 'boloyede@mhcdo.org', '(202) 650-5658', 'President and CEO at MHCDO', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Cushman & Wakefield' AND is_deleted=0 LIMIT 1), 'Sophie', 'Van Pelt', 'Sophie.Vanpelt@cushwake.com', '+1 973-647-9758', 'Retail Broker Washington, DC Metro Region', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'James H', 'Frank', NULL, '202-945-4474', 'Gastroenterology MD', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Stokes-Farnham Insurance Agency' AND is_deleted=0 LIMIT 1), 'Tom', 'Bates', 'Tom@stokesfarnham.com', '864-270-0023', 'Market President at Stokes-Farnham Insurance', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Tiffanie N.', 'McNair', 'TMcNair@killeentexas.gov', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='VDH Virginia Department of Health' AND is_deleted=0 LIMIT 1), 'Kim', 'Kalten', 'Kim.Kalten@vdh.virginia.gov', '(804) 658-6843', 'RN', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='VDH Virginia Department of Health' AND is_deleted=0 LIMIT 1), 'Yolanda', 'Wallace', 'yolanda.wallace@vdh.virginia.gov', '804-718-5892', 'Medical Facilities Inspector Office of Licensure and Certification Division of Acute Care Servi', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='VDH Virginia Department of Health' AND is_deleted=0 LIMIT 1), 'Robyn Wandrick RN', 'Wandrick RN', 'Robyn.Wandrick@vdh.virginia.gov', '804-367-2132', 'Office of Licensure and Certification Division of Acute Care Services', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Citi Bank' AND is_deleted=0 LIMIT 1), 'Blair', 'Washington', 'blair.washington@citi.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Citi Bank' AND is_deleted=0 LIMIT 1), 'Colin', 'Ryan', 'colin.ryan@citi.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Department of Veteran Affairs' AND is_deleted=0 LIMIT 1), 'Lawrence E.', 'Wright, VRC', 'lawrence.wright@va.gov', NULL, 'Veteran Readiness and Employment (VR&E) Intake Center DVA', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='NSP Foundation' AND is_deleted=0 LIMIT 1), 'Dana', 'Holmes', 'info.1913fintech@gmail.com', NULL, NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='South Carolina Department of Health and Human Services [SCDHHS]' AND is_deleted=0 LIMIT 1), 'Debora', 'Carter', 'carterdb@sedhhs.gov', '(803) 898-2612', 'Compliance Review Officer Provider Relations & Compliance Community Long Term Care', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='The No Hair Club' AND is_deleted=0 LIMIT 1), 'Tracy', 'Etheridge', 'thenohairclub@gmail.com', '(864) 494-5958', NULL, 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='J & K Automotive Auto & Truck Repair' AND is_deleted=0 LIMIT 1), 'David', 'Bloodsworth', 'david@jkautomotivellc.com', '(864) 334-5159', 'Mechanic / Owner, J & K AUTOMOTIVE AUTO & TrUCK RePair', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Restore Hyper Wellness' AND is_deleted=0 LIMIT 1), 'Becca', 'Yates', 'ryates@restore.com', NULL, 'Aesthetician', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='South Carolina Department of Health and Human Services [SCDHHS]' AND is_deleted=0 LIMIT 1), 'Reggie', 'DeLaine, CPM, PSC', 'delainer@scdhhs.gov', '8036222591', 'Physical Security Manager, Information Assurance | SOUTH CAROLINA Healthy Connections MEDICAID', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='The Centr' AND is_deleted=0 LIMIT 1), 'Amy', 'Johnson', 'ajohnson@thecentr.com', '800.608.1792', 'MBA, Finance Manager The Centr', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='The Centr' AND is_deleted=0 LIMIT 1), 'Mia', 'Paulus', 'mia@thecentr.com', NULL, 'Founder & Chief Visionary Officer', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Thryv' AND is_deleted=0 LIMIT 1), 'Raymond', 'Sarante', 'raymondemil.sarantereyes@thryv.com', '844-339-4574', 'Thryv URL Management', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='Aristocrat Gaming' AND is_deleted=0 LIMIT 1), 'Stephanie', 'Barrett', 'stephanietbarrett@gmail.com', NULL, 'Head of Decision Support, North America Finance at Aristocrat Gaming', 'Active', 3, 3, 0;

INSERT INTO dim_contacts (tenant_id, company_id, first_name, last_name, email, phone, role, status, created_by, updated_by, is_deleted)
SELECT 1, (SELECT id FROM dim_companies WHERE tenant_id=1 AND company_name='WRK' AND is_deleted=0 LIMIT 1), 'Alex', 'Field', 'alex.field@wrk.com', NULL, NULL, 'Active', 3, 3, 0;

