INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2108,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    38,
    '2025-06',
    12,
    8122.57,
    8.00,
    649.81,
    '3.00',
    243.68,
    406.13,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2109,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    47,
    '2025-06',
    13,
    637.21,
    8.00,
    50.98,
    '1.00',
    6.37,
    44.60,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2110,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    76.80,
    '0',
    0.00,
    76.80,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-07-17',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2111,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    42,
    '2025-06',
    12,
    2549.94,
    8.50,
    216.74,
    '2.00',
    51.00,
    165.75,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2112,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    NULL,
    '2025-06',
    13,
    984.29,
    8.50,
    83.66,
    NULL,
    0.00,
    83.66,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2113,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2114,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    15.00,
    '0',
    0.00,
    15.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2115,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    NULL,
    '2025-06',
    12,
    9420.18,
    8.00,
    753.61,
    NULL,
    0.00,
    753.61,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2116,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    47,
    '2025-06',
    13,
    385.00,
    8.00,
    30.80,
    '1.00',
    3.85,
    26.95,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2117,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    56.38,
    '0',
    0.00,
    56.38,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2118,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    25.00,
    '0',
    0.00,
    25.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2120,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    NULL,
    '2025-06',
    12,
    14249.58,
    8.50,
    1211.21,
    NULL,
    0.00,
    1211.21,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2121,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    47,
    '2025-06',
    13,
    435.00,
    8.50,
    36.98,
    '1.00',
    4.35,
    32.63,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2122,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    76.00,
    '0',
    0.00,
    76.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2123,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    70.00,
    '0',
    0.00,
    70.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2124,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    42,
    '2025-06',
    13,
    23035.36,
    7.50,
    1727.65,
    '2.00',
    460.71,
    1266.94,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2125,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    47,
    '2025-06',
    15,
    1982.35,
    7.50,
    148.68,
    '1.00',
    19.82,
    128.85,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2126,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    73.95,
    '0',
    0.00,
    73.95,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2127,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2025-06',
    12,
    0.00,
    0.00,
    60.00,
    '0',
    0.00,
    60.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-07-18',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2129,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    38,
    '2025-06',
    12,
    14484.11,
    8.00,
    1158.73,
    '3.00',
    434.52,
    724.21,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2130,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    47,
    '2025-06',
    13,
    783.00,
    8.00,
    62.64,
    '1.00',
    7.83,
    54.81,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2131,
    '24',
    'Winnie Moore, LCPC',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    110.20,
    '0',
    0.00,
    110.20,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2132,
    '24',
    'Winnie Moore, LCPC',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2133,
    '12',
    'Joy R. Hart, LCSW-C',
    'Normal',
    38,
    '2025-06',
    12,
    3061.99,
    10.00,
    306.20,
    '3.00',
    91.86,
    214.34,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2134,
    '12',
    'Joy R. Hart, LCSW-C',
    'Normal',
    47,
    '2025-06',
    13,
    220.00,
    10.00,
    22.00,
    '1.00',
    2.20,
    19.80,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2135,
    '12',
    'Joy R. Hart, LCSW-C',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2136,
    '220',
    'Amina Hall, LCSW',
    'Normal',
    42,
    '2025-06',
    12,
    5074.54,
    7.50,
    380.59,
    '2.00',
    101.49,
    279.10,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2137,
    '30',
    'Danielle Rogal-Hudespeth, LCPC',
    'Normal',
    38,
    '2025-06',
    12,
    10467.44,
    9.00,
    942.07,
    '3.00',
    314.02,
    628.05,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2138,
    '30',
    'Danielle Rogal-Hudespeth, LCPC',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    4.00,
    '0',
    0.00,
    4.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2139,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    42,
    '2025-06',
    12,
    2522.85,
    8.50,
    214.44,
    '2.00',
    50.46,
    163.99,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2140,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    47,
    '2025-06',
    13,
    595.24,
    8.50,
    50.60,
    '1.00',
    5.95,
    44.64,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2141,
    '7',
    'Nji J. Fru, CNPR',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    66.59,
    '0',
    0.00,
    66.59,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2142,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    NULL,
    '2025-06',
    12,
    1122.58,
    8.50,
    95.42,
    NULL,
    0.00,
    95.42,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2143,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    47,
    '2025-06',
    13,
    30.00,
    8.50,
    2.55,
    '1.00',
    0.30,
    2.25,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2144,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    2.95,
    '0',
    0.00,
    2.95,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2145,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    NULL,
    '2025-06',
    12,
    5837.39,
    8.50,
    496.18,
    NULL,
    0.00,
    496.18,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2146,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    47,
    '2025-06',
    13,
    2896.00,
    8.50,
    246.16,
    '1.00',
    28.96,
    217.20,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2147,
    '29',
    'Dalton Johnson, LCPC',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    20.19,
    '0',
    0.00,
    20.19,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2148,
    '217',
    'Elizabeth Merrill, LCSW',
    'Normal',
    42,
    '2025-06',
    12,
    1029.19,
    7.00,
    72.04,
    '2.00',
    20.58,
    51.46,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2149,
    '217',
    'Elizabeth Merrill, LCSW',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2150,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Normal',
    55,
    '2025-06',
    12,
    23735.16,
    9.00,
    2136.16,
    '1.50',
    356.03,
    1780.14,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2151,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Normal',
    47,
    '2025-06',
    13,
    6108.76,
    9.00,
    549.79,
    '1.00',
    61.09,
    488.70,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2152,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    12.00,
    '0',
    0.00,
    12.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2153,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2025-06',
    12,
    800.79,
    8.00,
    64.06,
    NULL,
    0.00,
    64.06,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2154,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2025-06',
    13,
    120.00,
    8.00,
    9.60,
    NULL,
    0.00,
    9.60,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2155,
    '10',
    'Yetta Lyle, LCPC',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2156,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2025-06',
    12,
    8977.98,
    7.50,
    673.35,
    NULL,
    0.00,
    673.35,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2157,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2025-06',
    13,
    40.00,
    7.50,
    3.00,
    NULL,
    0.00,
    3.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2158,
    '19',
    'Nicole Rudd, LCPC',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2159,
    '2',
    'Create Your Life, LLC',
    'Normal',
    NULL,
    '2025-06',
    12,
    13893.57,
    8.00,
    1111.49,
    '0',
    0.00,
    1111.49,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2160,
    '2',
    'Create Your Life, LLC',
    'Normal',
    47,
    '2025-06',
    13,
    4247.80,
    8.00,
    339.82,
    '1.00',
    42.48,
    297.35,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2161,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    213.88,
    '0',
    0.00,
    213.88,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2162,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    50.00,
    '0',
    0.00,
    50.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2163,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2025-06',
    18,
    0.00,
    0.00,
    10.00,
    '0',
    0.00,
    10.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2164,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    42,
    '2025-06',
    12,
    3751.28,
    8.00,
    300.10,
    '2.00',
    75.03,
    225.08,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2165,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    47,
    '2025-06',
    13,
    395.00,
    8.00,
    31.60,
    '1.00',
    3.95,
    27.65,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2166,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    54.20,
    '0',
    0.00,
    54.20,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2167,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2168,
    '36',
    'Sothia Green, PsyD',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    95.92,
    '0',
    0.00,
    95.92,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2169,
    '227',
    'Trusted Therapeutic Services',
    'Normal',
    NULL,
    '2025-06',
    12,
    560.32,
    7.00,
    39.22,
    NULL,
    0.00,
    39.22,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2170,
    '227',
    'Trusted Therapeutic Services',
    'Normal',
    NULL,
    '2025-06',
    13,
    220.00,
    7.00,
    15.40,
    NULL,
    0.00,
    15.40,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2171,
    '227',
    'Trusted Therapeutic Services',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2172,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2025-06',
    12,
    842.41,
    7.50,
    63.18,
    NULL,
    0.00,
    63.18,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2173,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2025-06',
    13,
    507.41,
    7.50,
    38.06,
    NULL,
    0.00,
    38.06,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2174,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2025-06',
    19,
    9305.17,
    7.30,
    679.28,
    NULL,
    0.00,
    679.28,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2175,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2025-06',
    20,
    41473.97,
    7.30,
    3027.60,
    NULL,
    0.00,
    3027.60,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-02',
    1
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: company_details_table
# ------------------------------------------------------------

INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`,
    `CreatedID`
  )
VALUES
  (
    1,
    'Billing Plus, Inc.',
    '461361749',
    '3012023739',
    'ismith@billing-plus.com',
    'www.billing-plus.com',
    'Irish Smith',
    '3012023739',
    '2006-07-15',
    '1899-11-30',
    '4315 Northview Drive\r\nBowie, MD  20716',
    '',
    NULL,
    NOFORMAT_WRAP(
      "##X'[encoded data, 482605 characters]