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',
    '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',
    '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',
    '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',
    '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',
    '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,
    'INVOICED',
    '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,
    'INVOICED',
    '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,
    '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,
    '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,
    'INVOICED',
    '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,
    'INVOICED',
    '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,
    '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,
    'INVOICED',
    '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,
    'INVOICED',
    '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,
    '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,
    'INVOICED',
    '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,
    'INVOICED',
    '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,
    '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,
    '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,
    'INVOICED',
    '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,
    '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,
    '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,
    'INVOICED',
    '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,
    '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,
    'INVOICED',
    '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,
    '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,
    '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,
    'INVOICED',
    '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,
    '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,
    '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,
    '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,
    '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,
    '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,
    '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,
    '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,
    '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,
    'INVOICED',
    '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,
    '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,
    '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,
    '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,
    'INVOICED',
    '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,
    'INVOICED',
    '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,
    '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,
    '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,
    '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,
    '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,
    '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,
    '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,
    '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,
    '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,
    '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,
    '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
  (
    2176,
    '4',
    'Onyx Therapy Group',
    'Normal',
    55,
    '2025-06',
    12,
    25575.72,
    9.00,
    2301.81,
    '1.50',
    383.64,
    1918.18,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2177,
    '4',
    'Onyx Therapy Group',
    'Normal',
    47,
    '2025-06',
    13,
    9016.79,
    9.00,
    811.51,
    '1.00',
    90.17,
    721.34,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2178,
    '4',
    'Onyx Therapy Group',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    150.00,
    '0',
    0.00,
    150.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2179,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    38,
    '2025-06',
    12,
    15999.56,
    8.50,
    1359.96,
    '3.00',
    479.99,
    879.98,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2180,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    47,
    '2025-06',
    13,
    5334.14,
    8.50,
    453.40,
    '1.00',
    53.34,
    400.06,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2181,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    412.74,
    '0',
    0.00,
    412.74,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2182,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2025-06',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2183,
    '21',
    'Donna Reid Washington, LPC',
    'Fixed',
    NULL,
    '2025-06',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2184,
    '21',
    'Donna Reid Washington, LPC',
    'Normal',
    38,
    '2025-06',
    12,
    4026.98,
    8.00,
    322.16,
    '3.00',
    120.81,
    201.35,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2185,
    '21',
    'Donna Reid Washington, LPC',
    'Normal',
    47,
    '2025-06',
    13,
    895.00,
    8.00,
    71.60,
    '1.00',
    8.95,
    62.65,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2186,
    '21',
    'Donna Reid Washington, LPC',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    116.50,
    '0',
    0.00,
    116.50,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2187,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    42,
    '2025-06',
    12,
    11848.59,
    8.50,
    1007.13,
    '2.00',
    236.97,
    770.16,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2188,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    47,
    '2025-06',
    13,
    2644.35,
    8.50,
    224.77,
    '1.00',
    26.44,
    198.33,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2189,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    146.30,
    '0',
    0.00,
    146.30,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2190,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2191,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    42,
    '2025-06',
    12,
    1654.49,
    8.50,
    140.63,
    '2.00',
    33.09,
    107.54,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2192,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    47,
    '2025-06',
    13,
    659.00,
    8.50,
    56.02,
    '1.00',
    6.59,
    49.42,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2193,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    3.55,
    '0',
    0.00,
    3.55,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2194,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Normal',
    NULL,
    '2025-06',
    12,
    919.68,
    8.50,
    78.17,
    NULL,
    0.00,
    78.17,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2195,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Normal',
    47,
    '2025-06',
    13,
    25.00,
    8.50,
    2.13,
    '1.00',
    0.25,
    1.88,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2196,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    1.43,
    '0',
    0.00,
    1.43,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2197,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    15.00,
    '0',
    0.00,
    15.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-03',
    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
  (
    2202,
    '5',
    'LaCole Cole, LCPC',
    'Normal',
    NULL,
    '2025-06',
    12,
    7429.58,
    8.50,
    631.51,
    NULL,
    0.00,
    631.51,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2203,
    '5',
    'LaCole Cole, LCPC',
    'Normal',
    47,
    '2025-06',
    13,
    470.00,
    8.50,
    39.95,
    '1.00',
    4.70,
    35.25,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2204,
    '5',
    'LaCole Cole, LCPC',
    'Fixed',
    NULL,
    '2025-06',
    16,
    0.00,
    0.00,
    23.26,
    '0',
    0.00,
    23.26,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2205,
    '5',
    'LaCole Cole, LCPC',
    'Fixed',
    NULL,
    '2025-06',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2208,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    401.10,
    '0',
    0.00,
    401.10,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2209,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2025-07',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2210,
    '21',
    'Donna Reid Washington, LPC',
    'Fixed',
    NULL,
    '2025-07',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2211,
    '21',
    'Donna Reid Washington, LPC',
    'Normal',
    38,
    '2025-07',
    12,
    4119.16,
    8.00,
    329.53,
    '3.00',
    123.57,
    205.96,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2212,
    '21',
    'Donna Reid Washington, LPC',
    'Normal',
    47,
    '2025-07',
    13,
    1210.00,
    8.00,
    96.80,
    '1.00',
    12.10,
    84.70,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2213,
    '21',
    'Donna Reid Washington, LPC',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    85.23,
    '0',
    0.00,
    85.23,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2214,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    38,
    '2025-07',
    12,
    19502.91,
    8.50,
    1657.75,
    '3.00',
    585.09,
    1072.66,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2215,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    47,
    '2025-07',
    13,
    5269.02,
    8.50,
    447.87,
    '1.00',
    52.69,
    395.18,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2216,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2025-07',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2217,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    38,
    '2025-07',
    12,
    9592.07,
    8.00,
    767.37,
    '3.00',
    287.76,
    479.60,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2218,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    47,
    '2025-07',
    13,
    1155.38,
    8.00,
    92.43,
    '1.00',
    11.55,
    80.88,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2219,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    78.44,
    '0',
    0.00,
    78.44,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2220,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    42,
    '2025-07',
    12,
    3522.09,
    8.50,
    299.38,
    '2.00',
    70.44,
    228.94,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2221,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    NULL,
    '2025-07',
    13,
    1010.98,
    8.50,
    85.93,
    '0',
    0.00,
    85.93,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2222,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2223,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    15.00,
    '0',
    0.00,
    15.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2224,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    NULL,
    '2025-07',
    12,
    9618.47,
    8.00,
    769.48,
    '0',
    0.00,
    769.48,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2225,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    47,
    '2025-07',
    13,
    1082.83,
    8.00,
    86.63,
    '1.00',
    10.83,
    75.80,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2226,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    73.17,
    '0',
    0.00,
    73.17,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2227,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    25.00,
    '0',
    0.00,
    25.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2228,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    55,
    '2025-07',
    12,
    11395.10,
    8.50,
    968.58,
    '1.50',
    170.93,
    797.66,
    'NOT INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2229,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    47,
    '2025-07',
    13,
    582.40,
    8.50,
    49.50,
    '1.00',
    5.82,
    43.68,
    'NOT INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2230,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    86.45,
    '0',
    0.00,
    86.45,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2231,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    70.00,
    '0',
    0.00,
    70.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2232,
    '5',
    'LaCole Cole, LCPC',
    'Normal',
    NULL,
    '2025-07',
    12,
    14585.04,
    8.50,
    1239.73,
    '0',
    0.00,
    1239.73,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2233,
    '5',
    'LaCole Cole, LCPC',
    'Normal',
    47,
    '2025-07',
    13,
    380.00,
    8.50,
    32.30,
    '1.00',
    3.80,
    28.50,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2234,
    '5',
    'LaCole Cole, LCPC',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    22.21,
    '0',
    0.00,
    22.21,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2235,
    '5',
    'LaCole Cole, LCPC',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2236,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    47,
    '2025-07',
    13,
    2323.02,
    7.50,
    174.23,
    '1.00',
    23.23,
    151.00,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2237,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    42,
    '2025-07',
    15,
    21242.55,
    7.50,
    1593.19,
    '2.00',
    424.85,
    1168.34,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2238,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    59.08,
    '0',
    0.00,
    59.08,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2239,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2025-07',
    12,
    0.00,
    0.00,
    60.00,
    '0',
    0.00,
    60.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2240,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    42,
    '2025-07',
    12,
    19365.73,
    8.50,
    1646.09,
    '2.00',
    387.31,
    1258.77,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2241,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    47,
    '2025-07',
    13,
    3229.49,
    8.50,
    274.51,
    '1.00',
    32.29,
    242.21,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2242,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    143.45,
    '0',
    0.00,
    143.45,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2243,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-08-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
  (
    2244,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Normal',
    57,
    '2025-06',
    12,
    23735.16,
    9.00,
    2136.16,
    '1.50',
    356.03,
    1780.14,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-29',
    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
  (
    2245,
    '4',
    'Onyx Therapy Group',
    'Normal',
    57,
    '2025-06',
    12,
    25575.72,
    9.00,
    2301.81,
    '1.50',
    383.64,
    1918.18,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-08-29',
    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
  (
    2247,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    38,
    '2025-07',
    12,
    13047.35,
    8.00,
    1043.79,
    '3.00',
    391.42,
    652.37,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2248,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    47,
    '2025-07',
    13,
    1137.60,
    8.00,
    91.01,
    '1.00',
    11.38,
    79.63,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2249,
    '24',
    'Winnie Moore, LCPC',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    140.60,
    '0',
    0.00,
    140.60,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2250,
    '24',
    'Winnie Moore, LCPC',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2251,
    '12',
    'Joy R. Hart, LCSW-C',
    'Normal',
    38,
    '2025-07',
    12,
    2862.89,
    10.00,
    286.29,
    '3.00',
    85.89,
    200.40,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2252,
    '12',
    'Joy R. Hart, LCSW-C',
    'Normal',
    47,
    '2025-07',
    13,
    724.00,
    10.00,
    72.40,
    '1.00',
    7.24,
    65.16,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2253,
    '12',
    'Joy R. Hart, LCSW-C',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2254,
    '220',
    'Amina Hall, LCSW',
    'Normal',
    42,
    '2025-07',
    12,
    5497.49,
    7.50,
    412.31,
    '2.00',
    109.95,
    302.36,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2255,
    '30',
    'Danielle Rogal-Hudespeth, LCPC',
    'Normal',
    38,
    '2025-07',
    12,
    8763.23,
    9.00,
    788.69,
    '3.00',
    262.90,
    525.79,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2256,
    '30',
    'Danielle Rogal-Hudespeth, LCPC',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    12.00,
    '0',
    0.00,
    12.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2257,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    42,
    '2025-07',
    12,
    2696.95,
    8.50,
    229.24,
    '2.00',
    53.94,
    175.30,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2258,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    47,
    '2025-07',
    13,
    1010.55,
    8.50,
    85.90,
    '1.00',
    10.11,
    75.79,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2259,
    '7',
    'Nji J. Fru, CNPR',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    79.52,
    '0',
    0.00,
    79.52,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-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
  (
    2260,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    NULL,
    '2025-07',
    12,
    1279.84,
    8.50,
    108.79,
    NULL,
    0.00,
    108.79,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2261,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    47,
    '2025-07',
    13,
    730.00,
    8.50,
    62.05,
    '1.00',
    7.30,
    54.75,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2262,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    22.75,
    '0',
    0.00,
    22.75,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2263,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    42,
    '2025-07',
    12,
    2857.66,
    8.50,
    242.90,
    '2.00',
    57.15,
    185.75,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2264,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    47,
    '2025-07',
    13,
    315.00,
    8.50,
    26.78,
    '1.00',
    3.15,
    23.63,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2265,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    5.70,
    '0',
    0.00,
    5.70,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2266,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    NULL,
    '2025-07',
    12,
    7410.24,
    8.50,
    629.87,
    '0',
    0.00,
    629.87,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2267,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    47,
    '2025-07',
    13,
    605.00,
    8.50,
    51.43,
    '1.00',
    6.05,
    45.38,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2268,
    '29',
    'Dalton Johnson, LCPC',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    24.42,
    '0',
    0.00,
    24.42,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2269,
    '217',
    'Elizabeth Merrill, LCSW',
    'Normal',
    42,
    '2025-07',
    12,
    2862.89,
    7.00,
    200.40,
    '2.00',
    57.26,
    143.14,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2270,
    '217',
    'Elizabeth Merrill, LCSW',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2271,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Normal',
    57,
    '2025-07',
    12,
    23093.29,
    9.00,
    2078.40,
    '1.50',
    346.40,
    1732.00,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2272,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Normal',
    47,
    '2025-07',
    13,
    7033.89,
    9.00,
    633.05,
    '1.00',
    70.34,
    562.71,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2273,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2274,
    '4',
    'Onyx Therapy Group',
    'Normal',
    57,
    '2025-07',
    12,
    28912.89,
    9.00,
    2602.16,
    '1.50',
    433.69,
    2168.47,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2275,
    '4',
    'Onyx Therapy Group',
    'Normal',
    47,
    '2025-07',
    13,
    7880.28,
    9.00,
    709.23,
    '1.00',
    78.80,
    630.42,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2276,
    '4',
    'Onyx Therapy Group',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    150.00,
    '0',
    0.00,
    150.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-03',
    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
  (
    2277,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2025-07',
    12,
    1440.31,
    8.00,
    115.22,
    NULL,
    0.00,
    115.22,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2278,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2025-07',
    13,
    25.00,
    8.00,
    2.00,
    NULL,
    0.00,
    2.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2279,
    '10',
    'Yetta Lyle, LCPC',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    8.00,
    '0',
    0.00,
    8.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2280,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2025-07',
    12,
    4818.90,
    7.50,
    361.42,
    '0',
    0.00,
    361.42,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2281,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2025-07',
    13,
    1498.99,
    7.50,
    112.42,
    '0',
    0.00,
    112.42,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2282,
    '19',
    'Nicole Rudd, LCPC',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2283,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2025-07',
    19,
    9197.02,
    7.30,
    671.38,
    NULL,
    0.00,
    671.38,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2284,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2025-07',
    20,
    67691.60,
    7.30,
    4941.49,
    NULL,
    0.00,
    4941.49,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2285,
    '2',
    'Create Your Life, LLC',
    'Normal',
    NULL,
    '2025-07',
    12,
    10051.87,
    8.00,
    804.15,
    '0',
    0.00,
    804.15,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2286,
    '2',
    'Create Your Life, LLC',
    'Normal',
    NULL,
    '2025-07',
    13,
    2092.79,
    8.00,
    167.42,
    NULL,
    0.00,
    167.42,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2287,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2025-07',
    16,
    0.00,
    0.00,
    171.05,
    '0',
    0.00,
    171.05,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2288,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    50.00,
    '0',
    0.00,
    50.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2289,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2025-07',
    18,
    0.00,
    0.00,
    10.00,
    '0',
    0.00,
    10.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2290,
    '227',
    'Trusted Therapeutic Services',
    'Normal',
    NULL,
    '2025-07',
    12,
    1357.90,
    7.00,
    95.05,
    NULL,
    0.00,
    95.05,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2291,
    '227',
    'Trusted Therapeutic Services',
    'Normal',
    NULL,
    '2025-07',
    13,
    290.00,
    7.00,
    20.30,
    NULL,
    0.00,
    20.30,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2292,
    '227',
    'Trusted Therapeutic Services',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    8.00,
    '0',
    0.00,
    8.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2293,
    '230',
    'Renewing Minds',
    'Normal',
    NULL,
    '2025-07',
    12,
    12049.76,
    4.50,
    542.24,
    NULL,
    0.00,
    542.24,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2294,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2025-07',
    12,
    4124.47,
    7.50,
    309.34,
    NULL,
    0.00,
    309.34,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2295,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2025-07',
    13,
    509.72,
    7.50,
    38.23,
    '0',
    0.00,
    38.23,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-04',
    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
  (
    2296,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2025-08',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2297,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    38,
    '2025-08',
    12,
    9008.90,
    8.00,
    720.71,
    '3.00',
    270.27,
    450.44,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2298,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    47,
    '2025-08',
    13,
    1104.15,
    8.00,
    88.33,
    '1.00',
    11.04,
    77.29,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2299,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2025-08',
    16,
    0.00,
    0.00,
    64.30,
    '0',
    0.00,
    64.30,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2300,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    42,
    '2025-08',
    12,
    2458.03,
    8.50,
    208.93,
    '2.00',
    49.16,
    159.77,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2301,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    NULL,
    '2025-08',
    13,
    905.98,
    8.50,
    77.01,
    NULL,
    0.00,
    77.01,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2302,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    NULL,
    '2025-08',
    16,
    0.00,
    8.50,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2303,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    15.00,
    '0',
    0.00,
    15.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2304,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    NULL,
    '2025-08',
    12,
    9523.63,
    8.00,
    761.89,
    NULL,
    0.00,
    761.89,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2305,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    47,
    '2025-08',
    13,
    925.00,
    8.00,
    74.00,
    '1.00',
    9.25,
    64.75,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2306,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2025-08',
    16,
    0.00,
    0.00,
    51.45,
    '0',
    0.00,
    51.45,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2307,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    25.00,
    '0',
    0.00,
    25.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2308,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    57,
    '2025-08',
    12,
    5076.67,
    8.00,
    406.13,
    '1.50',
    76.15,
    329.98,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2309,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    57,
    '2025-08',
    12,
    9740.35,
    8.50,
    827.93,
    '1.50',
    146.11,
    681.82,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2310,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    47,
    '2025-08',
    13,
    1169.12,
    8.50,
    99.38,
    '1.00',
    11.69,
    87.68,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2311,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2025-08',
    16,
    0.00,
    0.00,
    99.75,
    '0',
    0.00,
    99.75,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2312,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    70.00,
    '0',
    0.00,
    70.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2313,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    47,
    '2025-08',
    13,
    1813.80,
    7.50,
    136.03,
    '1.00',
    18.14,
    117.90,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2314,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    NULL,
    '2025-08',
    15,
    22416.90,
    7.50,
    1681.27,
    NULL,
    0.00,
    1681.27,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2315,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2025-08',
    16,
    0.00,
    0.00,
    86.23,
    '0',
    0.00,
    86.23,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2316,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2025-08',
    12,
    0.00,
    0.00,
    60.00,
    '0',
    0.00,
    60.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2317,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    42,
    '2025-08',
    12,
    8169.81,
    7.50,
    612.74,
    '2.00',
    163.40,
    449.34,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2318,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    57,
    '2025-08',
    12,
    14247.09,
    7.50,
    1068.53,
    '1.50',
    213.71,
    854.83,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2319,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    42,
    '2025-07',
    12,
    7487.67,
    8.00,
    599.01,
    '2.00',
    149.75,
    449.26,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2320,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    47,
    '2025-07',
    13,
    927.92,
    8.00,
    74.23,
    '1.00',
    9.28,
    64.95,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2321,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2025-07',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2322,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2025-07',
    23,
    0.00,
    0.00,
    26.90,
    '0',
    0.00,
    26.90,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-09-19',
    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
  (
    2323,
    '231',
    'Test F Provider ',
    'Normal',
    NULL,
    '2025-09',
    10,
    25480.00,
    5.00,
    1274.00,
    '0',
    0.00,
    1274.00,
    'INVOICED',
    NULL,
    'Sajith Wickramasena',
    1,
    '2025-09-22',
    32
  );
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
  (
    2324,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    57,
    '2025-07',
    12,
    11395.10,
    8.50,
    968.58,
    '1.50',
    170.93,
    797.66,
    'NOT INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-09-25',
    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
  (
    2325,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    38,
    '2025-08',
    12,
    9061.70,
    8.00,
    724.94,
    '3.00',
    271.85,
    453.09,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2326,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    47,
    '2025-08',
    13,
    1264.57,
    8.00,
    101.17,
    '1.00',
    12.65,
    88.52,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2327,
    '24',
    'Winnie Moore, LCPC',
    'Fixed',
    NULL,
    '2025-08',
    16,
    0.00,
    0.00,
    68.40,
    '0',
    0.00,
    68.40,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2328,
    '24',
    'Winnie Moore, LCPC',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2329,
    '12',
    'Joy R. Hart, LCSW-C',
    'Normal',
    38,
    '2025-08',
    12,
    2888.02,
    10.00,
    288.80,
    '3.00',
    86.64,
    202.16,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2330,
    '12',
    'Joy R. Hart, LCSW-C',
    'Normal',
    47,
    '2025-08',
    13,
    450.00,
    10.00,
    45.00,
    '1.00',
    4.50,
    40.50,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2331,
    '12',
    'Joy R. Hart, LCSW-C',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2332,
    '220',
    'Amina Hall, LCSW',
    'Normal',
    42,
    '2025-08',
    12,
    3361.08,
    7.50,
    252.08,
    '2.00',
    67.22,
    184.86,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2333,
    '30',
    'Danielle Rogal-Hudespeth, LCPC',
    'Normal',
    38,
    '2025-08',
    12,
    9652.81,
    9.00,
    868.75,
    '3.00',
    289.58,
    579.17,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2334,
    '30',
    'Danielle Rogal-Hudespeth, LCPC',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    24.00,
    '0',
    0.00,
    24.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2335,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    42,
    '2025-08',
    12,
    2374.32,
    8.50,
    201.82,
    '2.00',
    47.49,
    154.33,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2336,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    47,
    '2025-08',
    13,
    626.29,
    8.50,
    53.23,
    '1.00',
    6.26,
    46.97,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2337,
    '7',
    'Nji J. Fru, CNPR',
    'Fixed',
    NULL,
    '2025-08',
    16,
    0.00,
    0.00,
    54.01,
    '0',
    0.00,
    54.01,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2341,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    NULL,
    '2025-08',
    12,
    1344.32,
    8.50,
    114.27,
    '0',
    0.00,
    114.27,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2342,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    47,
    '2025-08',
    13,
    520.00,
    8.50,
    44.20,
    '1.00',
    5.20,
    39.00,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2343,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Fixed',
    NULL,
    '2025-08',
    16,
    0.00,
    0.00,
    25.25,
    '0',
    0.00,
    25.25,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2344,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    42,
    '2025-08',
    12,
    828.87,
    8.50,
    70.45,
    '2.00',
    16.58,
    53.88,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2345,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    42,
    '2025-08',
    12,
    862.69,
    8.50,
    73.33,
    '2.00',
    17.25,
    56.07,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2346,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    47,
    '2025-08',
    13,
    266.00,
    8.50,
    22.61,
    '1.00',
    2.66,
    19.95,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2347,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Fixed',
    NULL,
    '2025-08',
    23,
    0.00,
    0.00,
    4.33,
    '0',
    0.00,
    4.33,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2348,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    NULL,
    '2025-08',
    12,
    4168.25,
    8.50,
    354.30,
    NULL,
    0.00,
    354.30,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2349,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    47,
    '2025-08',
    13,
    897.34,
    8.50,
    76.27,
    '1.00',
    8.97,
    67.30,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2350,
    '29',
    'Dalton Johnson, LCPC',
    'Fixed',
    NULL,
    '2025-08',
    16,
    0.00,
    0.00,
    18.94,
    '0',
    0.00,
    18.94,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2351,
    '217',
    'Elizabeth Merrill, LCSW',
    'Normal',
    42,
    '2025-08',
    12,
    483.39,
    7.00,
    33.84,
    '2.00',
    9.67,
    24.17,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2352,
    '217',
    'Elizabeth Merrill, LCSW',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2353,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Normal',
    57,
    '2025-08',
    12,
    18893.17,
    9.00,
    1700.39,
    '1.50',
    283.40,
    1416.99,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2354,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Normal',
    47,
    '2025-08',
    13,
    5683.35,
    9.00,
    511.50,
    '1.00',
    56.83,
    454.67,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2355,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    20.00,
    '0',
    0.00,
    20.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2356,
    '4',
    'Onyx Therapy Group',
    'Normal',
    57,
    '2025-08',
    12,
    31338.53,
    9.00,
    2820.47,
    '1.50',
    470.08,
    2350.39,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2357,
    '4',
    'Onyx Therapy Group',
    'Normal',
    47,
    '2025-08',
    13,
    8502.86,
    9.00,
    765.26,
    '1.00',
    85.03,
    680.23,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2358,
    '4',
    'Onyx Therapy Group',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    150.00,
    '0',
    0.00,
    150.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2359,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2025-08',
    12,
    1189.92,
    8.00,
    95.19,
    NULL,
    0.00,
    95.19,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2360,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2025-08',
    13,
    110.00,
    8.00,
    8.80,
    NULL,
    0.00,
    8.80,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2361,
    '10',
    'Yetta Lyle, LCPC',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    52.00,
    '0',
    0.00,
    52.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2362,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2025-08',
    12,
    15886.84,
    7.50,
    1191.51,
    NULL,
    0.00,
    1191.51,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2363,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2025-08',
    13,
    620.00,
    7.50,
    46.50,
    NULL,
    0.00,
    46.50,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2364,
    '19',
    'Nicole Rudd, LCPC',
    'Fixed',
    NULL,
    '2025-08',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2365,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2025-08',
    19,
    8009.90,
    7.30,
    584.72,
    NULL,
    0.00,
    584.72,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2366,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2025-08',
    20,
    0.00,
    7.30,
    0.00,
    NULL,
    0.00,
    0.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2367,
    '2',
    'Create Your Life, LLC',
    'Normal',
    NULL,
    '2025-08',
    12,
    12711.24,
    8.00,
    1016.90,
    NULL,
    0.00,
    1016.90,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2368,
    '2',
    'Create Your Life, LLC',
    'Normal',
    47,
    '2025-08',
    13,
    1879.11,
    8.00,
    150.33,
    '1.00',
    18.79,
    131.54,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2369,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2025-08',
    16,
    0.00,
    0.00,
    164.74,
    '0',
    0.00,
    164.74,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2370,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    50.00,
    '0',
    0.00,
    50.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2371,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2025-08',
    18,
    0.00,
    0.00,
    10.00,
    '0',
    0.00,
    10.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2372,
    '2',
    'Create Your Life, LLC',
    'Normal',
    42,
    '2025-08',
    12,
    8550.69,
    8.00,
    684.06,
    '2.00',
    171.01,
    513.04,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2373,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    42,
    '2025-08',
    12,
    2910.73,
    8.00,
    232.86,
    '2.00',
    58.21,
    174.64,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2374,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    47,
    '2025-08',
    13,
    1492.47,
    8.00,
    119.40,
    '1.00',
    14.92,
    104.47,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2375,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2376,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2025-08',
    23,
    0.00,
    0.00,
    50.18,
    '0',
    0.00,
    50.18,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2377,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2025-08',
    12,
    2496.64,
    7.50,
    187.25,
    '0',
    0.00,
    187.25,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2378,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2025-08',
    13,
    281.45,
    7.50,
    21.11,
    NULL,
    0.00,
    21.11,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2379,
    '36',
    'Sothia Green, PsyD',
    'Fixed',
    NULL,
    '2025-08',
    16,
    0.00,
    0.00,
    93.60,
    '0',
    0.00,
    93.60,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2380,
    '227',
    'Trusted Therapeutic Services',
    'Normal',
    NULL,
    '2025-08',
    12,
    899.44,
    7.00,
    62.96,
    NULL,
    0.00,
    62.96,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2381,
    '227',
    'Trusted Therapeutic Services',
    'Normal',
    NULL,
    '2025-08',
    13,
    325.00,
    7.00,
    22.75,
    NULL,
    0.00,
    22.75,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2382,
    '227',
    'Trusted Therapeutic Services',
    'Fixed',
    NULL,
    '2025-08',
    15,
    0.00,
    0.00,
    4.00,
    '0',
    0.00,
    4.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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
  (
    2383,
    '230',
    'Renewing Minds',
    'Normal',
    NULL,
    '2025-08',
    12,
    23006.61,
    4.50,
    1035.30,
    NULL,
    0.00,
    1035.30,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-10-03',
    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'[BLOB]