INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2767,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2026-01',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2768,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    38,
    '2026-01',
    12,
    534.69,
    8.00,
    42.78,
    '3.00',
    16.04,
    26.73,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-02-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2769,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    47,
    '2026-01',
    13,
    255.00,
    8.00,
    20.40,
    '1.00',
    2.55,
    17.85,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-02-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2770,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2026-01',
    16,
    0.00,
    0.00,
    44.20,
    '0',
    0.00,
    44.20,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-16',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2771,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    42,
    '2026-01',
    12,
    1040.74,
    8.50,
    88.46,
    '2.00',
    20.81,
    67.65,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2772,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    NULL,
    '2026-01',
    13,
    556.83,
    8.50,
    47.33,
    NULL,
    0.00,
    47.33,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2773,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2026-01',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2774,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    15.00,
    '0',
    0.00,
    15.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2775,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    57,
    '2026-01',
    12,
    8009.55,
    8.00,
    640.76,
    '1.50',
    120.14,
    520.62,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2776,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    47,
    '2026-01',
    13,
    936.66,
    8.00,
    74.93,
    '1.00',
    9.37,
    65.57,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2777,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    25.00,
    '0',
    0.00,
    25.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2778,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2026-01',
    23,
    0.00,
    0.00,
    42.58,
    '0',
    0.00,
    42.58,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2779,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    57,
    '2026-01',
    12,
    8302.25,
    8.50,
    705.69,
    '1.50',
    124.53,
    581.16,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2780,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    47,
    '2026-01',
    13,
    2527.00,
    8.50,
    214.80,
    '1.00',
    25.27,
    189.53,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2781,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2026-01',
    23,
    0.00,
    0.00,
    14.23,
    '0',
    0.00,
    14.23,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2782,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    70.00,
    '0',
    0.00,
    70.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2783,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    57,
    '2026-01',
    12,
    14709.75,
    7.50,
    1103.23,
    '1.50',
    220.65,
    882.59,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2784,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    60.00,
    '0',
    0.00,
    60.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2785,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2026-01',
    23,
    0.00,
    0.00,
    21.36,
    '0',
    0.00,
    21.36,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2786,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    47,
    '2026-01',
    13,
    1687.75,
    7.50,
    126.58,
    '1.00',
    16.88,
    109.70,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2787,
    '234',
    'Samantha Cobb',
    'Normal',
    NULL,
    '2026-01',
    12,
    972.52,
    7.00,
    68.08,
    '0',
    0.00,
    68.08,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2788,
    '234',
    'Samantha Cobb',
    'Normal',
    NULL,
    '2026-01',
    13,
    302.68,
    7.00,
    21.19,
    NULL,
    0.00,
    21.19,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2789,
    '234',
    'Samantha Cobb',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2791,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    47,
    '2025-12',
    13,
    4564.67,
    8.50,
    388.00,
    '1.00',
    45.65,
    342.35,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2792,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2025-12',
    23,
    0.00,
    0.00,
    307.90,
    '0',
    0.00,
    307.90,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2793,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2025-12',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2794,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    42,
    '2025-12',
    12,
    9886.92,
    8.50,
    840.39,
    '2.00',
    197.74,
    642.65,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2795,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    47,
    '2025-12',
    13,
    2108.02,
    8.50,
    179.18,
    '1.00',
    21.08,
    158.10,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2796,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2025-12',
    23,
    0.00,
    0.00,
    51.46,
    '0',
    0.00,
    51.46,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2797,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2025-12',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-02-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
  (
    2798,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    38,
    '2025-12',
    12,
    20471.16,
    8.50,
    1740.05,
    '3.00',
    614.13,
    1125.91,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2026-02-20',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2799,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    38,
    '2026-01',
    12,
    9898.20,
    8.00,
    791.86,
    '3.00',
    296.95,
    494.91,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2800,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    47,
    '2026-01',
    13,
    701.60,
    8.00,
    56.13,
    '1.00',
    7.02,
    49.11,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2801,
    '24',
    'Winnie Moore, LCPC',
    'Fixed',
    NULL,
    '2026-01',
    23,
    0.00,
    0.00,
    9.43,
    '0',
    0.00,
    9.43,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2802,
    '24',
    'Winnie Moore, LCPC',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2803,
    '12',
    'Joy R. Hart, LCSW-C',
    'Normal',
    38,
    '2026-01',
    12,
    1502.41,
    10.00,
    150.24,
    '3.00',
    45.07,
    105.17,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2804,
    '12',
    'Joy R. Hart, LCSW-C',
    'Normal',
    47,
    '2026-01',
    13,
    50.00,
    10.00,
    5.00,
    '1.00',
    0.50,
    4.50,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2805,
    '12',
    'Joy R. Hart, LCSW-C',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2806,
    '220',
    'Amina Hall, LCSW',
    'Normal',
    42,
    '2026-01',
    12,
    4201.80,
    7.50,
    315.13,
    '2.00',
    84.04,
    231.10,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2807,
    '30',
    'Danielle Rogal-Hudespeth, LCPC',
    'Normal',
    38,
    '2026-01',
    12,
    10054.74,
    9.00,
    904.93,
    '3.00',
    301.64,
    603.28,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2808,
    '30',
    'Danielle Rogal-Hudespeth, LCPC',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    12.00,
    '0',
    0.00,
    12.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2809,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    42,
    '2026-01',
    12,
    2515.97,
    8.50,
    213.86,
    '2.00',
    50.32,
    163.54,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2810,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    47,
    '2026-01',
    13,
    1031.23,
    8.50,
    87.65,
    '1.00',
    10.31,
    77.34,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2811,
    '7',
    'Nji J. Fru, CNPR',
    'Fixed',
    NULL,
    '2026-01',
    23,
    0.00,
    0.00,
    35.30,
    '0',
    0.00,
    35.30,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2812,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    42,
    '2026-01',
    12,
    2753.99,
    8.50,
    234.09,
    '2.00',
    55.08,
    179.01,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2813,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    47,
    '2026-01',
    13,
    0.00,
    8.50,
    0.00,
    '1.00',
    0.00,
    0.00,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2814,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Fixed',
    NULL,
    '2026-01',
    23,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2815,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    42,
    '2026-01',
    12,
    871.97,
    8.50,
    74.12,
    '2.00',
    17.44,
    56.68,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2816,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    47,
    '2026-01',
    13,
    296.77,
    8.50,
    25.23,
    '1.00',
    2.97,
    22.26,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2817,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Fixed',
    NULL,
    '2026-01',
    23,
    0.00,
    0.00,
    3.18,
    '0',
    0.00,
    3.18,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2818,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    NULL,
    '2026-01',
    12,
    867.05,
    8.50,
    73.70,
    NULL,
    0.00,
    73.70,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2819,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    47,
    '2026-01',
    13,
    1103.50,
    8.50,
    93.80,
    '1.00',
    11.04,
    82.76,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2820,
    '29',
    'Dalton Johnson, LCPC',
    'Fixed',
    NULL,
    '2026-01',
    16,
    0.00,
    0.00,
    10.16,
    '0',
    0.00,
    10.16,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2821,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2026-01',
    12,
    101.07,
    8.00,
    8.09,
    '0',
    0.00,
    8.09,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2822,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2026-01',
    13,
    25.00,
    8.00,
    2.00,
    NULL,
    0.00,
    2.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2823,
    '10',
    'Yetta Lyle, LCPC',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    4.00,
    '0',
    0.00,
    4.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2824,
    '217',
    'Elizabeth Merrill, LCSW',
    'Normal',
    42,
    '2026-01',
    12,
    1025.29,
    7.00,
    71.77,
    '2.00',
    20.51,
    51.26,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2825,
    '217',
    'Elizabeth Merrill, LCSW',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2826,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Normal',
    57,
    '2026-01',
    12,
    17371.83,
    9.00,
    1563.46,
    '1.50',
    260.58,
    1302.89,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2827,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Normal',
    47,
    '2026-01',
    13,
    4464.24,
    9.00,
    401.78,
    '1.00',
    44.64,
    357.14,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2828,
    '8',
    'AYA Behavioral Health - Samantha Knox, LPC',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    12.00,
    '0',
    0.00,
    12.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2829,
    '4',
    'Onyx Therapy Group',
    'Normal',
    57,
    '2026-01',
    12,
    18042.68,
    9.00,
    1623.84,
    '1.50',
    270.64,
    1353.20,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2830,
    '4',
    'Onyx Therapy Group',
    'Normal',
    47,
    '2026-01',
    13,
    4460.07,
    9.00,
    401.41,
    '1.00',
    44.60,
    356.81,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2831,
    '4',
    'Onyx Therapy Group',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    150.00,
    '0',
    0.00,
    150.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2832,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2026-01',
    12,
    11181.84,
    7.50,
    838.64,
    NULL,
    0.00,
    838.64,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2833,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2026-01',
    13,
    384.00,
    7.50,
    28.80,
    NULL,
    0.00,
    28.80,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2834,
    '19',
    'Nicole Rudd, LCPC',
    'Fixed',
    NULL,
    '2026-01',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2835,
    '2',
    'Create Your Life, LLC',
    'Normal',
    42,
    '2026-01',
    12,
    6173.04,
    8.00,
    493.84,
    '2.00',
    123.46,
    370.38,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2836,
    '2',
    'Create Your Life, LLC',
    'Normal',
    47,
    '2026-01',
    13,
    2730.10,
    8.00,
    218.41,
    '1.00',
    27.30,
    191.11,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2837,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    50.00,
    '0',
    0.00,
    50.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2838,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2026-01',
    18,
    0.00,
    0.00,
    10.00,
    '0',
    0.00,
    10.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2839,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2026-01',
    23,
    0.00,
    0.00,
    93.71,
    '0',
    0.00,
    93.71,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2840,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    42,
    '2026-01',
    12,
    3157.67,
    8.00,
    252.61,
    '2.00',
    63.15,
    189.46,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2841,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    47,
    '2026-01',
    13,
    580.00,
    8.00,
    46.40,
    '1.00',
    5.80,
    40.60,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2842,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2843,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2026-01',
    23,
    0.00,
    0.00,
    13.14,
    '0',
    0.00,
    13.14,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2844,
    '36',
    'Sothia Green, PsyD',
    'Fixed',
    NULL,
    '2026-01',
    23,
    0.00,
    0.00,
    23.63,
    '0',
    0.00,
    23.63,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2845,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2026-01',
    12,
    13442.78,
    7.50,
    1008.21,
    NULL,
    0.00,
    1008.21,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2846,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2026-01',
    13,
    1596.11,
    7.50,
    119.71,
    NULL,
    0.00,
    119.71,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2847,
    '230',
    'Renewing Minds',
    'Normal',
    NULL,
    '2026-01',
    12,
    55622.90,
    4.50,
    2503.03,
    '0',
    0.00,
    2503.03,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2848,
    '227',
    'Trusted Therapeutic Services',
    'Normal',
    NULL,
    '2026-01',
    12,
    2561.56,
    7.00,
    179.31,
    NULL,
    0.00,
    179.31,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2849,
    '227',
    'Trusted Therapeutic Services',
    'Normal',
    NULL,
    '2026-01',
    13,
    180.00,
    7.00,
    12.60,
    NULL,
    0.00,
    12.60,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2850,
    '227',
    'Trusted Therapeutic Services',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    16.00,
    '0',
    0.00,
    16.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-06',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2851,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2026-02',
    14,
    0.00,
    0.00,
    394.03,
    '0',
    0.00,
    394.03,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2852,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    38,
    '2026-02',
    12,
    11386.99,
    8.00,
    910.96,
    '3.00',
    341.61,
    569.35,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2853,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    47,
    '2026-02',
    13,
    1125.55,
    8.00,
    90.04,
    '1.00',
    11.26,
    78.79,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2854,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2026-02',
    23,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2855,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    38,
    '2026-01',
    12,
    15404.52,
    8.50,
    1309.38,
    '3.00',
    462.14,
    847.25,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2856,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    47,
    '2026-01',
    13,
    2369.42,
    8.50,
    201.40,
    '1.00',
    23.69,
    177.71,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2857,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2026-01',
    23,
    0.00,
    0.00,
    180.43,
    '0',
    0.00,
    180.43,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2858,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2026-01',
    14,
    0.00,
    0.00,
    201.35,
    '0',
    0.00,
    201.35,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2859,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    42,
    '2026-01',
    12,
    32429.87,
    8.50,
    2756.54,
    '2.00',
    648.60,
    2107.94,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2860,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    47,
    '2026-01',
    13,
    2759.07,
    8.50,
    234.52,
    '1.00',
    27.59,
    206.93,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2861,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2026-01',
    23,
    0.00,
    0.00,
    39.38,
    '0',
    0.00,
    39.38,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2862,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2026-01',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2863,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    42,
    '2026-02',
    12,
    3055.28,
    8.50,
    259.70,
    '2.00',
    61.11,
    198.59,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2864,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    47,
    '2026-02',
    13,
    1004.37,
    8.50,
    85.37,
    '1.00',
    10.04,
    75.33,
    'NOT INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2865,
    '7',
    'Nji J. Fru, CNPR',
    'Fixed',
    NULL,
    '2026-02',
    23,
    0.00,
    0.00,
    47.15,
    '0',
    0.00,
    47.15,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2866,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    42,
    '2026-02',
    12,
    1989.94,
    8.50,
    169.14,
    '2.00',
    39.80,
    129.35,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2867,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    NULL,
    '2026-02',
    13,
    1997.38,
    8.50,
    169.78,
    NULL,
    0.00,
    169.78,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2868,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2026-02',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2869,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2026-02',
    15,
    0.00,
    0.00,
    15.00,
    '0',
    0.00,
    15.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2870,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    57,
    '2026-02',
    12,
    7423.77,
    8.00,
    593.90,
    '1.50',
    111.36,
    482.55,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2871,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    47,
    '2026-02',
    13,
    902.74,
    8.00,
    72.22,
    '1.00',
    9.03,
    63.19,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2872,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2026-02',
    15,
    0.00,
    0.00,
    25.00,
    '0',
    0.00,
    25.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2873,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2026-02',
    23,
    0.00,
    0.00,
    39.11,
    '0',
    0.00,
    39.11,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2874,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    57,
    '2026-02',
    12,
    8138.76,
    8.50,
    691.79,
    '1.50',
    122.08,
    569.71,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2875,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    47,
    '2026-02',
    13,
    90.00,
    8.50,
    7.65,
    '1.00',
    0.90,
    6.75,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2876,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2026-02',
    23,
    0.00,
    0.00,
    11.79,
    '0',
    0.00,
    11.79,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2877,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2026-02',
    15,
    0.00,
    0.00,
    70.00,
    '0',
    0.00,
    70.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2878,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    57,
    '2026-02',
    12,
    20331.31,
    7.50,
    1524.85,
    '1.50',
    304.97,
    1219.88,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2879,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    47,
    '2026-02',
    13,
    2736.49,
    7.50,
    205.24,
    '1.00',
    27.36,
    177.87,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2880,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2026-02',
    23,
    0.00,
    0.00,
    24.51,
    '0',
    0.00,
    24.51,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2881,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2026-02',
    15,
    0.00,
    0.00,
    60.00,
    '0',
    0.00,
    60.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2882,
    '234',
    'Samantha Cobb',
    'Normal',
    NULL,
    '2026-02',
    12,
    1626.60,
    7.00,
    113.86,
    NULL,
    0.00,
    113.86,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2883,
    '234',
    'Samantha Cobb',
    'Normal',
    NULL,
    '2026-02',
    13,
    525.20,
    7.00,
    36.76,
    NULL,
    0.00,
    36.76,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    2884,
    '234',
    'Samantha Cobb',
    'Fixed',
    NULL,
    '2026-02',
    15,
    0.00,
    0.00,
    8.00,
    '0',
    0.00,
    8.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2026-03-13',
    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]