INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1416,
    '8',
    'Samantha Knox, LPC',
    'Normal',
    47,
    '2024-11',
    13,
    6135.67,
    9.00,
    552.21,
    '1.00',
    61.36,
    490.85,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1417,
    '8',
    'Samantha Knox, LPC',
    'Fixed',
    NULL,
    '2024-11',
    15,
    0.00,
    0.00,
    12.00,
    '0',
    0.00,
    12.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1418,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2024-11',
    12,
    1671.91,
    8.00,
    133.75,
    NULL,
    0.00,
    133.75,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1419,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2024-11',
    13,
    135.00,
    8.00,
    10.80,
    '0',
    0.00,
    10.80,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1420,
    '10',
    'Yetta Lyle, LCPC',
    'Fixed',
    NULL,
    '2024-11',
    15,
    0.00,
    0.00,
    4.00,
    '0',
    0.00,
    4.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1421,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    53,
    '2024-11',
    12,
    4984.66,
    7.50,
    373.85,
    '1.50',
    74.77,
    299.08,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1422,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2024-11',
    13,
    100.00,
    7.50,
    7.50,
    NULL,
    0.00,
    7.50,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1423,
    '19',
    'Nicole Rudd, LCPC',
    'Fixed',
    NULL,
    '2024-11',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1424,
    '2',
    'Create Your Life, LLC',
    'Normal',
    NULL,
    '2024-11',
    12,
    9851.47,
    8.00,
    788.12,
    NULL,
    0.00,
    788.12,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1425,
    '2',
    'Create Your Life, LLC',
    'Normal',
    47,
    '2024-11',
    13,
    2095.19,
    8.00,
    167.62,
    '1.00',
    20.95,
    146.66,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1426,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-11',
    16,
    0.00,
    0.00,
    275.07,
    '0',
    0.00,
    275.07,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1427,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-11',
    15,
    0.00,
    0.00,
    50.00,
    '0',
    0.00,
    50.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1428,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-11',
    18,
    0.00,
    0.00,
    10.00,
    '0',
    0.00,
    10.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1429,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    NULL,
    '2024-11',
    12,
    2331.44,
    8.00,
    186.52,
    '0',
    0.00,
    186.52,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1430,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    47,
    '2024-11',
    13,
    728.42,
    8.00,
    58.27,
    '1.00',
    7.28,
    50.99,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1431,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2024-11',
    16,
    0.00,
    0.00,
    403.45,
    '0',
    0.00,
    403.45,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1432,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2024-11',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1433,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2024-11',
    12,
    1444.43,
    7.50,
    108.33,
    NULL,
    0.00,
    108.33,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1434,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2024-11',
    13,
    441.36,
    7.50,
    33.10,
    NULL,
    0.00,
    33.10,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1435,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2024-10',
    12,
    817.19,
    7.50,
    61.29,
    '0',
    0.00,
    61.29,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1436,
    '224',
    'Grace and Mercy Community Services, Inc.',
    'Normal',
    NULL,
    '2024-11',
    19,
    13111.91,
    4.00,
    524.48,
    NULL,
    0.00,
    524.48,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1437,
    '224',
    'Grace and Mercy Community Services, Inc.',
    'Normal',
    NULL,
    '2024-11',
    20,
    15580.32,
    4.00,
    623.21,
    NULL,
    0.00,
    623.21,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1438,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2024-11',
    19,
    17955.53,
    7.30,
    1310.75,
    NULL,
    0.00,
    1310.75,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1439,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2024-11',
    20,
    24879.21,
    7.30,
    1816.18,
    NULL,
    0.00,
    1816.18,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1440,
    '4',
    'Onyx Therapy Group',
    'Normal',
    NULL,
    '2024-11',
    12,
    14669.46,
    9.00,
    1320.25,
    NULL,
    0.00,
    1320.25,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1441,
    '4',
    'Onyx Therapy Group',
    'Normal',
    47,
    '2024-11',
    13,
    5075.23,
    9.00,
    456.77,
    '1.00',
    50.75,
    406.02,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1442,
    '4',
    'Onyx Therapy Group',
    'Fixed',
    NULL,
    '2024-11',
    15,
    0.00,
    0.00,
    150.00,
    '0',
    0.00,
    150.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2024-12-30',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1443,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    38,
    '2024-11',
    12,
    16571.14,
    8.50,
    1408.55,
    '3.00',
    497.13,
    911.41,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1444,
    '20',
    'Carla D. Washington, LPC',
    'Normal',
    47,
    '2024-11',
    13,
    5304.69,
    8.50,
    450.90,
    '1.00',
    53.05,
    397.85,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1446,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2024-11',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1447,
    '21',
    'Donna Reid Washington, LPC',
    'Fixed',
    NULL,
    '2024-11',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1448,
    '21',
    'Donna Reid Washington, LPC',
    'Normal',
    38,
    '2024-11',
    12,
    3949.50,
    8.00,
    315.96,
    '3.00',
    118.48,
    197.47,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1449,
    '21',
    'Donna Reid Washington, LPC',
    'Normal',
    47,
    '2024-11',
    13,
    1070.27,
    8.00,
    85.62,
    '1.00',
    10.70,
    74.92,
    'INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1450,
    '21',
    'Donna Reid Washington, LPC',
    'Fixed',
    NULL,
    '2024-11',
    16,
    0.00,
    0.00,
    116.71,
    '0',
    0.00,
    116.71,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1451,
    '20',
    'Carla D. Washington, LPC',
    'Fixed',
    NULL,
    '2024-11',
    16,
    0.00,
    0.00,
    472.24,
    '0',
    0.00,
    472.24,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1452,
    '5',
    'LaCole Cole, LCPC',
    'Normal',
    NULL,
    '2024-11',
    12,
    11521.67,
    8.50,
    979.34,
    NULL,
    0.00,
    979.34,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1453,
    '5',
    'LaCole Cole, LCPC',
    'Normal',
    NULL,
    '2024-11',
    13,
    855.00,
    8.50,
    72.68,
    NULL,
    0.00,
    72.68,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1454,
    '5',
    'LaCole Cole, LCPC',
    'Fixed',
    NULL,
    '2024-11',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1455,
    '5',
    'LaCole Cole, LCPC',
    'Fixed',
    NULL,
    '2024-11',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1456,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    NULL,
    '2024-11',
    12,
    11859.77,
    8.50,
    1008.08,
    NULL,
    0.00,
    1008.08,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1457,
    '34',
    'Better Days Counseling, LLC',
    'Normal',
    47,
    '2024-11',
    13,
    3593.24,
    8.50,
    305.43,
    '1.00',
    35.93,
    269.49,
    'NOT INVOICED',
    'INVOICED',
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1458,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2024-11',
    16,
    0.00,
    0.00,
    347.20,
    '0',
    0.00,
    347.20,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1459,
    '34',
    'Better Days Counseling, LLC',
    'Fixed',
    NULL,
    '2024-11',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'NOT INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1460,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    42,
    '2024-12',
    12,
    2993.91,
    8.50,
    254.48,
    '2.00',
    59.88,
    194.60,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1461,
    '16',
    'Donna R. Inman, LPC',
    'Normal',
    NULL,
    '2024-12',
    13,
    586.91,
    8.50,
    49.89,
    NULL,
    0.00,
    49.89,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1462,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1463,
    '16',
    'Donna R. Inman, LPC',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    15.00,
    '0',
    0.00,
    15.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1464,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    NULL,
    '2024-12',
    12,
    10164.86,
    8.00,
    813.19,
    NULL,
    0.00,
    813.19,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1465,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Normal',
    47,
    '2024-12',
    13,
    1075.00,
    8.00,
    86.00,
    '1.00',
    10.75,
    75.25,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1466,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    82.58,
    '0',
    0.00,
    82.58,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1467,
    '1',
    'Jacqueline R. Williams, LCSW',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    25.00,
    '0',
    0.00,
    25.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1468,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    NULL,
    '2024-12',
    12,
    3966.98,
    8.50,
    337.19,
    NULL,
    0.00,
    337.19,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1469,
    '31',
    'The Bridges Wellness Group',
    'Normal',
    47,
    '2024-12',
    13,
    435.00,
    8.50,
    36.98,
    '1.00',
    4.35,
    32.63,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1470,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    159.60,
    '0',
    0.00,
    159.60,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1471,
    '31',
    'The Bridges Wellness Group',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    70.00,
    '0',
    0.00,
    70.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1472,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    42,
    '2024-12',
    12,
    18794.54,
    7.50,
    1409.59,
    '2.00',
    375.89,
    1033.70,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1473,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1474,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    70.88,
    '0',
    0.00,
    70.88,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1475,
    '214',
    'For Every Mountain Counseling Services, LLC',
    'Normal',
    47,
    '2024-12',
    13,
    2186.31,
    7.50,
    163.97,
    '1.00',
    21.86,
    142.11,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1476,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2024-12',
    14,
    0.00,
    0.00,
    189.00,
    '0',
    0.00,
    189.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1477,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    38,
    '2024-12',
    12,
    26868.64,
    8.00,
    2149.49,
    '3.00',
    806.06,
    1343.43,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1478,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Normal',
    47,
    '2024-12',
    13,
    154.17,
    8.00,
    12.33,
    '1.00',
    1.54,
    10.79,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1479,
    '17',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    27.50,
    '0',
    0.00,
    27.50,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-01-21',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1480,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    38,
    '2024-12',
    12,
    12666.20,
    8.00,
    1013.30,
    '3.00',
    379.99,
    633.31,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1481,
    '24',
    'Winnie Moore, LCPC',
    'Normal',
    47,
    '2024-12',
    13,
    682.00,
    8.00,
    54.56,
    '1.00',
    6.82,
    47.74,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1482,
    '24',
    'Winnie Moore, LCPC',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    73.15,
    '0',
    0.00,
    73.15,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1483,
    '24',
    'Winnie Moore, LCPC',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1484,
    '12',
    'Joy R. Hart, LCSW-C',
    'Normal',
    38,
    '2024-12',
    12,
    7317.88,
    10.00,
    731.79,
    '3.00',
    219.54,
    512.25,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1485,
    '12',
    'Joy R. Hart, LCSW-C',
    'Normal',
    47,
    '2024-12',
    13,
    666.00,
    10.00,
    66.60,
    '1.00',
    6.66,
    59.94,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1486,
    '12',
    'Joy R. Hart, LCSW-C',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    75.00,
    '0',
    0.00,
    75.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1487,
    '220',
    'Amina Hall, LCSW',
    'Normal',
    42,
    '2024-12',
    12,
    4965.82,
    7.50,
    372.44,
    '2.00',
    99.32,
    273.12,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1488,
    '30',
    'Danielle Rogal-Hudespeth, LCPC',
    'Normal',
    38,
    '2024-12',
    12,
    6492.77,
    9.00,
    584.35,
    '3.00',
    194.78,
    389.57,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1489,
    '30',
    'Danielle Rogal-Hudespeth, LCPC',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    8.00,
    '0',
    0.00,
    8.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1490,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Normal',
    NULL,
    '2024-12',
    12,
    1241.46,
    8.50,
    105.52,
    NULL,
    0.00,
    105.52,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1491,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Normal',
    47,
    '2024-12',
    13,
    0.00,
    8.50,
    0.00,
    '1.00',
    0.00,
    0.00,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1492,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1493,
    '3',
    'Karena Wilson-Plater, PsyD',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    15.00,
    '0',
    0.00,
    15.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1494,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    NULL,
    '2024-12',
    12,
    1013.92,
    8.50,
    86.18,
    NULL,
    0.00,
    86.18,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1495,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Normal',
    47,
    '2024-12',
    13,
    0.00,
    8.50,
    0.00,
    '1.00',
    0.00,
    0.00,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1496,
    '15',
    'Glenda Bullock-Willis, LCPC',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    16.75,
    '0',
    0.00,
    16.75,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1497,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    NULL,
    '2024-12',
    12,
    3873.14,
    8.50,
    329.22,
    NULL,
    0.00,
    329.22,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1498,
    '7',
    'Nji J. Fru, CNPR',
    'Normal',
    47,
    '2024-12',
    13,
    475.12,
    8.50,
    40.39,
    '1.00',
    4.75,
    35.63,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1499,
    '7',
    'Nji J. Fru, CNPR',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    12.07,
    '0',
    0.00,
    12.07,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1500,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    42,
    '2024-12',
    12,
    1732.11,
    8.50,
    147.23,
    '2.00',
    34.64,
    112.59,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1501,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Normal',
    47,
    '2024-12',
    13,
    345.98,
    8.50,
    29.41,
    '1.00',
    3.46,
    25.95,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1502,
    '14',
    'Gillian Blackman-Diarra, LCSW-C',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    16.15,
    '0',
    0.00,
    16.15,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1503,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    NULL,
    '2024-12',
    12,
    4031.55,
    8.50,
    342.68,
    NULL,
    0.00,
    342.68,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1504,
    '29',
    'Dalton Johnson, LCPC',
    'Normal',
    47,
    '2024-12',
    13,
    75.00,
    8.50,
    6.38,
    '1.00',
    0.75,
    5.63,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1505,
    '29',
    'Dalton Johnson, LCPC',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    13.04,
    '0',
    0.00,
    13.04,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1506,
    '216',
    'Elisa Ndombele-Sisler, Psy.D.',
    'Normal',
    NULL,
    '2024-12',
    12,
    9026.28,
    9.00,
    812.37,
    NULL,
    0.00,
    812.37,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1507,
    '216',
    'Elisa Ndombele-Sisler, Psy.D.',
    'Normal',
    47,
    '2024-12',
    13,
    3167.40,
    9.00,
    285.07,
    '1.00',
    31.67,
    253.39,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1508,
    '216',
    'Elisa Ndombele-Sisler, Psy.D.',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1509,
    '216',
    'Elisa Ndombele-Sisler, Psy.D.',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    15.11,
    '0',
    0.00,
    15.11,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1510,
    '217',
    'Elizabeth Merrill, LCSW',
    'Normal',
    42,
    '2024-12',
    12,
    831.62,
    7.00,
    58.21,
    '2.00',
    16.63,
    41.58,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1511,
    '217',
    'Elizabeth Merrill, LCSW',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1512,
    '8',
    'Samantha Knox, LPC',
    'Normal',
    NULL,
    '2024-12',
    12,
    11272.07,
    9.00,
    1014.49,
    NULL,
    0.00,
    1014.49,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1513,
    '8',
    'Samantha Knox, LPC',
    'Normal',
    47,
    '2024-12',
    13,
    6203.23,
    9.00,
    558.29,
    '1.00',
    62.03,
    496.26,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1514,
    '8',
    'Samantha Knox, LPC',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    0.00,
    '0',
    0.00,
    0.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1515,
    '4',
    'Onyx Therapy Group',
    'Normal',
    NULL,
    '2024-12',
    12,
    18554.34,
    9.00,
    1669.89,
    NULL,
    0.00,
    1669.89,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1516,
    '4',
    'Onyx Therapy Group',
    'Normal',
    47,
    '2024-12',
    13,
    9910.11,
    9.00,
    891.91,
    '1.00',
    99.10,
    792.81,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1517,
    '4',
    'Onyx Therapy Group',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    150.00,
    '0',
    0.00,
    150.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1518,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2024-12',
    12,
    879.52,
    8.00,
    70.36,
    NULL,
    0.00,
    70.36,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1519,
    '10',
    'Yetta Lyle, LCPC',
    'Normal',
    NULL,
    '2024-12',
    13,
    55.00,
    8.00,
    4.40,
    '0',
    0.00,
    4.40,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1520,
    '10',
    'Yetta Lyle, LCPC',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    20.00,
    '0',
    0.00,
    20.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1521,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    53,
    '2024-12',
    12,
    7980.34,
    7.50,
    598.53,
    '1.50',
    119.71,
    478.82,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1522,
    '19',
    'Nicole Rudd, LCPC',
    'Normal',
    NULL,
    '2024-12',
    13,
    635.00,
    7.50,
    47.63,
    NULL,
    0.00,
    47.63,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1523,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2024-12',
    19,
    29572.23,
    7.30,
    2158.77,
    NULL,
    0.00,
    2158.77,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1524,
    '37',
    'Caring Hands  Behavioral Health Center',
    'Normal',
    NULL,
    '2024-12',
    20,
    9756.91,
    7.30,
    712.25,
    NULL,
    0.00,
    712.25,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1525,
    '2',
    'Create Your Life, LLC',
    'Normal',
    NULL,
    '2024-12',
    12,
    12083.81,
    8.00,
    966.70,
    NULL,
    0.00,
    966.70,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1526,
    '2',
    'Create Your Life, LLC',
    'Normal',
    47,
    '2024-12',
    13,
    5307.64,
    8.00,
    424.61,
    '1.00',
    53.08,
    371.53,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1527,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    224.26,
    '0',
    0.00,
    224.26,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1528,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    50.00,
    '0',
    0.00,
    50.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1529,
    '2',
    'Create Your Life, LLC',
    'Fixed',
    NULL,
    '2024-12',
    18,
    0.00,
    0.00,
    10.00,
    '0',
    0.00,
    10.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1530,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    NULL,
    '2024-12',
    12,
    4558.40,
    8.00,
    364.67,
    '0',
    0.00,
    364.67,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1531,
    '13',
    'Karen L. Allen, LCSW-C',
    'Normal',
    47,
    '2024-12',
    13,
    1152.13,
    8.00,
    92.17,
    '1.00',
    11.52,
    80.65,
    'INVOICED',
    'NOT INVOICED',
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1532,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2024-12',
    16,
    0.00,
    0.00,
    156.08,
    '0',
    0.00,
    156.08,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1533,
    '13',
    'Karen L. Allen, LCSW-C',
    'Fixed',
    NULL,
    '2024-12',
    15,
    0.00,
    0.00,
    30.00,
    '0',
    0.00,
    30.00,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1534,
    '224',
    'Grace and Mercy Community Services, Inc.',
    'Normal',
    NULL,
    '2024-12',
    19,
    10859.63,
    4.00,
    434.39,
    NULL,
    0.00,
    434.39,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1535,
    '224',
    'Grace and Mercy Community Services, Inc.',
    'Normal',
    NULL,
    '2024-12',
    19,
    10859.63,
    4.00,
    434.39,
    NULL,
    0.00,
    434.39,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1536,
    '224',
    'Grace and Mercy Community Services, Inc.',
    'Normal',
    NULL,
    '2024-12',
    20,
    8671.36,
    4.00,
    346.85,
    NULL,
    0.00,
    346.85,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1537,
    '224',
    'Grace and Mercy Community Services, Inc.',
    'Normal',
    NULL,
    '2024-12',
    20,
    8671.36,
    4.00,
    346.85,
    NULL,
    0.00,
    346.85,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1538,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2024-12',
    12,
    655.14,
    7.50,
    49.14,
    NULL,
    0.00,
    49.14,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );
INSERT INTO
  `collection_table` (
    `id`,
    `prov_id`,
    `provider`,
    `type`,
    `contractor`,
    `coll_period`,
    `service`,
    `coll_amount`,
    `billing_rate`,
    `billing_amount`,
    `rate`,
    `commission`,
    `profit`,
    `prov_status`,
    `con_status`,
    `created_by`,
    `created_by_id`,
    `created_at`,
    `company`
  )
VALUES
  (
    1539,
    '222',
    'Linda Kalle',
    'Normal',
    NULL,
    '2024-12',
    13,
    820.77,
    7.50,
    61.56,
    NULL,
    0.00,
    61.56,
    'INVOICED',
    NULL,
    'Irish  Smith',
    2,
    '2025-02-05',
    1
  );

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

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